ODI 11.1.1.6 is out for some time now, and I still did not had a change to share anything about it or even play with it as I should have. The 11.1.1.6 version introduces some really nice new features and it also supports Java 7 (!) on certain platforms, which are listed in the Oracle [...]
Unexpected Java Runtime Environment Errors Starting ODI Agent
Unexpected Java Runtime Environment Error… These are the kind of errors I like the most. When you see such an error being thrown when starting ODI agent in a production environment, you can go ahead and cancel dinner. Fortunately, for me, this error was on development server, so I had quite a nice dinner that evening. [...]
Knowledge Modules, Procedures or Open Tools
Deciding when to use knowledge module, ODI procedure or an OpenTool is a debate every ODI user will have to face eventually. When facing such a decision, there are some points that make it an easier choice to make. This post is not written to explain ODI KM, ODI Open Tool, ODI procedure or any technical [...]
Open Tool Tips
Developing an ODI Open Tool is quite simple. Some Java skills and understanding are required, but it is totally not needed to be an expert. The guide is pretty good, it explains how to build OpenTools and how to put them for Oracle Data Integrator to use. The tutorial can be found in the ODI [...]
Python Custom Files In ODI
Some time ago I saw an email on one of the email lists in which, the author asked how to import custom python modules into ODI. When reading this email, I did not know, what would be the best way to perform such a thing and that made me a little curious. After a while, [...]
Do Not Draw That Red Line
It is a common thing, for a data integration process to have some kind of exception handling, when one of the parts in the flow fail. The same can be said about ODI, usually when designing a package, in order to handle failing steps people tend to draw a red line from every step in [...]
ODI Repositories
The repositories are database schemas which store all the information regarding the tool and it’s operations. More specifically, anything done from within ODI is stored there. The only exception, are the installation files that are used to run and configure the application itself. Each ODI repository type consists of different table structure and contains different [...]
ELT Drill Down
Today I read some articles about ELT versus ETL, I have noticed the large amount of information available about ETL and the smaller amount of information out there concerning ELT data integration approach. So, without writing another article of what is the difference between them or which one is better, I have decided to introduce this [...]