Installing the SQL Server database driver for Cognos Transformer
Install the Microsoft SQL Server database driver on the computer where you will host IBM® Cognos® Business Intelligence.
About this task
Attention Windows users: On
Microsoft Windows 2012, Cognos supports OLE DB type to connect SQL
Server database. There is no need to install the database client for
SQL Server, because Windows has the necessary drivers for the OLE
DB connection already built in. When using the default database instance
for SQL Server, leave the metrics.db.local.name property
blank in the cognos-setup.properties file, so
it looks like the following example:
metrics.db.local.name=
Follow these steps to install the SQL Server database driver for Cognos Transformer on AIX and Linux. Cognos supports ODBC type to connect SQL Server database. The only ODBC driver supported by Cognos is "Process DataDirect Connect for ODBC". The driver is not free. To avoid the cost for the licensed driver, consider deploying both Cognos BI and Transformer on Windows.
If you do not use the default database instance, then metrics.db.local.name should be set to the name of the database instance.