topic Re: 2 DB's in QlikView

2 DB's

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have to fetch data from 2 data base's , one from oracle and the other from MySQL at the same time .

Is it possible to do so ?

thanks in advance

Re: 2 DB's

kaushiknsolanki — Mon, 23 Mar 2020 06:29:01 GMT

Hi,

Yes you can do that in same script;

After you fetch the data from one database make sure that you use the statement like "Disconnect". This statement will close the connection to your connected database and then you can do the connection to another database.

Re: 2 DB's

smilingjohn — Mon, 23 Mar 2020 07:24:53 GMT

Hi Kaushik

Thanks for the reply , Currently i am using OLEDB to connect to my oracle DB and ODBC driver to connect to my mYSQ DB

will this be atomated if once the connection string is formed or should i maually do it every time ?

Re: 2 DB's

kaushiknsolanki — Mon, 23 Mar 2020 08:48:10 GMT

You will have to manually add the connection string.

Your script should look like below.

Connect ............. - this will be odbc connection string

Load statement

Disconnect

Connect............. - this will be OLEDB connection string

Load Statement

Disconnect