article How to Migrate Qlik Sense Data Connections (on Windows) in Official Support Articles

How to Migrate Qlik Sense Data Connections (on Windows)

Juli_K — Tue, 06 Sep 2022 11:52:54 GMT

It may be necessary to export Data Connections to either move Data Connections between environments or to import Data Connections into the Qlik Analytics Platform (which doesn't have a front-end interface to easily recreate these connections).

To achieve this, keep in mind:

Data Connections can only be created inside the Data Load Editor.
Data Connections cannot be created directly in the Management Console.
Exporting a QVF from Qlik Sense Enterprise strips the Data connections from the application for security purposes.
Apps created using Qlik Sense Desktop store the Data connections locally within the file
Apps containing Data Connections that are imported to the QMC will retain the Data Connections and add them to the environment.

Resolution:

With these considerations in mind, Qlik Sense Desktop can be utilized to maintain a 'blank' QVF (No loaded data) that contains all the data connections needed for moving to a higher environment or bringing connections into QAP.

Follow this process:

Open Qlik Sense Desktop
Create/Open a QVF dedication for the Data Connections you wish to transfer and maintain
Create the Data Connections in the QVF
Test to verify that the connections work as expected.
Save this QVF and store it (this will be your go-to file to import these connections whenever you need to)
Import QVF into QMC of Qlik Sense Server or QAP to add the data connections

3rd Party solutions:

The information here is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Gitoqlok: How to migrate Data Connections to QAP, Qlik Sense Enterprise

Re: Migrate Data Connections

Mr_Pearl — Mon, 25 Jan 2021 05:38:34 GMT

Hi @Juli_K , I do not follow you. In your point 2 above which QVF are you asking us to open? If I export and use qvf from enterprise than it will not have any data connection in it??? . Can you please explain that point?

Re: Migrate Data Connections

Jay_Brown — Tue, 26 Jan 2021 15:45:05 GMT

@Mr_Pearl the "Desktop" distinction is important here. Data Connections are stored in the app in Qlik Sense Desktop but not, as you have found, in Qlik Sense Enterprise. Please use Desktop as directed in the post.

Re: Migrate Data Connections

Anonymous — Mon, 01 Feb 2021 20:22:40 GMT

Hello,

My client does not have Qlik Sense Desktop, They are moving their apps (qs server enterprise) to QAP server but they need to migrate their db connections too. Any other way to do that?

Re: Migrate Data Connections

Sonja_Bauernfeind — Wed, 10 Feb 2021 11:04:20 GMT

@Anonymous

Hello Land!

Data Connections in Qlik Sense can only be created through the Data Load Editor. Whether that is a Desktop Client or you interacting with an App in the Hub. As of such, if your client wishes to transfer data connections, they will either need to manually recreate them on the hub in the Data Load Editor, or have a .qvf app prepared that includes the data connections so they can import them.

You can recommend them to download the Desktop client and authenticate it to be able to create an app, which they can then store and re-import whenever necessary.

Re: Migrate Data Connections

Anonymous — Fri, 05 Mar 2021 14:51:19 GMT

Hi @Sonja_Bauernfeind

I was doing it with qs desktop for two connections, but later I tried Levi's script and it worked too.

Thanks to both.

Have a nice day.

Re: Migrate Data Connections

AlexPolorotov — Thu, 27 May 2021 11:20:32 GMT

Hi.

You can also use the Gitoqlok solution to migrate data connections between environments.

article How to Migrate Qlik Sense Data Connections (on Windows) in Official Support Articles

How to Migrate Qlik Sense Data Connections (on Windows)

Resolution:

Follow this process:

3rd Party solutions:

Related Content:

Re: Migrate Data Connections

Re: Migrate Data Connections

Re: Migrate Data Connections

Re: Migrate Data Connections

Re: Migrate Data Connections

Re: Migrate Data Connections