Transfer data from Planning Analytics to Cognos Controller

You can transfer data from your Planning Analytics on Cloud environment to your IBM® Cognos Controller on Cloud environment.

Note: The information provided here refers to TurboIntegrator and Structured Query Language (SQL) for SQL Server. It applies only to an integrated Planning Analytics on Cloud and Cognos Controller on Cloud environment.
You must have following information:
Name of the ODBC connection from Planning Analytics to Cognos Controller
The value is Controller. The ODBC data source is created by IBM as part of the integration process and it points to your first Cognos Controller database.
Cognos Controller database credentials
You can find these credentials in your Cognos Controller on Cloud welcome kit. You use these credentials to connect to the Cognos Controller database from Planning Analytics.
You must create the following things:
A process that exports data from Planning Analytics in to staging tables
In TurboIntegrator, create a process that loads xstagefact with data from Planning Analytics. For more information about TurboIntegrator, see TurboIntegrator processes and TurboIntegrator overview.
An import specification
In Cognos Controller, create an import specification for reading the data from the staging table
A process that imports the data in to Cognos Controller
In TurboIntegrator, create a process that starts the stored procedure triggerimportbatchjobs.sql. triggerimportbatchjobs.sql creates a batch job that imports the data from xstagefact in to Cognos Controller.

For an example of a TurboIntegrator process that does the export and import mentioned previously, see Example TurboIntegrator script.

After you have the process in place, keep the data up-to-date by doing the following tasks at regular intervals:
  1. Run the TurboIntegrator process that loads xstagefact with data from Planning Analytics
  2. Run the TurboIntegrator process that imports the data from xstagefact in to Cognos Controller.