Hi Everyone,

BOBS solution is working well in Baan IV c4.

I want to access other databases (other applications database those are running in .net/Java or say People-soft database) in Baan Application, it's possible?

Could anyone please put some light on it? Any idea please…

Thanks,
Sudipta

U can try following with ms sql.
1. tables in other database / application has to follow the baan convention of tppmmmnnnccc .
2. Separate database definition and a company is to be created for such database.
3. Create a db user similar to baan user in baan database in other database. All users requiring to access these data should have db <--> baan user mapping ttdba module.
4. Create a db user with actual name of database equivalent to baandb in the database and maintain the same in ttdba module.
5. Create a role baandbg in target database.
6. Link the company to new database created.
7. If the database is on other server , create remote user data on ttaad2101m000.

With these tabledef , msql files should be well equippedto establish connection to external database.