The blog for Oracle Data Integrator ( ODI )

Welcome to new ODIExperts experience.


ODI PARALLEL contains codes and KM specifically written to support the following functionalities.

  • Unload Multiple Tables with Headers in Parallel.
  • Load Multiple Huge Files in Parallel with out any DB Utility.
  • Load C$ in Parallel.
  • Advanced File Loading utility supporting Footer , Skip certain Lines , Capture DB Error without failing File and so on.
  • HTML Email with advanced Styling , authentication Support and more .
  • API such as Get File Row Count , First 100 Rows and Jython to Java and so on.
  • and many other features ...
  • ODI 11g presently supported.

ODI PARALLEL is in beta version and may contains some bugs/issues


Reading and Writing Excel is a big challenge in ODI ,especially in the Non-Windows environment . Today, from ODIExperts we provide an unique solution which will enable you to Reverse, Load and Integrate (Read/Write) Excel XLS and XLSX files.

ODI JDBC Excel is java based Excel driver written specifically for ODI to deliver better and faster ETL experience with Excel as Source or Target.

Some of the key feature of this Driver are :-

  • Reverse , Load and Integrate(Read/Write) Excel XLS and XLSX files.
  • Reverse Multiple Sheets simultaneously
  • Rewrite into existing Excel file
  • Faster Loading of huge data into Excel (XLSX) using less memory.
  • Style Excel header while writing
  • No Microsoft Office required / DSN for any of its Operation
  • Now supports both ODI 11g and ODI 10g
  • Above all its free Now !!!

ODI JDBC Excel is now available for ODI 10g and ODI 11g and above all its free to Download with no limitations


ODI_JDBC ACCESS is java based Access Driver written specifically for ODI to deliver better and faster ETL experience with Access as Source or Target.Access 2000 and later are only supported presently

Some of the key feature of this Driver are :-

  • Reverse , Load and Integrate Access DB
  • Reverse Single/Multiple Tables simulateneously
  • Rewrite into existing Access
  • CopyTable and copyFile API to move data from DB/Delimited File into Access DB using ODI Procedure
  • Supports Excel Datatype such as BOOLEAN, BYTE, CURRENCY ,DATETIME ,DECIMAL, DOUBLE, FLOAT, , INT, LONG ,MEMO ,OLE ,and TEXT . GUID (Presently not supported)


Visit out blog containing various ODI articles , tips and tricks. Published posts can be easily accessed via Alphabetically , Date and tags


ODIExperts is written and maintained by Cezar Santos and Kshitiz Devendra both with extensive experience in the ETL, Data Warehousing and ODI area.


ODIExperts have always tried to help the ODI users and community through ODI Forums , One on One via Emails and various other ways and continuing that trend we are also happy to introduce a Jobs page specifically Jobs related to ODI around the Globe. Jobs page hpefully can benefit Employers and Employees looking for Full time/Part time/Consulting Position.

Employers can fill this form that will be posted on the Jobs Posting page, post screening.

We hope this will provide a great experience for all the ODI Community. We would love to hear Employers/Users opinion and comments to make it a better and friendly option.

Contact us

Have any suggestion or comments for us to help you better . Please feel free to reach us.