Interfaces

The interfaces supported by ETL Development for connecting to destination or source databases from a component, are:

Sybase
DB2
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
OLE DB
SQLite Persistent – support for test environments only.

See “Database connection settings,” in Chapter 5, “Components” in the Sybase ETL 4.8 Users Guide.

Table 1-3 lists the interface drivers supported by ETL Server.

**Table 1-3: Interface driver versions for Sybase ETL Server**
Driver	Version
Sybase native (via Client-Library)	12.5.2, 15.0 On Linux pSeries, the Sybase native driver (via Client-Library) is the only supported interface.
Adaptive Server® Enterprise ODBC	15.00.00.325 (Windows only)
SQL Anywhere® ODBC As of version 10.0, Adaptive Server Anywhere has been renamed SQL Anywhere.	10.00.01.3415 11.00.00 (IQ 12.7 only)
Sybase IQ 12.7 ODBC	9.00.02.2056 (Windows only) 10.00.01.3415 (Windows only) 11.00.00.1264
Sybase IQ 15.0 ODBC	11.00.00.1264 11.00.00.5120
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) The version number may differ for different Windows operating systems.
Microsoft SQL Server ODBC	20.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)

Sybase IQ 12.7 does not support ODBC driver on Linux pSeries.