new to connect two diff datasource

[kunkumnaveen]

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

[avinashelite]

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

[kaushiknsolanki]

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

[sasikanth]

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

.

.

.

.