Hello,

Our Baan works with Oracle. We need to update a baan table from an SQL Server database. I need to create somethig similar to a dblink...

Anybody know how to create it?

Thanks,

María

U can create separate db definition (for oracle and sql ) and attach to different companies (ttaad4120m000) . U need to sql server in ur license . Through tabledef6.1 u can access both db tables in baan and do updations in baan . Maybe that helps if u want an access in baan for both db . From SQL updating / accessing oracle requires just oracle odbc driver .

Hello,

Our Baan works with Oracle. We need to update a baan table from an SQL Server database. I need to create somethig similar to a dblink...

Anybody know how to create it?

Thanks,

María

i connected to oracle via DTS in SQL Server once.... it destroyed my oracle db.. I wouldn't recommend it.

just export to csv and load.

Dave

thats possible throuh db link, we tried once but this process is very slow.You can transfer fata through csv file or can create a interface between twi db using VB or some other language..

In DBlink - their is a risk of virus / worm propogation through the DB tunnel example say - The "voyager" - Oracle worm , etc...

Hence it is recommended - either to build a interface or import the CSV data as specified above.