Options for API / Batch integration with Infor LN ERP

skgala · #1 13th January 2019, 23:24

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

mark_h · #2 14th January 2019, 18:11

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.

vinceco252 · #3 14th January 2019, 18:55

The recommended interface for most transactional imports into LN is ION.

Thanks,

Vince