Database and interface support

The following table lists the interfaces and databases available for each database component type.

Table B-1: Database and interface support matrix

Interface

DB Data Provider and DB Lookup

DB Data Sink

DB Bulk Load Sybase IQ

DB Staging

IQ Loader File via Load Table

IQ Loader DB via Insert Location

SQL Executor

Sybase

ASE

IQ

IQ

IQ

ASE

ASA

IQ

IQ

IQ

ASE

IQ

ODBC

Any data source that can be accessed via ODBC.

IQ

IQ

IQ

ASA

ASE

IQ

Not supported

ASE

IQ

SQL Server

Oracle

OLE DB

SQL Server

Not supported

Not supported

Not supported

Not supported

Not supported

SQL Server

Oracle

Any Oracle database system that can be accessed by Oracle Call Interface (OCI).

Not supported

Not supported

Not supported

Not supported

Not supported

Oracle

DB2

Any DB2 database system that can be accessed by the IBM DB/2 client interface.

Not supported

Not supported

Not supported

Not supported

Not supported

DB2

The Sybase ETL environment has been tested, evaluated, and verified thoroughly to comply with many interface drivers of the supported database systems. If you encounter unexpected results that might be related to driver incompatibility, try installing one of the supported versions for your interfacing driver. See “Interface support” in the Sybase ETL 4.9 Release Bulletin for a list of all interface driver versions supported by Sybase ETL 4.9.