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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
853 views