The Database and Interface Support Matrix table lists the interfaces and databases available for each database component type in an ETL or EL project .
In the table, NS indicates the interface is not supported for the database component or the EL project.
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 |
EL Project |
|---|---|---|---|---|---|---|---|---|
Sybase |
ASE IQ ASA |
IQ |
IQ |
ASE ASA IQ |
IQ |
IQ |
ASE IQ ASA |
ASE IQ ASA |
ODBC |
Any datasource that can be accessed via ODBC. |
IQ |
IQ |
IQ ASA ASE |
IQ |
NS |
ASE IQ SQL Server ASA |
Any datasource that can be accessed via ODBC. Only supports an ODBC connection to IQ as a destination. |
OLE DB |
SQL Server |
NS |
NS |
NS |
NS |
NS |
SQL Server |
SQL Server |
Oracle |
Any Oracle database system that can be accessed by Oracle Call Interface (OCI). |
NS |
NS |
NS |
NS |
NS |
Oracle |
Any Oracle database system that can be accessed by Oracle Call Interface (OCI). |
DB2 |
Any DB2 database system that can be accessed by the IBM DB/2 client interface. |
NS |
NS |
NS |
NS |
NS |
DB2 |
Any DB2 database system that can be accessed by the IBM DB/2 client interface. |
| Insert Location | NS |
NS | NS | NS | NS | NS This component uses the Sybase Interface for INSERT LOCATION. |
NS | Any remote server defined on the destination IQ server. |
The Sybase IQ InfoPrimer 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 IQ InfoPrimer Release Bulletin for a list of all supported interface driver versions.