topic Re: multiple conn strings? in QlikView

multiple conn strings?

Anonymous — Tue, 05 May 2015 01:07:34 GMT

Hi experts,

i am creating qvd

i am loading data from 2 different data sources for example

odbc to oracle;

odbc to sql server;

and here i have one table from odbc to oracle connection and another from odbc to sql server

but when i go for reload it is talking last connection string only ?

i want this application should connect to both database and while reloading it should not give any error?

Re: multiple conn strings?

Anonymous — Tue, 05 May 2015 03:09:46 GMT

Hi,

load both the databases and store them in QVD files. Then, I load both QVD (which is quite fast) in the same table.

Although for clearer code you may use the CONCATENATE keyword

Regards

Sagar

Re: multiple conn strings?

Anonymous — Tue, 05 May 2015 03:27:57 GMT

Hi,

You will only have one connection open at any time.

Connect to source A and load required tables, then connect to source B and load required tables.

You can always re-connect to source A later in the script if required for additional data loading using a new connection string.

Re: multiple conn strings?

Anonymous — Tue, 05 May 2015 03:48:59 GMT

can any one give sample script

Re: multiple conn strings?

rajeshvaswani77 — Tue, 05 May 2015 03:52:17 GMT

Hi,

You can do it this way.

Connection string 1

Code / SQL related to tables in connection 1 here

Connection string 2

Code / SQL related to tables in connection 2 here

thanks,

Rajesh Vaswani

Re: multiple conn strings?

Tue, 05 May 2015 04:07:28 GMT

Hi,

try this.

Connection odbc to oracle

load *

table.

Store into QVD;

Connection odbc to sql server

load *

table

Store into QVD;

Regards,

Chennaiah

Re: multiple conn strings?

Tue, 05 May 2015 06:34:33 GMT

you cannot connect multiple databases at a time.

connect to oracle

select * from tablename

disconnect;

connect to sql server

select * from tablename

disconnect;

and so on....