Go Back > Forum > Baan SIGs > Code & Utilities

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 54

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 19th October 2012, 13:56
litrax's Avatar
litrax litrax is offline
Senior Member
Join Date: Sep 2005
Location: Germany
Posts: 109
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, 99 views)
Have a lot of fun...

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

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

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Programming Question mr_suleyman Tools Development 37 11th November 2016 09:14
Is it possible to write directly in Baan tables from an external interface? gaetan_m Open World, Portal & Decision Manager 2 27th March 2005 01:01
How can I restore dumps of TT package tables? zyilmaz Tools Administration & Installation 12 31st January 2005 11:45
can not able to load tables chingi Operating Systems & Databases 1 17th March 2003 10:29

All times are GMT +2. The time now is 18:02.

©2001-2018 - -