Create a data source

To work with ISIM Cognos reports, we must create a data source.

• We must use the data source name as ISIM.

• If we are working with DB2 database client, copy the file db2cli.dll from the DB2 client installation directory to the <IBM Cognos installation directory>/bin folder.

• The data source must be pointed to ISIM enterprise database. For example, IBM DB2. After the data synchronization, the data is in ISIM enterprise database.

1. Access the IBM Cognos Analytics documentation at https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0.
2. Search for Creating a data source and complete the steps.

Corrupted attribute names are displayed in the reports for Arabic, Chinese, Hebrew, Japanese, Korean, and Russian languages. Double-byte character set (DBCS) characters appear to be corrupted in the reports. Edit the data source so that the data flow is in Unicode format. Complete the following steps:

1. On the Work with Reports page, click Launch > IBM Cognos Administration.

2. Click Configuration to open the data source connection.

3. Click ISIM.
4. Under the Actions column, click Set properties-ISIM.

5. On the Set properties-ISIM window, click Connection.

6. In the Connection String field, click the pencil symbol to edit the connection string.

7. In the Collation Sequence field, type @UNICODE.

8. Click OK.
9. Run the report to verify the text is no longer corrupted.

Parent topic: Configuration of IBM Cognos reporting components