Oracle Analytics and AI

Rid-A

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

RVohra

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!