Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

OAC conneciton to OTM

Received Response
21
Views
3
Comments
Jahnavi-Oracle
Jahnavi-Oracle Rank 6 - Analytics & AI Lead
in Oracle Analytics Forum

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

Tagged:

Answers

  • Aman Jain-Oracle
    Aman Jain-Oracle Rank 6 - Analytics & AI Lead

    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!

  • Brendan T
    Brendan T Rank 6 - Analytics & AI Lead

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

  • GayathriAnand-Oracle
    GayathriAnand-Oracle Mod

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