edit script-various databases

[#1]

hi all.

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

[Anonymous]

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;

[#3]

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.

[ashfaq_haseeb]

Hi Kumar,

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

Regards

ASHFAQ

[#5]

Yes you are right...

[Anonymous]

Yes, it is possible and made for this

Good luck !

[hic]

See also http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/14/merging-data

HIC

[#8]

I would advise you to go through the following:

QlikView Free Training