Qlik Sense is a developing product; hence, certain features are not active when running the Desktop version in its standard mode. A prime example of this is using the Custom Connect to statement to create the ODBC/OLEDB connection strings or attempting to connect to a custom database as SAP. Both these activities are not possible if Qlik Sense runs in its standard mode. In order to get these functionalities to run, we need to activate the legacy mode. However, one must note that enabling the legacy mode has security implications, if the application is deployed on the Sense server then one does not have control over the data connections in QMC (if the legacy mode is activated). The library security features may also be lost; moreover, the legacy mode does not work with Qlik Cloud either.
Activating the Legacy Mode requires changing a parameter value in the settings.ini file for Qlik Sense.
- Make sure that Qlik Sense Desktop is closed before opening the
settings.inifile. - Open the
settings.inifile that is by default stored underC:Users{user}DocumentsQlikSenseSettings.ini. - Change
StandardReload=1toStandardReload=0. - Save the file and start Qlik Sense Desktop in order to run it in a legacy mode, as shown:
Changing the value for the StandardReload parameter in the settings.ini file enables the Legacy Mode in Qlik Sense. When running in the Legacy mode, any of the scripts in Qlik View can be directly used in Qlik Sense. This will also allow us to use the library connections.
The Qlik Sense has the capability to use the same script that is found in any Qlikview file. One can also use a binary load statement in Qlik Sense in order to load the entire data model from an existing Qlikview file. All the Custom Connect To statements can only be used after we activate the legacy mode.