The following table lists the interfaces and databases available for each database component type.
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.