Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Code & Utilities

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 19th October 2012, 13:56
litrax's Avatar
litrax litrax is offline
Member
 
Join Date: Sep 2005
Location: Germany
Posts: 95
litrax is on a distinguished road
Baan: ERP LN (FP8) - DB: Oracle10g (10.2.0.1.0) - OS: Solaris
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:
    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!
Attached Files
File Type: sql external_table_install.sql (7.6 KB, 94 views)
__________________
Have a lot of fun...

Please look at this before asking wholes in the stomach ;-)
http://www.baanboard.com/programmers_manual_baanerp

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


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 08:41.


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