topic Re: edit script-various databases in QlikView

edit script-various databases

Mon, 26 May 2014 05:33:14 GMT

hi all.

need to load some tables from sql server 2008 and oracle in single load script.kindly expalin with example.

Re: edit script-various databases

Anonymous — Mon, 26 May 2014 10:58:04 GMT

HI,

I am not sure if I understand you well.

Start by connecting to sql server via a connection string

Load all table that you want

Disconnect

Then connect to oracle,

Load all tables you want

Disconnect

For the load statement, there are enough resources around that.

A simple example:

Table1:

Load field1, field2, field3 as uwv;

SQL

Select * from table;

Re: edit script-various databases

Tue, 27 May 2014 06:17:04 GMT

hi erudito,

suppose i have 5 tables to load in a load script (three from sql db and 2 from oracle ),first i can use a oledb connection to connect to sql server and select the tables i need.Then i have to load oracle tables by setting another oledb connection to oracle and choose tables????will it be possible and works correctly??

I hope you understand now.

Re: edit script-various databases

ashfaq_haseeb — Tue, 27 May 2014 06:23:12 GMT

Hi Kumar,

It works the same way you specify and yes you are on the right track.

Regards

ASHFAQ

Re: edit script-various databases

Tue, 27 May 2014 06:41:14 GMT

Yes you are right...

Re: edit script-various databases

Anonymous — Tue, 27 May 2014 08:36:52 GMT

Yes, it is possible and made for this

Good luck !

Re: edit script-various databases

hic — Tue, 27 May 2014 12:12:50 GMT

HIC

Re: edit script-various databases

Tue, 27 May 2014 12:17:53 GMT

I would advise you to go through the following:

QlikView Free Training