How to connect SQL server and Oracle in the same application?

[#1]

I  wanted to display data from SQL Server and Oracle Server without success. I tried to put machine generated syntax on different tab, and put into one tab, still does not work. Is this possible to connect to different servers in Qlikview? Thanks

[nagaiank]

You can connect to one data source at a time. So connect to SQL server and load data into Qlikview. Then connect to Oracle and extract data from there.

After getting data from both sources, you can display your charts/tables fromm the in-memory data in Qlikview.

[#3]

I seems like that I can get the data from individual source, but I got error message when reload both data into Qlikview.

[Miguel_Angel_Baeyens]

Hi,

There is no problem as long as you have different CONNECT strings to the different data sources. If that keeps throwing errors, upload some example script so we can check further.

ODBC CONNECT TO Source1; // sample dummy string
Customers:
LOAD *;
SQL SELECT *
FROM Source1.Customers;
ODBC CONNECT TO Source2; // This disconnects from Source1 and connects to Source2
Vendors:
LOAD *;
SQL SELECT *
FROM Source2.Vendors;

Hope that helps.

Miguel

[#5]

It works now. The only problem is that how to let Qlikview know which connection I use for query building. It uses the first connection in Mail tab as default. Can I change the default connection? Thanks!

[jonathandienst]

Hi

As Miguel's script shows, Qlikview uses the most recent connection for the load. So connect to the SQL source, run all the extracts from SQL Server. Then connect to the Oracle source (which automatically disconnects SQL Server), and run all the extracts from Oracle.

There is no 'default' connection, only the most recent connection.

Regards

Jonathan