Edit data-connections by command

lobarbag — Fri, 03 May 2019 20:23:47 GMT

Hello, I have a APP with many data-connections, all are web connections with the same IP and similar pattern. I need to change ocastionally the IP for all of them and if I do it graphically I need to do it one by one. Is there any way to edit them by command with a replace all option? (I am using Qlik Sense Destktop)

Thanks in advance

Re: Edit data-connections by command

Vu_Nguyen — Tue, 21 May 2019 12:41:51 GMT

Hi, you can consider one of the following solutions:

Disable Standard reload mode in QlikView. This allows you to load data from URLs directly without having to define webfile connections. Check https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/LoadData/disable-standard-mode.htm
If you're using Qlik Sense November 2018 or later, you can make only one webfile connection then change URL during runtime using "URL is" keyword. Documentation at https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/url.htm, example at https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/LoadData/disable-standard-mode.htm (see under "Loading data from a dynamically created URL")

Both solutions aim to define URL in the reload script instead of webfile connection. With this implemented, you can use replace feature in Data Load Editor to mass-replace the URLs.

topic Re: Edit data-connections by command in Connectivity & Data Prep

Edit data-connections by command

Re: Edit data-connections by command