Interface support

Sybase IQ ETL 4.5.1 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.1 Users Guide.

Table 3 lists the interface driver versions supported in Sybase IQ ETL 4.5.1.

**Table 3: Interface driver versions for Sybase IQ 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
Sybase IQ 12.7 ODBC	9.00.02.2056 (Windows only) 10.00.01.3415 (Windows only)
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)