About the Oracle BI Cloud Service REST API

You use the Oracle BI Cloud Service REST API to define or customize your own API and programmatically load on-premises data for analysis in Oracle BI Cloud Service. The Oracle BI Cloud Service REST API is optimized for loading large volumes of data (thousands to millions) from one or more sources.

You can access the API at REST API for Oracle BI Cloud Service.

Load data to tables on Oracle Database Cloud Service:

The REST API for Oracle BI Cloud Service loads data into the default cloud database connected to Oracle BI Cloud Service. Once data is loaded on to this cloud database, you can:

  • Insert, update, upsert, and delete large numbers of records by streaming batches of records.

  • Update statistics.

  • Drop or create indices on tables on the Oracle Database Cloud Service.

  • Write programs and scripts in your favorite programming language and then combine them with additional application logic to invoke the Oracle BI Cloud Service REST API.

  • Invoke the script or application with your on-premises scheduler.

  • Automate incremental data loading or integrate with ETL tools using the Oracle BI Cloud Service REST API. See REST API for Oracle BI Cloud Service.

  • Create a customized API using the Oracle BI Cloud Service REST API framework.

Load data to data sets on Oracle BI Cloud Service:
  • Create, update, and delete data sets from on-premises data sources.

  • Manage data sets programmatically. Delete unwanted data sets to free up storage space.