OTBI Input

How to pull data from Oracle Transactional Business Intelligence Report

Create a flow with OTBI as the Input

OTBI Input

Input Settings Tab

OTBI Input Settings

1. Specify the OTBI report path. Refer below for the steps to get the report path from OTBI UI

2. Specify the OTBI report name

3. Provide the necessary values for all the report parameters.

For Incremental runs, you can use offset.getLastUpdateDateValue() or offset.getIdValue() to get the respective max values from the previous runs. Those values will be null for the initial/first run or if no Last Update Date Column and ID Column is specified in the Input Settings.

params.LAST_UPDATE_DATE = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSZ").format(offset.getLastUpdateDateValue());
params.ID_VALUE = offset.getIdValue();
params.MY_PARAM = "SOME VALUE";

Schema Setup

1. Specify all the applicable date formats used by the report

2. Paste the sample csv output of the report. Check below for the steps to get the sample CSV

   1. You may want to add a line with empty values for all the optional fields for more accurate shema generation and for less manual schema corrections

3. Client on the Generate Schema button to generate the schema

4. Verify the generated schema and update the schema as needed.

Complete the remaining setups and click Submit to start pulling data from the OTBI report.

Steps to get the OTBI report Path & Name

To get the path of the report, Open the report in OTBI Catalog browser, Choose the report, click on the More link and click on the Properties menu option as show below

Note down the report name and the path that is labeled as Location. You may have to remove /shared from the path.

Run the report and verify the path from the bipPath URL parameter. As you can see, /shared is not part of the bipPath parameter.

Steps to get the sample CSV output

Click on the output icon and choose CSV menu option to get the CSV output of the report. Copy the CSV output as a sample.