topic Multiple Data Sources in QlikView

Multiple Data Sources

Mon, 14 Oct 2013 06:23:10 GMT

Hi guys,

Please tell me,when we pull data from SAP to Qlikview,we use a SAPConnector and thus its connection string.

Similiarly,When we pull data from an Oracle table, we use an OLEBDB Connector and thus its connector string.

Please tell me,can we have both these in the same generator file?

What I mean is: Would both connection strings conflict?

How can we achieve both connection strings in the same file?

Rochelle

Re: Multiple Data Sources

jagan — Mon, 14 Oct 2013 06:52:12 GMT

Hi,

You can use any number of datasources in one single Qlikview file, please check below script

ODBC CONNECT TO OraDatabase;

SELECT *

FROM Products;

CONNECT TO SAPData;

SELECT

* FROM Transactions;

Initially, Products data are loaded using first connection string, and when the second connection string is opened the first will automatically close. Now Transactions data is loaded using second connection string.

This way, there is no connection string conflict. At a time there is only one open connection string.

Regards,

Jagan.

Re: Multiple Data Sources

Peter_Cammaert — Mon, 14 Oct 2013 07:17:47 GMT

As Jagan says, only one active data connection at a time. But you can open any number of connections in sequence.

A good practice is to separate each data transfer from a different source in a different script file, and "$(include)" them in the order you want. SAPConnector transfer scripts tend to become very long because of the large number of fields, and mixing things may lead to mistakes.

BTW QlikView also has a statement for closing the current connection:

DISCONNECT;

Best,

Peter

Re: Multiple Data Sources

Peter_Cammaert — Thu, 17 Oct 2013 08:07:37 GMT

If this feedback was satisfactory, please close the discussion by marking a post as Answer. That makes it easier for us to track unanswered questions.

Thanks,

Peter