Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

edit script-various databases

hi all.

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

7 Replies
eruditio
Partner
Partner

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;

Not applicable
Author

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

Not applicable
Author

Yes you are right...

eruditio
Partner
Partner

Yes, it is possible and made for this

Good luck !

Not applicable
Author

I would advise you to go through the following:

QlikView Free Training