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.
Related Content:
Data Connection migration
.png "Former Employee"){kind=icon}
