Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ccaporaso
Partner - Contributor III
Partner - Contributor III

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

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.

Labels (1)
4 Replies
AfeefaTk
Support
Support

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
Partner - Contributor III
Partner - Contributor III
Author

HI @AfeefaTk 

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

Best regards,

Cecilia.

ccaporaso
Partner - Contributor III
Partner - Contributor III
Author

Hi @AfeefaTk 

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

ccaporaso_0-1706123201863.png

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
Support
Support

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