D365FO Integration with On Premise system (file & DB)

(0) Share

Report

Posted on by darmogil

Hi All,

I am Facing a real challenge with Integrating D365FO with an on premise system and couldn't find the best approach.

A. integration should work synchronously - or near real time.

B. Integration direction is from D365FO to On prem file system (creating a file) and to an on prem Access DB (CRUD Access Table records)

Examples:

when a production work order is started on D365FO - a text File with Production information should be created on the Customers On prem file system to be picked up by the production robots.

when a production work order RAF table records on a on Premise Access Table DB needs to be Updated/created. this DB is used by an Automatic WH system.

The only way i could think about is creating some kind of on Premise "integration scheduler" that will run every 10 sec and will get updated information (from new data entitys) for creating the production file or updating the access DB Tables.

i know that there are other several options for doing that (application proxy ? data gateway?) i could not find the best way or an example of how to implement it for my scenarios.

Thanks,

Gill

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Poojith Jain 50 on at

Like (1)

Report

Hi,

I would suggest the following

1. Create a business event (if it already doest exist) and use it as a trigger in the logic app

2. You can create an Azure OnPrem Gateway to connect to your OnPrem server

3. Use Azure function to create the file and Use Logic App to store the file to your onPrem server

Was this reply helpful? Yes No
darmogil on at

Like (0)

Report

Hi,

i am trying to do your example but unable to get the business event to trigger my logic app..

when debuging the event is triggered but nothing happens on the logic app...

Was this reply helpful? Yes No
Suggested answer

Pedro Tornich 955 on at

Like (0)

Report

You can create a web service (in any language) and host it in your On Prem server. Then you call it from D365FO whenever you need.

You can receive all the necessary information through parameters and create the file within your web service.

Here are some information about consuming third-party web services in D365FO.

If you create a SOAP web service you can go this way:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/consume-external-web-service

https://ariste.info/en/2019/07/consume-a-soap-web-service-in-dynamics-365-for-finance-and-operations-using-channelfactory/

If you prefer REST, you can go with this:

https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/154543/how-to-create-json-object-in-x-for-consuming-rest-api

https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/285802/serialize-x-objects-to-json/819110#819110

In any case, here are some examples on how to consume D365FO OData web services in different languages:

https://github.com/microsoft/Dynamics-AX-Integration/tree/master/ServiceSamples

Was this reply helpful? Yes No
Suggested answer

Khushhal Garg 1,514 on at

Like (0)

Report

One option for synchronous integration is to have SOAP/REST API created on customer on-premise. From D365 you can call this SOAP/REST API via Azure relay. Here is information on Azure relay - docs.microsoft.com/.../relay-what-is-it

Was this reply helpful? Yes No
darmogil on at

Like (0)

Report

Hi Poojith Jain,

That is exactly what we did and it works !

Thanks for your Help.

Gill

Was this reply helpful? Yes No