Can anyone please provide some pointers or insights on how close integration is achieved with Siebel from tools such as Oracle Data integrator (ODI).
Such tools might have to read metadata information from the Business entity level right down to the EIM Tables metadata since knowledge modules in ODI such as - RKM Siebel <database> EIM
Any pointers are much appreciated, thanks in advance !!
The Siebel Adapter makes it easier to introspect the Siebel repository and generate SQL. But if you ask my honost opinion, I think the benefit does not outweigh the investement. It would in most cases be better to create SQL in ODI from the bottom-up. You can also invoke through ODI agents EIM from ODI. The Siebel KM only adds some options to create .ifb and srvrmgr command line invocations.