FLOW
  • FLOW
  • Getting Started with FLOW
    • Overview
    • The Basics
      • FLOW Concepts
      • Events & Schemas
        • Event Metadata
        • Sample Event
        • Sample Schema
      • Connections
    • Architecture
    • FLOW Schedule
      • Cron Expression
  • Stages
    • Validations
    • Transform
    • Actions
    • Mapper
  • Recipes
  • Scripts
  • Webhooks
  • REST Connector
  • Flow Monitoring
  • Live Monitoring
  • Advanced Topics
    • Post Process
    • Naming Policy
    • Manage Patches
  • Installation
  • FAQ
  • Tutorials
    • Creating a Connection
    • Creating a Flow
    • Creating a Script
    • Creating a Recipe
  • How To
    • OTBI Input
    • CSV File from Amazon S3
  • Changelog
  • Environment Variables
  • Data Security & Privacy
Powered by GitBook
On this page
  • Create a flow with OTBI as the Input
  • Input Settings Tab
  • Schema Setup

Was this helpful?

  1. How To

OTBI Input

How to pull data from Oracle Transactional Business Intelligence Report

PreviousHow ToNextCSV File from Amazon S3

Last updated 5 years ago

Was this helpful?

Create a flow with OTBI as the Input

Input Settings Tab

  1. Specify the OTBI report name

  2. 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

    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

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

  3. 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.

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

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

steps
steps
OTBI Input
OTBI Input Settings