Sybase IQ ETL 4.5 supports these interfaces for connecting to destination or source databases from a component:
Sybase
DB2
ODBC
You must install the ODBC driver on the same computer
as Sybase IQ ETL Development, and you must define a system data source
name (DSN) for the target.
Oracle
OLE DB
SQLite Persistent – support for test environments only.
See “Database connection settings,” in Chapter 5, “Components” in the Sybase IQ ETL 4.5 Users Guide.
Table 3 lists the interface driver versions supported in Sybase IQ ETL 4.5.
Driver |
Version |
---|---|
Sybase native (via Client-Library) |
12.5.2, 15.0 |
Adaptive Server ODBC |
15.00.00.152 (Windows only) |
SQL Anywhere ODBC
|
10.00.01.3415 (Windows only) |
Sybase IQ 12.7 ODBC |
9.00.02.1023 |
IBM DB2 native |
8.1.8.762, 9.01.00.369 |
IBM DB2 ODBC |
8.01.08.762, 9.01.00.369 (Windows only) |
Microsoft Access ODBC |
4.00.6305.00 (Windows only) |
Microsoft SQL Server ODBC |
2000.86.1830.00 (Windows only) |
MySQL |
5.1.4 |
Oracle native (via Oracle Call Interface (OCI)) |
11.01.00.06 |
Oracle ODBC |
11.01.01.06 (Windows only) |