We are in the process of evaluating service software packages from Siebel and Metrix. I would like to know if anyone knows how to read/update data from another package from a Baan script. We're using Baan IVc, with A&D extentions, and Oracle 8.

Thanks for any input.

You could use BOIs. It’s a tad slow.
I worked with BCBE. It can be a pain at times :)

Check out Open World.
I have never used it.
I guess it’s available for Baan IVc3.
Open World is supposed to be a far superior product.

Cheers,
Madhu

Thanks Madhu. We will be looking at Open World, but what I was looking for was a way to define an already existing Oracle table to Baan so that I could write a script using the data.

I have heard of "Oracle Sync".
Never done it myself.

If I am not wrong, this is how it works.

For e.g. You have 2 apps - i2 and Baan.
There is a table in i2 from which you want to read info into Baan.
You can do it at the Data base level.
Basically you can populate a Baan table at the DB level.
I guess it will not be "real time" though.

Hope this helps.
Cheers,
Madhu

Technical speaking it's should be no problem. If the tables are in another database you should create a db link and synonyms for the other tables in the baan oracle database.

Then you have to define the tables within the dd of Baan. There could be a problem, does Baan support all the kind of fields that the other packages are using within the tables? I guess for retrieving that should be no problem.

The db-link/synonyms work for sure, we use that e.g. if a customer wants to use different Oracle instances for different companies, by defining the db-link/synonyms we can still use one company 000.

Regards,
Han Brinkman