Welcome to new ODIExperts experience!.
ODI JDBC EXCEL
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.
- 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
ODI JDBC ACCESS
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 load data from DB/Delimited File into Access DB using ODI Procedure
- Supports Access Datatype BOOLEAN, BYTE, CURRENCY ,DATETIME ,DECIMAL, DOUBLE, FLOAT, INT, LONG ,MEMO ,OLE and TEXT.
Blog
Visit out blog containing various ODI articles , tips and tricks . Published posts can be easily accessed via Alphabetically , Date and Tags
Author
ODIExperts is written and maintained by Cezar Santos and Kshitiz Devendra both with extensive experience in the ETL , Data Warehousing and ODI.
JOBS
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. This page hopefully 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 page, post screening.
Users can view the jobs directly here.
Please note we do not maintain or will gather resume on behalf of any Employer or Firm, so all the users can contact directly the employers depending on the preference of the Employer.Please do not send us resume or contact us for any Job.
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.