Interfaces

Sybase IQ InfoPrimer supports interfaces for connecting to destination or source databases.

The supported interfaces are:
  • Sybase

  • DB2 – supported only for connecting to source databases.

  • ODBC – you must install the ODBC driver for IQ that comes with Sybase IQ on the same machine where Sybase IQ InfoPrimer Development and Server are running, and you must define a system datasource name (DSN) for the target.

  • Oracle – supported only for connecting to source databases.

  • OLE DB – supported only for connecting to Microsoft SQL (MSSQL) Server source databases.

  • SQLite Persistent – supported only for connecting to source databases.

See Sybase IQ InfoPrimer Users Guide > Extract Transform and Load Projects > ETL Components > Database Connection Settings.