ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

ODI JDBC Excel

No more development/support for this driver.The codes are available if anybody is interested can take the code and provide support



Overview


Reading and Writing Excel is a big challenge in ODI ,especially in the Non-Windows environment . Today from ODIExperts we provide a unique solution that 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 Single/Selective/Multiple Sheets simultaneously
  • Rewrite into existing Excel file
  • Faster Loading of huge data into Excel (XLSX) using less memory.
  • Supports Excel Datatype CURRENCY , DATE , DATETIME , NUMERIC , PERCENTAGE , SCIENTIFIC and VARCHAR
  • UnloadTables API to unload data into same/different Excel File using ODI Procedure.
  • Style Excel header while writing

Compatibility


ODI 10G & ODI 11G both are supported now. Above all its free . No more limitations.


ODI JDBC EXCEL Technology



ODI JDBC EXCEL Technology is a specialized ODI Technology to support the ODI JDBC Excel Driver and support the various Excel datatype.



Knowledge Modules



RKM



  • Reverse Single/Selective/Multiple Sheets simultaneously.
  • Specify Header Row No and Reverse any Sheet in File.

LKM



  • Trim Columns while Loading.
  • Load excel file from any environment.

IKM



  • Write/rewrite excel into any environment.
  • Style Header with Color, Boldness and alignment.
  • Write huge data into xlsx faster and with less memory.
  • Format Date , Date time , Currency Symbol and numbers with precision.

API


We have also introduced an UnloadTables API,which can be used to Unload Single/Multiple DB Tables into same/different Excel File using ODI Procedure.


Download


ODI JDBC EXCEL is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. You are free to download and use this driver.

The below download contains the following

  • ODI JDBC Excel Technology.
  • RKM EXCEL
  • LKM EXCEL TO SQL
  • IKM EXCEL INSERT
  • ODI JDBC EXCEL.jar
  • PDF Documentation

Download for ODI 11g   


Download for ODI 10g   

Support



Please provide us a 2-5 days to reach back to you for any errors. Please provide the following information while reaching for an Excel Driver Issue

  • ODI Version
  • Error Message
  • ODI Step and Process Information
  • If possible the Excel File else the screenshot.

Online Documentation


Please browse/download the ODI JDBC Excel Documentation which contains all the detailed information.


Download Documentation


Contact us


Please feel free to contact us for any question on the driver

Please let us know your feedback , comments and functionality you want us to include in future versions