Qlik Writeback to SQL database

[Sidharth_Gupta]

I want to writeback my data into a MySQL database table using script in Qlik sense. I was able to create a MySQL connection successfully in Data Load Editor. Does Qlik Sense have a Writeback functionality? If yes, what query should I use to implement it.

I also tried to writeback my data into a file in my local folder directory, but it is giving me an error that 'File path is not found'. I am using below code in script in Data Load Editor:

Test1:
Load
Physician, CancelledMTD
From DWH_OrderTrends;
STORE Test1 into C:\Users\sidha\QV_files\Order.qvd(qvd);

Let me know if you can help please. 

Thanks

Sidharth

[rwunderlich]

You can use the Qlik "SQL" keyword to send any sql statement to your database connection. so in your load script, 

SQL UPDATE Set Name="xyz", ....

-Rob

[Sidharth_Gupta]

Hello, thanks for answering.

I am fetching data from one SQL table in Qlik, then applying some transformation on it (lets say grouping) and then trying to load this data back into a new SQL table. I have the SQL keyword, it is not working. Do you  have any other suggestion in mind?

Thanks

[rwunderlich]

Can you post the script you have tried?

-Rob

[NadiaB]

Hi @Sidharth_Gupta 

By any chance have you seen this already?

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/How-to...

Hope it helps!

[NS_Qlikupdates]

If you’re open to explore extensions, SenseOps is a good option.

You can edit data directly in Qlik Sense and save it back to SQL databases or QVD/CSV files, without scripting. Includes audit logs and validations and so write-back stays controlled. Check out here.