topic Re: Pushing a straight table from Qlik Cloud App to a Custom table in Oracle in Data Movement & Streaming

Pushing a straight table from Qlik Cloud App to a Custom table in Oracle

bsharma_velcro — Wed, 19 Mar 2025 21:46:28 GMT

Hi,

I need to push a straight table from a Qlik Cloud app to a custom table in Oracle. Could anyone please suggest how can this be achieved without any manual intervention!

Regards,

Bhaskar S.

Re: Pushing a straight table from Qlik Cloud App to a Custom table in Oracle

David_Friend — Mon, 27 Jan 2025 14:53:44 GMT

@bsharma_velcro this is out:
https://www.youtube.com/watch?v=hYER2nGKctM

Re: Pushing a straight table from Qlik Cloud App to a Custom table in Oracle

bsharma_velcro — Mon, 27 Jan 2025 16:21:57 GMT

Thanks @David_Friend. Well my requirement is - I need to push the whole table with thousands of rows into a table in Oracle DB, like below:

How do I do it without having to export this straight table into an excel or csv file.

Regards,

Bhaskar

Re: Pushing a straight table from Qlik Cloud App to a Custom table in Oracle

bsharma_velcro — Wed, 29 Jan 2025 08:21:35 GMT

@David_Friend any suggestions for my requirement?

Re: Pushing a straight table from Qlik Cloud App to a Custom table in Oracle

Or — Wed, 29 Jan 2025 08:30:36 GMT

I don't think you do. Qlik is not an interface for data input, ultimately...

Re: Pushing a straight table from Qlik Cloud App to a Custom table in Oracle

bsharma_velcro — Wed, 29 Jan 2025 09:03:06 GMT

Hi,

There are 3 parts in one of the possible solutions I am currently working on:

First, getting the data ready from the front end object/straight table: This, I was able to do using Tabular reporting. I created an excel report of the straight table

Second, temporary staging of the the data/table: This is currently being sent to email using distribution feature of tabular reporting. This is where I need help - Is there a way to send this excel back to shared space in the Qlik cloud? Or to OneDrive, which is our current default cloud file storage - I couldn't find a way (only feasible way seems is Sharepoint, which in my case has some restrictions to.)

Third, read the data in the excel file and push it to Oracle DB: This, I was able to do using a second Qlik app to read the excel file and pushing the data to Oracle DB using an insert query and enabling "Non-Select Queries" in the data connection I created.

So, the second stage - the staging is what I need help with, for this approach to succeed. Appreciate any suggestions in this regard.

Also, do let me know if anyone has any other suggestions.

Regards,

Bhaskar

Re: Pushing a straight table from Qlik Cloud App to a Custom table in Oracle

bsharma_velcro — Wed, 29 Jan 2025 14:42:22 GMT

Hi,

I was able to do it using Automations.

Step1. Create the straight table in Qlik App

Step2. Use automation template "Store a straight table as a .csv file on Amazon S3" (I replaced Amazon S3 with Microsoft OneDrive) to store the straight table in OneDrive in .CSV format

Step3. Use second Qlik app to read data from the .CSV file and push it to Oracle DB using an insert query by enabling "Non-Select Queries" in the data connection.

To make the automation end-to-end, one can extend the automation in Setp2 as:

Reload the 1st App --> Store the straight table as a .csv file on preferred cloud storage --> Reload the second app where insert query is written.

Regards,

Bhaskar S.

Re: Pushing a straight table from Qlik Cloud App to a Custom table in Oracle

bsharma_velcro — Wed, 29 Jan 2025 14:49:53 GMT

By the way, the solution I posted earlier using tabular report also works if you have Microsoft SharePoint at your disposal for distribution of the tabular report in excel.

Regards,

Bhaskar