Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Highlighted
Mauritz_SA
Contributor III

Cloud data storage/transfer for Oracle

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

Labels (2)
2 Replies
Support
Support

Re: Cloud data storage/transfer for Oracle

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...
Vu Nguyen
If a post helps resolve your issue, please mark the answer as correct.
Mauritz_SA
Contributor III

Re: Cloud data storage/transfer for Oracle

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