topic Multiple database connections with OLEDB in QlikView

Multiple database connections with OLEDB

Fri, 17 Jan 2014 17:32:44 GMT

Hi All,

I would like to connect to 2-3 databases first and then run the scripts in other tabs. Does Qlikview allow it?

For example:

Database Connections tab

OLEDB Connection 1

OLEDB Connection2

Script tab 1

Script that needs DB connection 1

Script tab 2

Script that needs DB connection 2

Script tab 3

Script that needs DB connection 1

Can scripts jump from connection to connection or does it have to be as below?

Database Connections tab

OLEDB Connection 1

Script tab 1

Script that needs DB connection 1

Script tab 2

Script that needs DB connection 1

Database Connections tab

OLEDB Connection 2

Script tab 3

Script that needs DB connection 2

Thoughts/ suggestions?

Thank you.

Re: Multiple database connections with OLEDB

Gysbert_Wassenaar — Fri, 17 Jan 2014 17:39:22 GMT

Qlikview can be connected to only one data source at a time. So you need to connect to the correct data source first before getting data from it. So your second setup will work while the first will fail because the first connection is disconnected because right after the second connection is made. That will make the code on the first script tab to fail.

Re: Multiple database connections with OLEDB

Tue, 28 Jan 2014 15:07:04 GMT

Thank you for your response.