Is it possible to read/call MDM table records from within Baan script? In this instance MDM is running on Oracle (as per BaanV), so one would assume that it could be possible.

For example, we would like to compare MDM item, revision and BOM to that in Baan.

Thanks in advance

If the tables of MDM aren't mapped in the baan data dictionary, surely isn't possible.
In baan you have only visibility of tables that are in the DD, indifferently from the kind of database.
But, if both are in Oracle, you can use instruments of DB to do this (good luck :) ).

Thanks Zardoz,

Heres a crazy question (not that we'd implement it :] ) - Could it actually be possible to setup table def's in Baan that read / link to MDM oracle tables? I imagine the developed sessions being display only. Sounds quite fantastic.

We tried it once. We setup some tables, converted to runtime, then the dba's went in and linked them to the other database instance and tables. We could actually read the data - but we ran into too many issues. Convert to runtime stopped working, or if it did work you would not see your changes. After a week or two of this we pulled it out - then again this was maybe 5-8 years ago, maybe it is better now.