Tag: ODI

dbaOnTap, ODI, Oracle, REGEXP_LIKE

Oracle Data Integrator User Functions with Regular Expressions and Dropped Square Brackets

Just the other day I described how you can use Regular Expressions Functions with Oracle Data Integrator. Well that was only part of the story.  Immediately after that post went out, I had several notes from people who are way smarter than me say “put that in an ODI User Function for reusability”.  This post …

dbaOnTap, ODI, Regular Expressions

Regular Expressions Functions with Oracle Data Integrator

Starting with Oracle database 10gR1, 4 Regular Expression functions were introduced that you can use in SQL and PL/SQL statements. This post will illustrate how to use the REGEXP_REPLACE function in a flat file to Oracle database mapping using ODI. The beauty of the ODI implementation is that it takes advantage of the technology within the target …