Cloud data storage/transfer for Oracle

[Mauritz_SA]

Hi all

We have a client who host their own Oracle DB. We would like to set up some kind of system where they drop information and where we pick it up again so that we don't need access to their environment. My biggest question is where and how you could store an Oracle DB in the cloud, in what format and how to keep it relatively up to date (once every hour should be fine) in an efficient manner (delta loading for example)? Is anyone doing something like this and can you maybe give me high level steps of what you did?

Regards,

Mauritz

[Vu_Nguyen]

Hi, you may consider setting up a Windows scheduler task which executes an SQL script to extract data from Oracle, save to Qlik-readable data files (for example CSV) into a folder that is synced to a cloud storage service such OneDrive. Your Qlik Sense app can then read the data files from the cloud.

This discussion could be helpful: https://dba.stackexchange.com/questions/222209/how-to-automate-csv-exports-of-queries-in-pl-sql-deve...

[Mauritz_SA]

Hi Vu

Thanks for the suggestion. I will give it a go when we speak to the client. I am going to keep this thread open for now in case someone else has any ideas. Otherwise I will mark it as a solution once implemented.

Regards,

Mauritz