Skip to Main Content
Forums

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!

Is there a simpler way to load multiple files?

StianAtWorkOct 7 2016 — edited Nov 2 2016

Hi,

I have been in several projects loading multiple files/XML by looping a pre populated table with file names. But what bothers me is the need of this extra step to create a flat file, load flat file to table before looping it.

What if there was a way to use the Source Command and Target Command in a procedure to fix this. A couple of ideas that I have not been able to implement and not sure is possible:

  1. Using Groovy, Java, Jython or any other supported language in Source Command to feed INSERT INTO <TABLE> in Target Command.

  2. Alternatively if I could use ODI SDK and groovy to log on to the database. Loop the files and insert into table in one script. I have not figured out how to do this without hard coding the database password.

Any suggestions, ideas?

Regards

Stian
This post has been answered by SH_INT on Oct 11 2016
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 30 2016
Added on Oct 7 2016
#business-intelligence-applications, #data-integrator, #load, #multiple, #procedure, #script, #system-management-and-integration
4 comments
904 views