How to copy an OLE DB connection string from an QlikSense app?

[imsushantjain]

Hi ,

I want to copy a OLE DB connection string from an QlikSense app, as I want to include it in a QVS file and then further call the QVS for connecting to database.

The connection string produced in Qlik Sense is "LIB CONNECT TO '10.1X.2X.X2';", which doesn't work when included in a QVS file.

Any help/best practice

Regards

Sushant

[felipedl]

Hi Sushant,

Since Sense works with the concept of data connections (the list of folders, db connections, web files and etc on the right pane of the Data Script Editor) you'll have to create the same connection on all the apps with the same name to be able to put the connection on a QVS file and call it inside the script.

On QlikView, you'd just have to call the string to get what you need, Sense has a different concept on that and hence it needs the creation of the data connection in all apps you need.

For instance, to access the "LIB CONNECT TO '10.1X.2X.X2';" you'll need to create the 10.1X.2X.X2 data connection on the app, for the statement to work as an outside script inside the QVS file.

Additionally, to get the string to work on View, you'd have to copy how it was set on sense, not the data connection string.

Hope it clarified.

[imsushantjain]

Okay, i understand that i can not use data connection string in QlikSense.

Then how do you handle movement of Apps from Dev to Test to Production? At each movement i will have to liaise with the Admin team to repoint my application to different DB, it won't be seamless.

I am trying to implement this how to automate application (qvw) switch between development and production database connection stri... but for QlikSense!

Regards

Sushant