topic How to load data from sql and oracle Databases ? in QlikView

How to load data from sql and oracle Databases ?

Anonymous — Wed, 06 Jun 2018 10:26:07 GMT

Hi,

I want to load data from different servers like, Sql and Oracle is there any operation is to perform between the two connections.

For example, how to create the chart using fields from two databases.

Pls help....

Regards,

Sai

Anil_Babu_Samineni — Wed, 06 Jun 2018 13:33:05 GMT

First you need to arrange data model to map each using primary key then only we can use those? Can you share DM?

kfoudhaily — Wed, 06 Jun 2018 13:41:58 GMT

hello,

it shouldn't be a problem that your data sorces are different, but i'm guessing they have fields in commun.

So in order to analyse your data you need to create a data model in qlikview that contains usefull data from both databases.

have you already established connections to your databases?

Have you already loaded the needed data?

provide exemple i might a little more help for you.

Please mark as usefull if it is for you.

regards,