topic Re: Replacing Data Connections in Existing Qlik Sense Apps in Connectivity & Data Prep

Replacing Data Connections in Existing Qlik Sense Apps

MarkRDavies — Wed, 28 Feb 2024 10:25:39 GMT

Hi, our on-premise Data Warehouse is moving to a new Server.

We have Dozens of production Qlik Sense apps that point to the Data Warehouse on the Current SQL Server

Is there a way to amend the Data Connection of all these apps to replace their Connection from Current Server to New Server?

I am hoping that I don't have to go into each app and use the Data Manager to delete the current table and then reinstate with the same table but using a new connection string ...

Any pointers greatly appreciated

Re: Replacing Data Connections in Existing Qlik Sense Apps

henrikalmen — Wed, 28 Feb 2024 14:36:05 GMT

You have probably defined data connections in QMC, and in your apps you connect to the database through the data connection, e.g. LIB CONNECT TO 'dbconnectionname';

All you would have to do is to update the data connection in QMC so that it points to the new server, and all apps using it will automatically use the new data warehouse.

But if the data warehouse has changed so that tables or schemas or whatever don't have the same structure as before, then you'll probably have to edit each app that specifies e.g. names of tables it fetches data from.

Re: Replacing Data Connections in Existing Qlik Sense Apps

MarkRDavies — Wed, 28 Feb 2024 15:49:02 GMT

Hi - many thanks for your reply.

I had thought this would be the way to do it, but I couldn't prove this in test.

I created a Connection 'Data-Warehouse-Connection' and then in a test app I made a connection to a small View and read it in.

I then amended the Data Connection to point at the new Server, and reloaded my app ... it was still looking at the original server.

Only once I went to the Data Manager and used 'Select Data From Source' did it seem to update, then when I reloaded the app it was using the View from the new server

Am I missing a step perhaps? (The new data warehouse has exactly the same schemas, tables, views etc.)

Thanks

Re: Replacing Data Connections in Existing Qlik Sense Apps

henrikalmen — Wed, 28 Feb 2024 16:22:40 GMT

It should work, it sounds worrying that it doesn't. Did you reload through task manager or did you reload within the app? If you reloaded within the app, I'm thinking that maybe the app has already loaded the data connection properties so that you need to reload the app in the browser and after that let the app reload its data. But if you haven't already, I'd suggest as a first step that you let the Tasks module in QMC perform the reload.

Re: Replacing Data Connections in Existing Qlik Sense Apps

MarkRDavies — Wed, 28 Feb 2024 16:35:08 GMT

Perfect!

Yes, I was only reloading within the app, once I reloaded via a Task, all worked perfectly!!!

One thing you may know as a supplementary .. If the existing data connection was renamed, would all apps fail after that?

Many Thanks for your reply, very helpful

Re: Replacing Data Connections in Existing Qlik Sense Apps

henrikalmen — Wed, 28 Feb 2024 18:42:50 GMT

Great!
Yes, if you rename the connection you would have to update the connection name inside all apps as well.