ODBC Data Source Connections

IBM® Cognos® software supports ODBC data sources.

IBM Cognos software divides ODBC connections into two categories: vendor-specific ODBC data sources connections, which use driver-specific capabilities for query creation, and generic ODBC data source connections, which use general capabilities.

IBM Cognos software supports the ODBC data sources listed in the following table. The database code appears in the connection string, but cannot be edited.

Table 1. ODBC data sources and database code
ODBC Data Source	Database code
ODBC	OD
Microsoft SQL Server (ODBC)	SS
Netezza® (ODBC)	NZ
Sybase IQ (ODBC)	IQ
Teradata (ODBC)	TD

Any ODBC data source connection not listed should be created using the generic ODBC data source, database code OD.