topic Re: new to connect two diff datasource in QlikView

new to connect two diff datasource

kunkumnaveen — Fri, 12 Feb 2016 06:03:47 GMT

Hello all,

what i am looking is how to fetch the data from two different data source i mean

currently i am connected to and fetching data from SAP ECC server.....which is succesfull

challenge is i need to connect different server to fetch data..so my question is do i need to disconnect the first connection before i connected to the second one or i can partially connect to both the server at the same time

Re: new to connect two diff datasource

avinashelite — Fri, 12 Feb 2016 08:11:45 GMT

you can connect for both but once you connect the second data base the first connection will automatically get disconnected and you cannot refer to the first connection tables .....

EG:

ODBC 1

Table1:

Load * from

table ;

ODBC 2

Table2:

load * from

table2;

here once you connect the second odbc than you cannot pull the data from the 1 odbc ...you can pull the data from second connection ..

Hope you got the information what you needed

Re: new to connect two diff datasource

kaushiknsolanki — Fri, 12 Feb 2016 08:15:01 GMT

Hi Naveen,

Yes it is always recommended that you close the earlier connection first and then connect to other data source.

User "Disconnect" key word to disconnect the connection.

Regards,

Kaushik Solanki

Re: new to connect two diff datasource

sasikanth — Fri, 12 Feb 2016 08:17:34 GMT

hi,

end of the day you need to store the data into QVDs so do like

Connection string 1

Load Table1

store table1

Load tabl2

store tabl2

Connection 2

Load Table 3

store table3