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!

export csv from Microsoft Access file in ODI 12C

user12251389Jun 14 2022

Hallo All,
I am using ODI 12C.
I have Microsoft Access file from which i want to export tables as csv files and then load this csv into oracle database table using ODI.
Currently i am investigating how to setup topology and other parameters which are needed for Microsoft Access file but did not find much help and also not sure how to do.
I see we already have Microsoft Access topology but dont know how to setup JDBC parameter :
image.png
Does anyone have any experience and can provide any example will be really helpful.
Thanks and regards!

Comments
Post Details