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.

• 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.

• 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.

• 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.

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

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

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

• IBM Cognos Proven Practices: The IBM Cognos 10 Dynamic Query Cookbook
• Getting error “XQE-DS-0006 Unable to logon to data source” while making a JDBC connection to SQL Server in Cognos 10.1.1
• Error “XQE-DS-0006 Unable to logon to data source” testing a JDBC connection to SQL Server 2008

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