OAC conneciton to OTM

Question

Hi Team,

We have a requirement of extracting data from OTM into OAC for reporting puposes. Please let me know the options for the same in OAC.

Regards,

Jahnavi

GayathriAnand-Oracle · Answer

OTM OAS instances are being migrated to OAC instances, not sure if you are using OAS/publisher stack in OTM currently? If yes the migration to OAC will happen (if it hasn't already).

Brendan T · Answer

some other options to explore include are the REST APIs, Oracle Data Transforms or OCI Data Integration

Aman Jain-Oracle · Answer

Hi @Jahnavi-Oracle,

The best way to enable near real-time analytics on OTM data is to use Oracle Golden Gate to replicate data from OTM to Oracle ADW, then analyze it with OAC. This setup enables real-time insights while maintaining production performance and security.

Hope that helps!