Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've created an app with connection source to my local server (on my computer). I would like to change it's credentials to the server, which has got the same databases etc.
I'm not sure is this possible with Qlik Sense Desktop. I'm affraid I will have to make all connections once between data again.
I would like to have this change without unlocking Data Load.
Maciek
Create a New local connection and change your from destination for the from script.
Previous SQL data load
Ex:
From YourViewName.ABS
change it to
FROM [lib:/YourLocalConnection/XYZ.xlsx]
(ooxml, embedded labels, table is SheetName);
Have you tried editing the existing Data Connections ?
Hi,
Edit the data connection and give your exact connection string or path.
Yes, but I can't do this without unlocking data loading. My Computer is my local SQL database, I can't edit it.
I can do this I think only when I unlock the section that was generated automatically. M
Create a New local connection and change your from destination for the from script.
Previous SQL data load
Ex:
From YourViewName.ABS
change it to
FROM [lib:/YourLocalConnection/XYZ.xlsx]
(ooxml, embedded labels, table is SheetName);
You're right however, it' s possible only, when I unlock data load. This will result in fact I cannot manage my tables, connections (keys) between them etc. (maybe I don't loose it, but I don't now how to behave in that situation).
When I unlock this section, I can simply create another connection and change the text in upper section from "MACI" to my new connection name.
But it results in something like that:
When I don't unlock it (and can't change connection) my model looks like that:
Yeah, just unlock it.
Why can't you unlock? Unlock will not effect the script or data, it will just allow you to edit the script.
If you worried then make a duplicate of this app, unlock the sheet and make a new connection.
After you make a new connection, are you giving that name in From or LIB ?
what's the new connection name and can you also paste the screenshot of new connection name & script?
Thanks.
I thought I will be able to have my connection changed as well as I will not lose the ability to manage my data from Data Manager. So this is a normal situation that Qlik users unlock data and manage it manually. Is it possible then to set key references between tables manually in this situation?
This is my Data load after changes.
I gave its new name in LIB.
And this is my new connection string.
OLEDB CONNECT TO [Provider=SQLOLEDB;Data Source=IBM;Initial Catalog=Analysis;]
I must admit I have never used the QlikSense Data Manager.
Having come from a QlikView background I am comfortable writing load scripts and to be honest see no advantages that the Data Manager would give. I expect those who have come straight into QlikSense with no exposure to QlikView may well have a different viewpoint, indeed in due course I may well find some advantages of the Data Manager.
When you say "set key references between tables manually", I think you mean giving the same name to 2 fields in 2 tables to create an association between the 2 tables. This can be done manually in the load script by renaming fields with script like this :
Load
OldFieldName as NewFieldName,
........... etc...........
Just my personal opinion, other people's opinions are available.