2 DB's

[smilingjohn]

Hi All, 

I have to fetch data from 2 data base's , one from oracle and the other from MySQL at the same time  .

Is  it possible to do so ? 

thanks in advance 

[kaushiknsolanki]

Hi,

Yes you can do that in same script;

After you fetch the data from one database make sure that you use the statement like "Disconnect". This statement will close the connection to your connected database and then you can do the connection to another database.

[smilingjohn]

Hi Kaushik 

Thanks for the reply , Currently i am using OLEDB to connect to my oracle DB  and ODBC driver to connect to my mYSQ DB 

will this be atomated if once the connection string is formed  or should i maually do it every time ?

[kaushiknsolanki · Accepted solution]

You will have to manually add the connection string.

Your script should look like below.

Connect ............. - this will be odbc connection string

Load statement 

Disconnect

Connect............. - this will be OLEDB connection string

Load Statement

Disconnect