Skip to main content


Oracle BI Cloud Service: Data Sync Released & DBaaS Supported

bi_161-315Today Oracle releases Data Sync, a tool that facilitates loading data into the Oracle BI Cloud Service (BICS) by offering a variety of capabilities:

  • Loading data from on-premise relational databases or data files into BICS Schema Database
  • Scheduling data load jobs
  • Monitoring data load jobs
  • Sending out email notifications

Earlier this week, Oracle has upgraded its BI Cloud Service offering to support Oracle Database as a Service (DBaaS) as a source for BICS reporting. This is a great improvement from the previously supported version of the BICS Database referred to as “Schema Database”. With this recent support for DBaaS, Oracle has now expanded its BI Cloud capabilities to enable a fully functional data warehouse reporting solution in the cloud. While the Schema Database has been restrictive in how to connect and load data to it, with DBaaS we now have limitless options of how we may load data by leveraging conventional means of data integration and ETL tools.

And with Data Sync, as a lite ETL tool, things are no different. While the Schema Database can only serve as a target, DBaaS can be both a source and a target with Data Sync. This means that with DBaaS we have much better means now of not only loading data but also extracting it from BICS using Data Sync.

For a quick primer on how to get started with Data Sync, you can reference my earlier blog here.

To download Data Sync and reference its documentation, follow this OTN link.

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