View Single Post
Old 19th October 2012, 12:56
litrax's Avatar
litrax litrax is offline
Senior Member
Join Date: Sep 2005
Location: Germany
Posts: 108
litrax is on a distinguished road
Baan: ERP LN (10.2.1) - DB: Oracle12c ( - OS: Red Hat Enterprise Linux 7.1
Lightbulb Load files directly into Infor ERP tables - Cookbook

Hello Baan-Tools- and Oracle- Developers/Administrators,

I don't know if any one tried this out already, but I did.
Here is a little cookbook of what I've done:

Mainly I combined two techniques:
  1. I took the trick of changing an Oracle Table to a View of the same name and structure letting Infor ERP not knowing that.
    If everything works well Infor ERP shows the contents of the Oracle View if you select the Infor ERP Table.

  2. I took the Oracle External Tables to load a file into an Oracle Table
    More information about Oracle External Tables can be found here:

    For all the german speaking developers I recommend the following links:

So the file goes throug Oracle Loader throug an Oracle View directly into an Infor ERP Table ;-)
Just read the SQL- Script I attached and test a little bit on your testserver and I swear you can instantly imagine several things to use this technique for:
  • Read Logfiles to Infor ERP Tables
  • Read data exchange files to Infor ERP Tables
  • Read ASCII reports from jobs to Infor ERP Tables
  • .
  • .
  • .

NOTE: I changed the script to a general format.
I give no warranty that it works.
A few things must be converted to your environment like directorys, Infor ERP Table name, etc.

Good Luck!
Attached Files
File Type: sql external_table_install.sql (7.6 KB, 97 views)
Have a lot of fun...

Please look at this before asking wholes in the stomach ;-)

Last edited by litrax : 26th August 2013 at 10:28. Reason: Corrections
Reply With Quote