Under the hood of the Sunopsis Memory Engine. Part 1.

Uli Bethke Oracle Data Integrator (ODI)

Oracle Data Integrator not only uses hsqldb for its demo environment. It is also used as the in memory database for the so called Sunopsis Memory Engine. “It is possible to run HSQLDB in a way that the database is not persistent and exists entirely in random access memory. As no information is written to disk, this mode should be ...

ODI: Automating deployment of scenarios to production in Oracle Data Integrator

Uli Bethke Best Practice, Oracle Data Integrator (ODI)

In this post I will show you how you can automatically deploy scenarios in ODI. It is rather cumbersome to manually deploy scenarios from a test/development to a production environment. Typically it involves the following steps: - Manually (re-)generate all scenarios that need to be deployed and any child scenarios referenced. - Manually export the (re-)generated scenarios - Log in ...

ODI Snippets: Oracle Data Integrator, Excel data types, and limitations of the MS Excel ODBC driver.

Uli Bethke Oracle Data Integrator (ODI)

I have come across two serious issues when loading data from Excel into Oracle Data Integrator. These are not related to ODI, but are shortcomings of the Microsoft Excel ODBC driver. Both issues are explained on Metalink: (1) Excel Returns NULL Values When Numeric And Alphanumeric Datatypes Are Intermixed Within The Same Column (424419.1) Extract from Metalink "Having defined a ...