There are two types of subscriptions that can connect to JDBC compliant databases.
For more information about upload subscriptions and JDBC subscriptions, see Creating a JDBC subscription and Creating an upload subscription.
For local configurations, the mirror and source databases are located on the same server. You can use the following data sources for JDBC subscriptions:
For remote configurations, the source database and mirror database
are located on different servers. For JDBC subscriptions, use the data
sources described in Table 1.
Table 1. Remote configurations
Source database | Mirror database | Driver |
---|---|---|
DB2 Universal database, Version 7.2 for Windows 2000 | DB2 Universal Database, Version 7.2 | IBM DB2 UDB local |
DB2 Universal database, Version 7.1.0 for z/OS | DB2 Universal Database, Version 7.2 | IBM DB2 UDB local |
Oracle 8i | DB2 Universal Database, Version 7.2 | Oracle Thin drivers 8.1.5 classes111.zip |
DB2 iSeries Version, 5R1 for OS/400 | DB2 Universal Database V7.2 | IBM DB2 UDB local |
Microsoft SQL Server, Version 7.0 for Windows NT | DB2 Universal Database, Version 7.2 | NetDirect JSQL 2.25 driver |
Sybase Adaptive Server Enterprise, Version 11.93 | DB2 Universal Database, Version 7.2 | Sybase J-Connect 4.2 driver |
Informix Server, Version 9 | DB2 Universal Database, Version 7.2 | Informix JDBC driver 1.5 |
NetDirect JSQL is a third-party driver. Microsoft does not provide a JDBC driver for SQL Server.