topic Cloud data storage/transfer for Oracle in Connectivity & Data Prep

Cloud data storage/transfer for Oracle

Mauritz_SA — Mon, 13 Dec 2021 17:52:10 GMT

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

Re: Cloud data storage/transfer for Oracle

Vu_Nguyen — Tue, 25 Jun 2019 12:31:34 GMT

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-developer-oracle

Re: Cloud data storage/transfer for Oracle

Mauritz_SA — Tue, 25 Jun 2019 13:24:31 GMT

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