This article describes the integration between SPSS and Cognos solutions. The integration with Cognos comes in the form of being able to directly connect to Cognos as a data source for SPSS modeler and also being able to export the results to Cognos directly to allow Cognos to report on the results. The benefits of using Cognos as a source is that your data is all in one place and its formatted and tidied up suitable for SPSS analytics. Exporting the results to Cognos has the benefit of being able to report on the results using the familiar.
To implement this is reasonably straight forward and involves selecting the Cognos source node or the Cognos export node and dragging it into your stream as shown below:
You then have to edit the Cognos node and add the Cognos server IP address details and login credentials. As shown on Figure below –
You also need to make an ODBC connection to the Cognos Data warehouse from the SPSS server. This needs to have the same name and details as the Cognos data source. If these details do not match on the Cognos and the SPSS server the integration will not work.Below figure shows the details:
The benefits of using Cognos as a source is that your data is all in one place and its formatted and tidied up suitable for SPSS analytics. Exporting the results to Cognos has the benefit of being able to report on the results using the familiar reporting format and various different types of Cognos reports that the company uses.
Note: To either export to Cognos or use Cognos as a data source an ODBC connection to the Cognos data warehouse must be established as well as the Cognos Server connection.Summary:
In this way, we can integrate IBM Cognos BI with IBM SPSS product and get reporting data from prediction and analysis from SPSS.