TechWare

I have put together a link list of all the ODI resources I know off on the web. If you know any other relevant resources contact me and I will add it to the list below. In my opinion the best place to get started with is the Data Warehouse Best Practices using Oracle Data Integrator Enterprise Edition guide. This explains the concepts very well and also has some detailed examples on Knowledge Modules, the Substitution API, setup, deployment etc. ODI OTN Discussion Forums I monitor the ODI forum on OTN at the end of each day to see if any relevant items have been discussed. Oracle By Example: Oracle Data Integrator The Oracle By Example (OBE) series should be one of the starting points for learning any new Oracle technology. The OBE for ODI series is a must. Documentation Download all relevant PDFs on Knowledge Modules, the Substituion API, Jython, ODI Tools etc. from the documentation page. ODI homepage on the Oracle website Blogs Rittman/Mead ODI Experts John Good...

I am going to be writing up a few posts and tutorials on the basics of the architecture (see previous post) and a few beginner topics to get the masses in a mode where they are not intimidated by this tool. The previous post described various aspects to ODI, and the architecture. We saw various GUIs that ODI allows us to use. This post (and possibly another one or two) will look at the DESIGNER GUI in more detail. One of the first things I will say is that the tool can feel a bit foreign if you come from an Informatica/OWB type background like myself. The emphasis is on building smaller and reusable pieces of code, if you will. Other tools that tend to be more ETL based (Informatica) and also more GUI and non-declarative based (OWB) are not necessarily the easiest tools to break things into small pieces. Yes, there are many that say breaking mappings into smaller pieces is a best practice, but the tool doesn't necessarily thrive on your ability to follow th...