Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
.
.
.
.