The interfaces supported by ETL Development for connecting to destination or source databases from a component, are:
Sybase
DB2 – only supported for connecting to source databases.
ODBC – you must install the ODBC driver on the same computer as Sybase ETL Development, and you must define a system data source name (DSN) for the target.
Oracle – only supported for connecting to source databases.
OLE DB – only supported for connecting to source databases.
SQLite Persistent – is only supported for connecting to source databases.
See “Database connection settings,” in Chapter 5, “Components” in the Sybase ETL 4.9 Users Guide.
Table 1-2 lists the interface drivers supported by ETL Server.
Driver |
Version |
|---|---|
Sybase native (via Client-Library) |
15.0 ESD #6 (Windows) 15.0 ESD #15 (UNIX and Linux)
|
Adaptive Server® Enterprise ODBC |
15.00.00.325 (Windows only) |
SQL Anywhere ODBC
|
11.00.00 (IQ 12.7 only) |
Sybase IQ 12.7 ODBC |
11.00.00.1264 |
Sybase IQ 15.0 ODBC |
11.00.00.1264 11.00.00.5120 11.00.01.5027 |
Sybase IQ 15.1 ODBC |
11.00.01.5027 |
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 SQL Server ODBC |
2000.86.3959.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) |
These driver version are installed with Sybase ETL installation.