Skip to main content


Oracle BI Cloud – Quick Demo of Different Data Loading Methods

The Oracle Business Intelligence Cloud Service (BICS) offers various options through which data may be loaded into the BI cloud database. I am focusing here on BICS that comes with the Database Schema service as a reporting database. In addition, there are several ways through which you may extract data from BICS. It may be confusing to know which approach needs to be followed and therefore I am listing the most important characteristics of these approaches on the slides below. This should help in figuring out which approach for data loading and extraction works best for your situation.

A quick walkthrough of the different BICS data loading techniques is available at the following YouTube recording:

If your BICS is connected to the Oracle Database as a Service (DBaaS) as opposed to the Database Schema Service, all these methods are still applicable but you will also have several other options as well in that case such as leveraging ETL tools like Oracle Data Integrator (ODI) or Informatica Cloud.




Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Mazen Manasseh, Director of Business Analytics

Mazen is a Director of Business Analytics at Perficient and an accomplished professional services leader with 20 years of being a customer advocate. An analytics solutions delivery expert in functional domains covering Supply Chain, Financials, HCM, Projects and Customer Experience. Being a thought leader in the business analytics space, he conducted numerous business training sessions and spoke at technology conferences around analytics and machine learning.

More from this Author

Follow Us