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 |
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.