D365 Integration

Dynamics 365 is Microsoft’s enterprise resource planning and order management solution. Dynamics 365 can run in the cloud or on-premise. For on-premise documentation, consult the following: Microsoft Dynamics Finance / Supply Chain Management / Microsoft Dynamics 365 Business Central. With cloud instances, eFORMz typically makes API calls to D365 and populates a local SQL Server database with results which are subsequently called by eFORMz project(s). Of the various integration methods eFORMz uses, this process would be a combination of web service calls and relational database queries:

Web Service Calls

Web service calls let you send or receive data from web applications with industry standard POST and GET methods. Connect to remote systems over http or https protocols to get data from remote servers. There’s no need to write new code or configure a database connection. The web service provider determines the URL syntax, including key value pairs (KVPs) to send.

Relational Database Queries

Business-critical data is often located on a relational database server. eFORMz can submit SQL queries, call stored procedures or user-defined functions, and even do SQL updates and inserts. Data retrieved from the database server can be placed onto your form or label or used with an eFORMz rule to customize content.

Tags: MS Dynamics