Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 239 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTM Transactional Data and BI tools
Rid-A
Rank 1 - Community Starter
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
0
Answers
-
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!
1
