Create data source connections to the samples databases

You must create data source connections to the samples databases that you restored.

IBM® Cognos® Business Intelligence uses data source connections to the samples databases to connect to the samples databases and run the sample reports or use the sample package.

Before you begin

The DB2® database name that you type must use uppercase letters. Also, in Framework Manager, the schema names that you type for the DB2 data sources must use uppercase letters.

Before you create the data source connections, you must restore the backup files for the samples databases. Also, ensure that the IBM Cognos BI service is running.

To create data sources, you must have execute permissions for the Data Source Connections secured feature and traverse permissions for the Administration secured function. You must have write permissions for the Cognos namespace.

Procedure

  1. Open IBM Cognos Administration by connecting to the IBM Cognos BI portal and clicking Administer IBM Cognos Content on the Welcome page.
  2. Click the Configuration tab.
  3. Click the new data source icon New data source icon.
  4. In the Name box, type great_outdoors_sales and then click Next.
  5. In the connection page, click the type of database that you restored and want to connect to, select an isolation level, and then click Next.

    The connection string page for the selected database appears.

    Note: By default, creating a data source connection enables samples that use the dynamic query mode. If you only want to use the compatible samples, deselect Configure JDBC Connection.

    Tip: The user specified in the great_outdoors_sales data source must have select privileges on the tables in each of the GOSALES, GOSALESRT, GOSALESMR, AND GOSALESHR schemas.

  6. Do one of the following:
    • If you restored the samples databases in Microsoft SQL Server, in the Server Name box, type the name of the server where the restored databases are located. In the Database name box, type GOSALES.

      IBM Cognos BI samples require TCP/IP connectivity with Microsoft SQL Server. Ensure the SQL Server Security is set to SQL Server and Microsoft Windows operating system, instead of Windows Only. The samples use SQL Server security for authentication.

    • If you restored the samples databases in Oracle, in the SQL*Net connect string box, type the instance name of the Oracle database as it is entered in the tnsnames.ora file.
    • If you restored the samples database in DB2, in the DB2 database name box, type GS_DB using uppercase letters. Leave the DB2 connect string box blank.
    • If you deployed the sample cube to IBM InfoSphere® Warehouse Cubing Services, in the Name box, type sales_and_marketing_cs. On the Specify the connection page for the Type box, select IBM InfoSphere Warehouse cubing services (XMLA). On the Specify the connection string page for the Server URL box, type the name of the server and the XMLA port number for the cube, followed by /IBMXmlAnalysis. For example, myserver:1999/IBMXmlAnalysis.
  7. Under Signons, select the both Password and Create a signon that the Everyone group can use check boxes, type the user ID and password for the user that you created when you restored the databases, and then click Finish.

    Tip: To test whether the parameters are correct, click Test the connection....

  8. Click Finish.
  9. Repeat steps 4 to 9 for the GOSALESDW samples database or schema, and type great_outdoors_warehouse in step 5.
  10. If the GOSALESW model will be used by modelers in IBM Cognos Transformer, the connection string must be manually added to the cs7g.ini file.
    • If you deployed the sample cube to IBM InfoSphere Warehouse Cubing Services, in the Name box, type sales_and_marketing_cs. On the Specify the connection page for the Type box select IBM InfoSphere Warehouse cubing services (XMLA). On the Specify the connection string page for the Server URL box, type the name of the server and the XMLA port number for the cube, followed by /IBMXmlAnalysis. For example, myserver:1999/IBMXmlAnalysis.

Results

The Sample Outdoors data source connections appear as entries in Data Source Connections.

You can now import the samples unless there is a syntax error in the connection string or an incorrect parameter.

Parent topic: Setting up the samples