Using WIP Folder Connections
Connecting to Qlik Sense Folder Connections (or Data Connections) can be quite tricky as Qlik is not providing anny API to manage their content. WIP will use network shares to get around this problem, and of course network sharing means Windows AD permissions and : authorizations problems
List Connections
To retrieve the list of connections WIP will use the QRS API and list all connections of Type = “folder” this straightforward
Get folder connection content
This is where it gets tricky because qlik does not provide an api for this task. WIP will open the connection, and get the “connection string” and
a) if it is a network connection starting with "\\" it will use it directly so PATH = “\\Nas01\QV Apps\Clinical”
b) it’s a local connection starting with a drive letter “E:” in that case it will be transformed to
PATH = ”\\Url\DriveLetter$\path” so “\\QlikServer Url\E$\QV Apps\Clinical Variation\”
Where the “Url” is defined as below in Url so in our case “\\ebiwin2016poc\E$\QV Apps\Clinical Variation\”
And it’s here the trick to connect a network connection we need a
path
username
password
The username depends :
for Browse it’s the Logged-In user (WIP\POCAdmin)
for Destination it’s the Server Username (WIP\EBIAdmin)
Debugging WIP Folder Connections
You can have issues
0 Comments