Interface support

Sybase IQ ETL 4.5 supports these interfaces for connecting to destination or source databases from a component:

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.

Table 3: Interface driver versions for Sybase IQ ETL Server

Driver

Version

Sybase native (via Client-Library)

12.5.2, 15.0

Adaptive Server ODBC

15.00.00.152 (Windows only)

SQL Anywhere ODBC

NoteAs of version 10.0, Adaptive Server Anywhere has been renamed SQL Anywhere.

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)