Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTM Transactional Data and BI tools

Received Response
28
Views
1
Comments
Rid-A
Rid-A Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Hello everyone,
I'd like to know if it is possible to access the OTM (Oracle Transportation Management) transactional data from external BI Tools?
Or is there a way to access the OAC Data Model from external BI tools connector?
The objectif is to have only one centralized BI system, which is in the client side , which include the transactional transport data from OTM.

Regards

Tagged:

Answers

  • RVohra
    RVohra Rank 6 - Analytics Lead

    Direct DB access is not allowed from cloud.

    • You can create reports in BI Publisher that query transactional data.
    • You can schedule these reports to generate extracts (CSV/XML) and push them to external systems (e.g., via FTP/SFTP, UCM, REST APIs).
    • OTM Cloud provides REST APIs to query transactional data (e.g., shipments, orders, invoices).
    • These APIs can be used by ETL tools or BI tools that support REST data sources.
    • Many external BI tools can use REST API connectors or scheduled flat file feeds to ingest this data.
    • Hope it helps!