Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tuanmaciek
Contributor

How to change data source from local to server

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

Tags (1)
1 Solution

Accepted Solutions
arvind654
Honored Contributor II

Re: How to change data source from local to server

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);

12 Replies

Re: How to change data source from local to server

Have you tried editing the existing Data Connections ?

sureshqv
Esteemed Contributor III

Re: How to change data source from local to server

Hi,

Edit the data connection and give your exact connection string or path.

tuanmaciek
Contributor

Re: How to change data source from local to server

Yes, but I can't do this without unlocking data loading. My Computer is my local SQL database, I can't edit it.Connection_170202.png

tuanmaciek
Contributor

Re: How to change data source from local to server

I can do this I think only when I unlock the section that was generated automatically. M

arvind654
Honored Contributor II

Re: How to change data source from local to server

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);

tuanmaciek
Contributor

Re: How to change data source from local to server

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).

DataLoad_170203.png

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:

DataLoad2_170203.png

When I don't unlock it (and can't change connection) my model looks like that:

DataLoad3_170203.png

arvind654
Honored Contributor II

Re: How to change data source from local to server

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.

tuanmaciek
Contributor

Re: How to change data source from local to server

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.

Połączenie_170203.png

And this is my new connection string.

OLEDB CONNECT TO [Provider=SQLOLEDB;Data Source=IBM;Initial Catalog=Analysis;]

Re: How to change data source from local to server

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.