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
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).
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!
some other options to explore include are the REST APIs, Oracle Data Transforms or OCI Data Integration
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
