topic Re: Connection to multiple databases(SQL server & Oracle database) in QlikView

Connection to multiple databases(SQL server & Oracle database)

vireshkolagimat — Tue, 08 Aug 2017 14:59:12 GMT

Hi All,

Is it possible to get the data from two tables which are available in different databases i.e one is SQL server and one is oracle database.

I have some old data in the SQL server and new data in the oracle database and have show all the data in the Qlikview dashboard.

What is the best way to manage in this situation. Can i move all my data from SQL server to Oracle database or shall i keep old data in the SQL server and get the new data from oracle database.

Thank you.

Regards,

Viresh

Re: Connection to multiple databases(SQL server & Oracle database)

ahaahaaha — Tue, 08 Aug 2017 15:03:05 GMT

Hi,

I think you need to collect all the data in QlikView "as it is". Connect sequentially in the script code to your two databases and load the necessary data.

Regards,

Andrey

Re: Connection to multiple databases(SQL server & Oracle database)

Anil_Babu_Samineni — Tue, 08 Aug 2017 15:07:33 GMT

Off course, There is no limit to achieve this?

And, My preference is always, First load one server data and store it into QVD then load second connection from another source. Same way we can do