Configure Oracle 12g Connection in Cognos 10.2

This post is a follow-up discussion after the initial installation of the new IBM Cognos 10.2 evaluation software. Below are the steps that help you configure a Cognos connection to connect to an Oracle database. I am using the Oracle 12g database in this example, but it should also be applicable to the other Oracle 11g version.

  • Copy the appropriate Oracle jdbc driver to the Cognos directories outlined in this post IBM Cognos 10.2 evaluation
  • Launch your Cognos Administration via this URL http://localhost:19300/p2pd/servlet/dispatch (replace localhost with the name of your machine as appropriate)
  • Highlight the ‘Configuration‘ tab, and select the ‘New Data Source‘ icon as shown in the following screenshot

oracon01

  • Set the name of the connection (e.g. rdwOracle shown below)

oracon02

  • Click Next in the above screen, and select ‘Oracle’. Make sure you also select the checkbox ‘Configure JDBC connection’

oracon03

  • Click Next in the above screen, and enter Oracle connection string as shown below

oracon04

The ‘SQL*Net connect string‘ should have been given by your DBA with possibly a different host name, and port number instead of localhost, and 1521. The service name pdborcl used above represents a pluggable database in my test Oracle 12 instance. In your case, you might be using the entry name defined in your tnsnames.ora file instead.

Do not click on ‘Test the connection…’ yet because you still have to do one more configuration step yet.

  • Click Next in the above screen, to complete the configuration as shown below

oracon05

  • Now you can click ‘Test the connection’ to get the next screen to test the configuration set up so far.

oracon06

  • Click ‘Test’ in the above screen and you should get a good confirmation!

oracon07

For some installation, you might need to configure the connection with the SQL*Net Descriptor instead (i.e. where you are not allowed to have a personal tnsnames.ora file, or the centralized file is not editable for your testing purposes). The screenshot below shows what you would need to enter:

oracon08

The Oracle Net Descriptor is taken directly out of the format seen in the tnsnames.ora. Check with your DBA for the host name, and port number, and SID/SERVICE_NAME as appropriate. When done, click ‘Test the connection…’ to verify your configuration.

You now have an Oracle connection validated, and ready for use by Cognos tools such as Report Studio, Framework Manager, etc.!

TaiPh Author

Professional Business Intelligence Architect

Leave a Reply

Your email address will not be published. Required fields are marked *