Azure & D365 together: Serverless Integration with on prem ERP SAP System & Dynamics CRM in Microsoft Platform

While This could be one of most common scenario in live customer implementation of various Business Products, low code platform from Microsoft is already providing some components which makes overall integration effort so seem less and quick.

Following is example architecture where Server less component(Logic app) with On prem data gateway connector has solved a common business problem of customer and make to and fro read/update super easy in cost effective way.

Problem Statement:

Connecting to an prior on-prem environment of SAP System(eg. SAP ERP 6.0 Ehp6) in integrated implementation with Dynamics 365 CRM where some invoice update has to be contiguous to connected D365 CRM. handshaking required respective DLL's/certificate to authorize the read/updates.

Why any organization/Customer may have challenge to solve these?

All Connected systems are highly secure in hybrid environment of real customer scenario. multiple transaction occurring in various system need to be distributed and sync is required to be established. heavy coding/deployment/maintenance is required in respective coding languages. next transitioning developer need to have similar skill(.net/java) to make changes when required.

Advantages of introducing Server less  piece(Logic App) powered by Azure in the Architecture

• Quick development on Integrated workflow (Various write/update to connected SAP/D365 System)
• Dependency of any Certificate or underlying compatible binary is solved automatically.
• Hybrid business systems are connected with ease
• coding/development/deployment is solved with low code approach of logic app.

Technical Prerequisite

• Get a windows server @Customer Environment(right now on prem gateway is not supported on linux)
• Install On-premises data gateway on windows server - On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details
• Cover the SAP system connectivity prerequisites - https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-using-sap-connector#prerequisites

for more details on above Connect to SAP systems - Azure Logic Apps | Microsoft Docs

Pricing/Commercials

Estimate data volume/transaction in respective component of customer's business and take help of below link to calculate monthly estimate. for one time or job based data upload is also possible to optimize some transaction cost.

https://azure.microsoft.com/en-in/pricing/details/logic-apps/

Likewise, there are tons of possibilities to solve multiple business connector architecture with this quick approach or out of box supported connectors on platform.

looking forward to msg/comment for any architectural advise or optimization.