Baanboard.com

Go Back   Baanboard.com > Forum > General Topics > General Discussion & Chat

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
6%
1200 - 1500 GB
8%
1500 - 2000 GB
12%
> 2000 GB
23%
Total votes: 65

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 13th January 2019, 22:24
skgala skgala is offline
Newbie
 
Join Date: Jan 2019
Posts: 1
skgala is on a distinguished road
Baan: 10 - DB: Oracle - OS: Unix
Post Options for API / Batch integration with Infor LN ERP

Hi,

I am newbie here. We have client requirement to integrate their CRM system with Infor LN system. We have done integration with other ERP systems like SAP using APIs ( SOAP API calls and RFC calls). We have never done integration with Infor LN system. I have 2 needs. Any expert guidance is appreciated.

Need 1:
Export data from Infor and load in our cloud AWS database.

On periodic basis (e.g. nightly) we would like to export data from Infor database and load in our database. If we can get Infor system to FTP CSV files to our server on periodic basis, we can import that in our database. We need master and transactional data.

Need 2:
Real-time API call to perform Business action in Infor LN

For example, if customer address needs to be updated, we would like to all API and update address in Infor LN. For that I am not sure if Infor LN has published API list. If yes, that would make life easy. If not, what is the best way to perform such action.

Thanks
Shailesh
Reply With Quote
  #2  
Old 14th January 2019, 17:11
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,248
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
How would I do it:

(1) Write a session to extract what I needed into files. Then just put it in a batch job and add the necessary ftp commands. Now if there is a shared directory with the AWS system then no FTP(or secure ftp needed).

(2) Real time calls - you could always write libraries to perform certain functions using AFS code. The key with this is what you can write the code to call it in. I know there is a what to call these type libraries from Excel, but I am not sure of all the options available to LN. So wait for an LN export that can provide much better options.

Just my opinion and sure there are better ways with the newer software.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
  #3  
Old 14th January 2019, 17:55
vinceco252's Avatar
vinceco252 vinceco252 is offline
Guru
 
Join Date: Mar 2002
Location: Frederick, CO
Posts: 422
vinceco252 is on a distinguished road
Baan: Baan IVc3, IVc4, 5b, 5c, ERP LN 6.1, Infor ERP 10.x - DB: SQL Server, Oracle - OS: Windows, Linux, HPUX, AIX, (a little bit of) Solaris
The recommended interface for most transactional imports into LN is ION.

Thanks,

Vince
__________________
Vincent Murphy
---------------
ERP Practice Manager / Senior Consultant
OST
vmurphy@ostusa.com
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 On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Manager - ERP Infor Ln (Logistics Consultant) HYVA India Jobs and Resumes 2 12th July 2013 13:49
ERP LN 6.1 Infor Integration (Open World) Specialist jarledge Jobs and Resumes 0 25th August 2011 18:42
Интеграция ERP LN и 1C (ERP LN - 1S integration) vkpacc Russia 1 2nd August 2010 13:30
SSA Integration Pack for ERP LN – Microsoft Office KirAlex Open World, Portal & Decision Manager 4 16th April 2007 13:35
SSA ERP-NL / Baan V6 is it Vaporware ? tjbyfield General Discussion & Chat 18 1st October 2004 10:50


All times are GMT +2. The time now is 23:40.


©2001-2018 - Baanboard.com - Baanforums.com