OTBI Input
How to pull data from Oracle Transactional Business Intelligence Report
Create a flow with OTBI as the Input

Input Settings Tab

Specify the OTBI report path. Refer below for the steps to get the report path from OTBI UI
Specify the OTBI report name
Provide the necessary values for all the report parameters.
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

Specify all the applicable date formats used by the report
Paste the sample csv output of the report. Check below for the steps to get the sample CSV
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
Client on the
Generate Schema
button to generate the schemaVerify 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.
Last updated
Was this helpful?