Now offering data mining training courses and a dimensional modelling training module

Uli Bethke Oracle, Training

I am proud to announce a couple of new training courses on data mining, master data management, and dimensional modelling at competitive rates. The data modelling training will cover the core concepts of Data Warehousing and Dimensional Modelling. We will also offer two training courses on data mining. The first one of these will be aimed at managers and novices ...

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