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 ...

ODI article Oracle magazine

Uli Bethke Oracle Data Integrator (ODI)

For those of you who have missed it there was an article on ODI in the September issue of Oracle magazine. Nothing breathtaking but two nice case studies: View the article.

ODI Snippets: Installing multiple ODI agents on one server

Uli Bethke Oracle Data Integrator (ODI)

Sometimes it may come in handy to have multiple agents running on the same server, e.g. if you want to use a particular agent to execute scenarios for a particular project. I had a requirement recently where users were dropping Excel files into shared folders on a server. We had one folder for Dev, one for UAT, and one for ...