To work with the Privileged Identity Manager Cognos®-based reports, you
must create a data source.
Before you begin
- If you 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.
- Catalog the database if the data source is remote. Use the following
commands:
- db2 catalog tcpip node <alias-name> remote <remote-DB-server>
server <port-no>
- db2 catalog database <remote-dbe> as <alias-name>
at node <alias-name>
About this task
You must use the following data source names:
- ISPIM - This data source name is used to establish
connection to the IBM® Security Identity Manager database.
- ISAMESSO - This data source name is used to establish
connection to the IBM Security Access Manager for Enterprise Single Sign-On database.
- PSR - This data source name is used to establish
connection to the Privileged Session Recording database.
Procedure
- Access the IBM Cognos Business Intelligence
product documentation at http://pic.dhe.ibm.com/infocenter/cbi/v10r2m1/index.jsp.
- Search for Creating a data source and
complete the steps.
What to do next
Note: 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:
- On the Work with Reports page, click .
- Click Configuration to open the data source
connection.
- Click <data_source>.
For example: ISPIM.
- Under the Actions column, click Set
properties-<data_source>.
- On the Set properties-<data_source> window,
click Connection.
- In the Connection String field, click the
pencil symbol to edit the connection string.
- In the Collation Sequence field, type @UNICODE.
- Click OK.
- Run the report to verify that the text is no longer corrupted.