Transfer data from Planning Analytics to Controller

You can transfer data from your Planning Analytics on Cloud environment to your IBM® 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 IBM Controller on Cloud environment.
You must have following information:
Name of the ODBC connection from Planning Analytics to 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 Controller database.
Controller database credentials
You can find these credentials in your IBM Controller on Cloud welcome kit. You use these credentials to connect to the 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 Controller, create an import specification for reading the data from the staging table
A process that imports the data in to 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 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 Controller.