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

[bsharma_velcro]

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.

[David_Friend]

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

[bsharma_velcro]

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

[bsharma_velcro]

@David_Friend any suggestions for my requirement?

[Or]

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

[bsharma_velcro]

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

[bsharma_velcro · Accepted solution]

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.

[bsharma_velcro · Accepted solution]

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