Installing the IBM Cognos Samples

3. Create data source connections for the samples databases

Next step is to make these data sources known to Cognos. So we are going to create the Data Source Connections for it. 

  • Go to your Cognos environment and open IBM Cognos Administration.
  • Go to the Configuration tab and select Data Source Connections and click the “New Data Source” icon.
  • In the “New Data Source Wizard” enter  the name “great_outdoors_sales”, make sure this is exact, if not you will have to change the FM models later on.

 IBM Cogos 10.2.1 Samples Create new datasource great_outdoors_sales

  • Click next.
  • Select the data source type, in this case “Microsoft SQL Server (SQL 2008 Native Client)”.
  • Select “Configure JDBC connection”. If you want to use Dynamic Query Mode (DQM), and you should, enable this.

IBM Cogos 10.2.1 Samples Specify the Connection

  • Click next.
  • Now you have to enter the connection string. Here you have some options. If you have a default setup it’s not difficult.
  • Enter the SQL server name and the name of the database GOSALES.
  • The sign-on choice will depend on how you want to log on to your database.

IBM Cogos 10.2.1 Samples Specify the Connection String

  • Test the connection.
  • If your SQL Server instance is configured correct and relatively default, you should only enter the server name and the database name for the JDBC connection.

IBM Cogos 10.2 Samples JDBC Connection GOSALES

  • Test the connection and finalize the wizard.
  • Repeat the above steps for the database “GOSALESDW” and with “great_outdoors_warehouse” as data source name.

IBM Cogos 10.2 Samples Create new datasource GOSALESDW

  • You should now have 2 new entries in your Data Source Connection pane in IBM Cognos Administration.

IBM Cogos 10.2.1 Data Source Connections

If you experience any issues with configuring the connection string for the JDBC connection, it can be useful to consult the following pages:

IBM Cogos 10.2 Samples JDBC Connection Error

All Parts:

1. Installing the Cognos Samples installation package
2. Restore Go Sales and Go Sales Data Warehouse databases
3. Create data source connections for the samples databases
4. Running the Dynamic Cube Samples
5. Installing the TM1 Samples
6. Create Data Source Connections for TM1
7. Create Data Source Connections for PowerCubes Samples
8. Installing the IBM Cognos Content Store Samples

1 2 3 4 5 6

Cognos Service

Comments
  1. keith |