IBM Support

Maximo Cognos Integration - Step by step instruction

Technical Blog Post


Abstract

Maximo Cognos Integration - Step by step instruction

Body

This document describes on how to setup Maximo Cognos integration.

 

For the detailed instruction please refer to the following document.

/support/pages/node/521531

 

 

<Index>

 0. Prerequisites
 1. Create Unique Database User for use with MXCSP
 2. Configure mxcognosdatasources.properties file for MXCSP
 3. Copy CSP and Database Jar Files from Maximo to Cognos
 4. Create Namespace in Cognos Configuration
 5. Configure Maximo System Properties for Cognos
 6. Create a Data Source in Cognos Administration
 7. Set Maximo End Point Properties
 8. Configure Cognos files for Metadata publishing
 9. Publish Cognos Packages
10. Verify Integration
11. Import Maximo Cognos reports and workspaces

 

 

0. Prerequisites

Maximo:

Install and configure Maximo.
Make sure that Maximo is up and running.

http://servername/maximo

 

Cognos:
Install and configure Cognos.
Make sure that Cognos is up and running.

http://servername/ibmcognos/cgi-bin/cognos.cgi

 

 

1. Create a unique Database User for use with MXCSP

(1) create user 'cognos'

(2) grant permission to user cognos

grant select on MAXIMO.MAXUSER to cognos
grant select on MAXIMO.GROUPUSER to cognos
grant select on MAXIMO.PERSON to cognos
grant select on MAXIMO.MAXGROUP to cognos
grant select on MAXIMO.MAXPROPVALUE to cognos
… (other tables owned by MAXIMO)

 

 

2. Configure mxcognosdatasources.properties file for MXCSP

 Mxcognosdatasource property file:
<Maximo>\reports\cognos\c10\configuration\mxcognosdatasources.properties

maximoDataSource.url=jdbc:db2://localhost:50001/UDBPD
maximoDataSource.driver=com.ibm.db2.jcc.DB2Driver
maximoDataSource.username=cognos
maximoDataSource.password=xxxxxx
maximoDataSource.schemaowner=MAXIMO

 

<Example>

image

 

 

3. Copy CSP and Database Jar Files from Maximo to Cognos

 

(1) Copy the database drivers
<Maximo76>\applications\maximo\lib Find the drivers for the database

For Oracle: oraclethin.jar
For SQL Server: sqljdbc.jar
For DB2: db2jcc.jar and db2jcc_license_cu.jar

Copy the applicable database driver to the directory
<Cognos>\c10\webapps\p2pd\WEB-INF\lib

 

(2) Copy the MXCSP file
<Maximo76>\reports\cognos\c10\webapps\p2pd\WEB-INF\lib\CAM_AAA_MXCSP.jar

Copy CAM_AAA_MXCSP.jar file to the Cognos Directory
<Cognos>\c10\webapps\p2pd\WEB_INF\lib

 

(3) Restart the Cognos services

 

<Sample of Cognos Configuration>

image

 

 

 4. Create a Namespace in the Cognos Configuration

(1)

Type: Custom Java Provider
Namespace ID: maximo
*Java Class Name: MXCSP
    (MXCSP refers to the CAM_AAA_MXCSP.jar that you copied in step3)
Selectable for Authentication: True

image

 

(2) Confirm the Anonymous Authentication is set to false (or disabled).

image

 

 

5. Configure Maximo System Properties for Cognos

Go to the System Properties application.


(1) Filter 'Cognos'

image

 

(2) Filter 'mxe.rest.webappurl' (used for security authentication of users)
If your Maximo URL for example is:         http://maximoserver1:9998/maximo
then your mxe.rest.webappurl would be: http://maximoserver1:9998/maxrest

image

image

 

 

* TEST

By completing steps so far you should be able to login Cognos using Maximo user id and password.

 

 

6. Create a Data Source in Cognos Administration

Create data source connection MXDB

(1) In Cognos Administration > Configuration
(2) Data Source connections
(3) Click new data source
(4) Specify all required fields
    -> Specify a name -> Next
    -> Specify Type and other settings - > Next
    -> Specify the server name, user name, password, host name, and port
(5) Test the connection...
(6) Click Finish

image

 

 

7. Set Maximo End Point Properties

Maximo's End Point functionality provides an interface for Cognos metadata creation and package publishing.

 

(1) In Maximo: Integration - End Points application - Select MXCOGNOS

image

image

 

 

8. Configure Cognos files for Metadata publishing

For IBM Webpshere

(1) Stop the Cognos services

(2) Access the Maximo directory <Maximo>\reports\cognos\C10\sdk

cognos-axis.jar
cognosClient.jar

(3) Copy the two jar files to the application server lib directory.
<Websphere installation location>\AppServer\lib

(4) Restart the Cognos services

 

 

9. Publish Cognos Packages

Object Structure application, ‘Consumed By = Reporting’
Open one of reporting object, then 'Publish as Cognos Package'

image

 

 

* TEST

By completing steps so far you should be able to publish Cognos package in Maximo.

 

 

10. Verify Integration

To test that your integration has been completed properly, perform the following.

(1) Access Cognos from a Maximo application
(2) Confirm that you are brought directly over to Cognos

(3) Within Cognos, navigate about the pages in the Cognos portal
(4) Navigate to the location of your published Maximo packages. Confirm they can be opened within one of the report development tools

 

 

11. Import Maximo Cognos reports and workspaces

With the Maximo 76 release, a number of Cognos reports and workspaces are available to you.
e.g) Work Order, Asset, Asset Failure, Inventory

 

(1) Deployment file
<maximo76>\reports\cognos\Packages\PublicMX76.zip

(2) Copy the deployment file to the <CognosLocation>\c10\deployment directory
(3) Open IBM Cognos Connection
(4) In IBM Cognos Administration, on the Configuration tab, click Content Administration, and click New Import.
(5) Select the deployment file that you copied, and follow the steps in the wizard to import the content.

 

 

This is the end of Maximo Cognos integration steps.

 

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11130553