Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Code & Utilities (http://www.baanboard.com/baanboard/forumdisplay.php?f=33)
-   -   Load files directly into Infor ERP tables - Cookbook (http://www.baanboard.com/baanboard/showthread.php?t=63003)

litrax 19th October 2012 12:56

Load files directly into Infor ERP tables - Cookbook
 
1 Attachment(s)
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:
    http://www.orafaq.com/node/848

    For all the german speaking developers I recommend the following links:
    http://www.muniqsoft.de/tipps/oracle...r-tabellen.htm

    http://www.oracle.com/webfolder/tech...les/index.html

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!


All times are GMT +2. The time now is 04:49.


vB.Sponsors
©2001-2017 - Baanboard.com - Baanforums.com