All data in Oracle Business Intelligence Cloud Service (BICS) must first be uploaded to the service, whether from a relational source or text file / spreadsheet.
Data is stored in a cloud version of Oracle Database, called Oracle Database Cloud Service, which is a single database schema with ability to create tables and views. The database schema is administered via the Oracle Application Express (APEX) interface. For purposes of this discussion, we will use the Data Loader Wizard, which is a quick-start way of loading flat file data to BICS (an Oracle tutorial is provided here if you want more details).
BICS Data Loader Wizard Summary and Start Icon
The BICS data loader can be accessed through the home page or the dropdown menu that appears under your login. You will be redirected to a new web page tab, where you will choose your flat file and then click on the “Load Data” button:
BICS Data Loader Wizard, Step 1
Your file will be processed, and you will need to click the “Next” button to select the destination for the data. You will see a preview of the data in the window below. You can select a delimiter and also specify a certain number of rows to skip.
During the next part of the data load, you can either create a new table or use an existing table. If you elect to create a new table, you can define the table name and BICS will create the table for you instantly. There are options to perform light data transformations and cleansing as well.
BICS Data Loader Wizard, Step 2 (Showing Options for Data Transformation)
During the final phase of the Data Loader Wizard steps, you are shown a summary of the data you have loaded and you can hit “Save” to commit the data to the database table.
BICS Data Loader Wizard, Step 3
The BICS Data Loader Wizard is the easiest way to dig in right away and “kick the tires” on loading data into BICS. It allows you to rapidly prototype your data without the need to invest in a technical project. You can stage all your data in a spreadsheet and then quickly upload it to the cloud.