Question & Answer
Question
How to connect to Microsoft SQL Server datasource from IBM Cognos 10.2.1?
Answer
Classic Mode Connection:
Windows:
Before making the datasource connection in IBM Cognos Administration you will want to make sure that you have installed the Microsoft SQL Server client and the client tools(client tools are not necessarily required but good to have to troubleshoot connection issues) on all Application Tier servers.
Once the client has been installed on the IBM Cognos Application Tier(s) go to IBM Cognos Administration and to the Configuration tab, then to the Datasources section and create a new datasource. The type for the datasource is Microsoft SQL Server (your version) for example Microsoft SQL Server 2008. Once you get to the connection page you will need to input the server and the name of the database that you are connecting to and at the bottom you will likely need to add a user account and password to use for the signon, unless otherwise specified by your server admin, if the password section is greyed out look above the username text box you will see a checkbox for password, make sure it has been checked. Once this information is completed click on test the connection to confirm it successfully connects.
Linux:
Before making the datasource connection in IBM Cognos Administration you will want to make sure that you have installed the DataDirect ODBC client on all Application Tier servers. Once this is finished you will need to configure the ODBC connection, see link below for assistance:
http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.inst_cr_winux.10.2.1.doc/t_settingupodbcconnections.html
Once the ODBC connection has been configured on the IBM Cognos Application Tier(s) go to IBM Cognos Administration and to the Configuration tab, then to the Datasources section and create a new datasource. The type for the datasource is ODBC. Once you get to the connection page you will need to input the System DSN and you may need to add a user account and password to use for the signon, unless otherwise specified by your server admin, if the password section is greyed out look above the username text box you will see a checkbox for password, make sure it has been checked. Once this information is completed click on test the connection to confirm it successfully connects.
Dynamic Query Mode Connection:
1- Download and install the Microsoft SQL Server JDBC driver from Microsoft's website.
2- Within the Microsoft SQL Server JDBC driver install directory, locate and copy the sqljdbc4.jar file.
3- Within the IBM Cognos 10 Application Tier install directory, locate the ..\v5dataserver\lib and the ..\p2pd\web-inf\lib directory.
4- Copy the sqljdbc4.jar file into both these directories.
5- In order for the Microsoft SQL Server driver to be picked up by IBM Cognos 10, the IBM Cognos 10 service will need to be stopped and started.
Related Information
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21960845