Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Loading Excel files with ODI into Oracle Database

choracy69Nov 9 2018 — edited Nov 9 2018

I have question about loading excel files into oracle database.

I have access to 12 Excel Files (16 branch) - every excel has 4 four tabs (called: 100,101, 102 and 103)

And now I want load data from excels to four table: 100, 101, 102, 103.

Every excel (and tabs) has the same structure - in this case it's ok.

I have ODI 12.

My question is: how can I import data in ODI from excels and loading it into Oracle Database in Source Scheme?

I know that I can transform this excels to .csv files and it is easy to do, but I must refresh data daily  - that's why csv is not a solution.

Unless can I automate transformations .xlsx to .csv? For example I have excel with macro or something else when I use one click and it transform every .xlsx to .csv?

What is a different way?

I find i ODI Technologies Physical/Logical Microsoft Excel - but what with JDBC Driver for it? Can I download for free?

I wll be grateful for any suggestions.

Comments
Post Details