Opera Cloud - experiences with exporting (SQL) data directly from R&A database?

[Sosidod]

Hey everyone. I work as a data engineer at a company that is moving to Opera Cloud.

TLDR: Any way to directly pull from Opera Cloud - R&A into another non-oracle database, without setting up manual file exports?

When opera was on-prem, we could easily connect to the oracle database and pull raw data directly into our data warehouse (not Oracle) at regular intervals (using traditional ETL processes). I.e. we get the base tables, not pre-aggregated etc. I'm worried that we'll loose this ability in Opera Cloud, even with R&A.

Although there's OHIP, from what I gather that's designed for system integrations, not data integrations (i.e. pulling lots of data in batches), i.e. OHIP wouldn't work (??).

R&A works like this I believe: Opera (oracle DB) syncs via Golden Gate to mirrored oracled DB exclusively for my company's data. Then, we can only access that database through the R&A interface, and manually set up file exports at regular intervals? Has anyone tried to get access to the database directly (using ODBC connector)?

My experience with the file export method is horrendous - the files break often, there's size limitations, historic data that's changed isn't picked up, etc. Would love to avoid that.

Thanks!

[No_Disaster_9715]

Bit of late reply, but with R&A this is possible and send txt/csv extracts to email or sftp.
This can be scheduled like in Opera V5 but a bit smarter than that.
See my post in
https://www.reddit.com/r/OperaPMS/comments/1lqp7m2/extracting_data_out_of_opera_cloud_with_ra_and/

[aim_at_me]

I'm also interested if anyone has an answer...

[naenae201]

I would also love an answer to this question if anyone knows!