G Sample Starter Kit for Consultants - Integration with Business Intelligence Cloud Service

This topic describes a sample starter kit that can be used by infrastructure consultants to plan integration for Planning with Business Intelligence Cloud Service. .

Prerequisites

  • You have accounts for Business Intelligence Cloud Service, Planning, and Oracle Application Express.

  • You have considerable technical and functional expertise with Business Intelligence Cloud Service, Planning, Oracle Application Express, REST, Groovy, and scripting.

These are the basic tasks for the sample starter kit for consultants:

  • Export data and metadata from Planning using the Planning REST API.

  • Download data and metadata to an on-premise server using the Planning REST API.

  • Use the metadata to create schema/tables in Business Intelligence Cloud Service using the Business Intelligence Cloud Service REST API.

  • Populate the tables in Business Intelligence Cloud Service using the data imported from Planning by using the Business Intelligence Cloud Service REST API.

Note:

If you are using DBaaS, the target reporting database can optionally be accessed by

standard tools like SQL Developer and Toad.

Note:

The DataSync tool (available from OTN) can also be used to create tables and load and update data in the tables. Data uploads can be scheduled using the DataSync jobs and native scheduler. This approach will work for Database Schema Service and DBaaS used as reporting database for BICS. For more information, see the DataSynch documentation.

These are the basic steps for the sample starter kit for consultants:

  1. Install the scripting engine and deploy demo scripts.

  2. Use the SQL APEX REST API client to call a client sample that calls a SQL query with a bind variable passed on the URL.

  3. Use the Business Intelligence REST API client to provide methods as necessary for your use case.

  4. Use the Planning REST API client to provide methods as necessary for your use case.

  5. Incorporate helper functions.

  6. Integrate Planning with Business Intelligence Cloud Service using a demo script.

Planning, Business Intelligence Cloud Service, and SQL Web REST services expose functions available in EPM Automate, DataSync, and for direct database SQL/PLSQL calls. The REST APIs can be scripted using any language. This appendix describes a sample starter kit to show how this can be implemented using Groovy for demonstration purposes. For information on REST APIs for Business Intelligence Cloud Service and Application Express, see:

For examples of metadata and data files exported from Planning, see the Lifecycle Management Guide: http://docs.oracle.com/cd/E57185_01/EPMLU/ch01s02.html