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

Sybase

ASE

ASA

IQ

IQ

IQ

ASE

ASA

IQ

IQ

IQ

ODBC

Any data source that can be accessed via ODBC.

IQ

MS-Access

IQ

MS-Access

IQ

ASA

ASE

IQ

unsupported

OLE DB

IQ

SQL-Server

IQ

IQ

IQ

unsupported

unsupported

Oracle

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

unsupported

unsupported

unsupported

unsupported

unsupported

DB2

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

unsupported

unsupported

unsupported

unsupported

unsupported

SQLite Persistent

Any SQLite database file.

unsupported

unsupported

unsupported

unsupported

unsupported

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 to install one of the supported versions for your interfacing driver. See “Interface support” in the Sybase ETL 4.8 Release Bulletin for a list of all interface driver versions that Sybase ETL 4.8 supports.