topic Re: Store and update data from a Qlik Straight table to MS SQL Table in Qlik Automate

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

ccaporaso — Tue, 16 Jan 2024 15:05:43 GMT

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.

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

AfeefaTk — Mon, 22 Jan 2024 01:10:31 GMT

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

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

ccaporaso — Mon, 22 Jan 2024 11:23:09 GMT

HI @AfeefaTk

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

Best regards,

Cecilia.

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

ccaporaso — Wed, 24 Jan 2024 19:14:56 GMT

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.

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

AfeefaTk — Thu, 25 Jan 2024 00:04:25 GMT

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