Store and update data from a Qlik Straight table to MS SQL Table

[ccaporaso]

Hi,

I've been asked to solve a use case that requires to daily move the content of a straight table, develop in a Qlik Cloud app, to a table in MS SQL Database.

Has anyone developed a similar solution? Any warning or advice you can give me before starting?

I've found a similar template (Copy and update data from a Qlik Sense straight table to an Excel sheet), but no one with a Database as target.

Thanks in advance and kind regards.

Cecilia.

[AfeefaTk]

Hi @ccaporaso 

I have created demo automation using the Microsoft SQL Server "Upsert Bulk" block.

Please upload automation, fill in all necessary input fields, and see if that works for you.

Regards

Afeefa TK

[ccaporaso]

HI @AfeefaTk 

Thank you so much for your development!!!! I'll try it and give my feedback.

Best regards,

Cecilia.

[ccaporaso]

Hi @AfeefaTk 

I've been testing this automation and I've got this error

If that IP is specifically allowed on the DB side, the problem seemed to be solved. However, the IP address changes from time to time, depending on the automation run. So, that approach is imposible to endure.

Loading data from that dabase into qlik sense by script editor is working OK.

The user id provided to the DB connection parameters is allowed to insert and update records.

¿Could you suggest a way to avoid this error permanently?

Thanks in avance and kind regards,

Cecilia.

[AfeefaTk]

Hi @ccaporaso 

Please whitelist certain IP addresses listed in this help page for your region on your server.

Hope this helps!!

Best Regards

Afeefa TK