Top Articles

SQL Visualisation Guide – Query Diagrams, Lineage & ERD

Have you ever inherited the SQL codebase from someone else where it is in a “bit of a mess”? 😁 Sound familiar? Most data engineers and SQL developers have been there including myself—staring at a spaghetti-like web of queries, trying to untangle a chaotic SQL codebase. It’s a common nightmare. Traditionally, you had to fight …

Uli Bethke November 3, 2024

Recent Articles

Oracle Data Integrator (ODI): Timestamp with local timezone and daylights saving time

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes   [wpcode id="26679"] If you are you using the Oracle data…
Uli Bethke October 16, 2010

Subselect, derived tables, and subqueries in ODI 11G

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes I think one of the best new features in ODI 11G is the subselect/subquery…
Uli Bethke September 9, 2010

Nesting ODI Substitution Methods. Part II.

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes Today we look at how we can escape quotes when nesting…
Uli Bethke June 24, 2010

Calling custom Java classes and JAR files in ODI via Jython or Java BeanShell

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes First we create a simple Java class that creates and writes…
Uli Bethke June 9, 2010

Craig Stewart's Oracle Data Integrator (ODI) video tutorials

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes Craig Stewart has put together a superb set of ODI video…
Uli Bethke June 5, 2010

ODI and analytic functions (again???)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes My friend and colleague Maciej Kocon has come up with the…
Uli Bethke May 20, 2010
spinner