Welcome to All Things Data Integration: Announcements, Insights, Best Practices, Tips & Tricks, and Trend Related...

Oracle Data Integrator (ODI) to Load Business Intelligence Cloud Service (BICS)

Sandrine Riley
Product Management - Data Integration Solutions at Oracle

Learn more about using Oracle Data Integrator (ODI) to load Business Intelligence Cloud Service (BICS) from Richard Williams of the A-Team...

It is not new to hear that ODI can load data into the Business Intelligence Cloud Service (BICS)
environments.  (These use Database as a Service (DBaaS) as the underlying

The recent
release of ODI (back in December 2016) however, added the ability to load data into BICS environments
based on a Schema Service Database. ODI does this by using the BICS

The article written by Richard walks through the following steps to set up ODI to
load data into the BICS schema service database:

  • Downloading latest version of ODI
  • Configuring the physical and logical connection to BICS in ODI
  • Loading BICS knowledge modules
  • Reverse engineering BICS model
  • Creating a simple mapping
  • Importing the BICS certificate into the trust store for the standalone agent

READ the article:  Using Oracle Data Integrator (ODI) to Load BI Cloud Service (BICS).

Additionally, for other A-Team articles about BICS - read here.

Thanks Richard!

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.