topic Re: Connection String in QlikView

Connection String

shiveshsingh — Wed, 25 Nov 2020 16:16:04 GMT

Suppose i have 2 data sources.

In 1 data source, i have 5 tables and in other i have 3 tables.

I wrote 1 connection string and took 3 tables from first source. Then wrote 2nd connection string and took 3 tables.

Now i need remaining 2 tables from first data source.

Do i need to write first connection string again?

Re: Connection String

Tue, 05 Sep 2017 16:49:20 GMT

Hi Shivesh,

Yes, you'll have to write the 1st connection string again since you have overwritten it with the new one.

Re: Connection String

alis2063 — Mon, 18 Sep 2017 18:00:44 GMT

once connection is established ,you can import the table as per our requires.you don't need to make connection again

Re: Connection String

krishnacbe — Mon, 18 Sep 2017 18:06:36 GMT

You can create QVD for each table from particular connection, then create QVDs from second connection.

So that you can join the QVDs as per your requirement

Re: Connection String

vvira1316 — Mon, 18 Sep 2017 18:07:53 GMT

Hi,

You may want to use Disconnect as needed

Invalid object name

Re: Connection String

Colin-Albert — Mon, 18 Sep 2017 20:42:17 GMT

Hi Ali,

QlikView can only have one connection active at a time.

If you use Connection 1 and load tables using connection 1

Then add connection 2 and load tables using connection 2, you cannot then load tables using connection 1 again without having the connect string for connection 1 a second time in the script.

Load XXX from yyyy. Will always use the most recent connection string.

Re: Connection String

shiveshsingh — Tue, 19 Sep 2017 01:35:42 GMT

That means, we have to write connection string again?

Re: Connection String

Colin-Albert — Tue, 19 Sep 2017 08:24:15 GMT

Yes, you can just copy the connect string line again.

Re: Connection String

Peter_Cammaert — Tue, 19 Sep 2017 09:35:34 GMT

Or put the actual Connection String in a variable and use it as many times as you want. Like in:

SET vConnectionString1 = Blablabla1;

SET vConnectionString2 = Blablabla2;

OLEDB CONNECT TO '$(vConnectionString1)';

LOAD * FROM Table1;

LOAD * FROM Table2;

LOAD * FROM Table3;

OLEDB CONNECT TO '$(vConnectionString2)';

LOAD * FROM Table6;

LOAD * FROM Table7;

LOAD * FROM Table8;

OLEDB CONNECT TO '$(vConnectionString1)';

LOAD * FROM Table4;

LOAD * FROM Table5;

DISCONNECT;

But I would load all five tables from the first connection and the three remaining ones from the second connection. Saves you one connection.

Re: Connection String

Chanty4u — Tue, 19 Sep 2017 09:37:49 GMT

yes if you have multiple data sources you have to use connection string in each tab/table then only it will work

Re: Connection String

avinashelite — Tue, 19 Sep 2017 10:09:18 GMT

Try like this ..

With connection 1 import all the 5 tables required and then connect with connection 2 import rest of the tables ....

Re: Connection String

Chanty4u — Tue, 19 Sep 2017 10:10:58 GMT

Or else you can move all the tables into one server database and load from single server it will be good practice.