D365 Finance and Operations integration using BYOD

This blog explains the integration option to export data entities from Dynamics 365 F&O into a Microsoft Azure SQL database. D365FO provides a feature via Data Management Frame called bring your own database (BYOD). The BYOD feature lets D365 administrators export one or more data entities that are available in D365FO into an Azure SQLContinue reading “D365 Finance and Operations integration using BYOD”

Azure Integration: Azure Service Bus and Logic App integration Pattern using PeekLock

This blog entry describes the best practice for reading a message from Azure Service Bus in Logic App using Peek Lock Mechanism Azure Integration: Azure Service Bus The central capability of a message broker such as Service Bus is to accept messages into a queue or topic and hold them available for later retrieval. When theContinue reading “Azure Integration: Azure Service Bus and Logic App integration Pattern using PeekLock”

Azure Integration: Generate a Flat file with ANSI encoding using Logic App

Handling non UTF8 encoding in Logic App Recently there was a requirement to generate a flat file in Azure Logic App and deliver to Azure File Share with ANSI encoding as targeting application could only process ANSI encoding file. Much of cloud services assume that a text payload will be some form of UTF (Unicode)Continue reading “Azure Integration: Generate a Flat file with ANSI encoding using Logic App”

Azure Integration: Dynamics 365 UO DMF Data Export using Logic Apps

This Blog describes the method of implementing Dynamics 365 UO’s Data Management Framework Recurring Integration Module using the Logic App. The blog provides a technical implementation of queuing and dequeuing of the Jobs using REST API of Dynamics 365 UO’s Recurring Integration Module. Dynamics 365 for Operation provides two primary sets of APIs, Recurring IntegrationContinue reading “Azure Integration: Dynamics 365 UO DMF Data Export using Logic Apps”

Dynamics 365 UO Integration Design Patterns

Dynamics 365 for Unified Operations has evolved into purpose-built applications to help you manage business functions. This would mean that there would be integration with diverse systems. The blog describes integration patterns, integration scenarios, and best practices. There is a number of ways users can interact with the D365 UO. There are different ways toContinue reading “Dynamics 365 UO Integration Design Patterns”

Azure Integration: Setting null value in Logic App Action to Dynamics 365

In one of my azure integration involving Dynamics 365, I had to send a null value when a field value is empty. The Dynamics 365 Actions for Update or Create a Record Action in the Logic App was always sending empty string (i.e. “”) instead of null value, which resulted in the integration failure. TheContinue reading “Azure Integration: Setting null value in Logic App Action to Dynamics 365”

Dynamics 365 UO: Integration using oData/REST API

This blog describes the method to interact with the Dynamics 365 Unified Operation using oData. Dynamics 365 UO provides REST API to interact with Data via Data Entities. oData: Open Data Protocol (OData) is a standard protocol for consuming data exposed by Dynamics 365 for Operations. OData is a new Representational State Transfer (REST) basedContinue reading “Dynamics 365 UO: Integration using oData/REST API”

Azure Integration: Tracking, Exception Handling and Monitoring of Azure Logic App

There are times the Azure integration components such as Logic Apps, function Apps, fail due to technical errors, functional errors or data errors. There should be a mechanism to monitor and pro-actively inform the technical owners or functional owners about these errors, to have a successful and reliable integration. This blog provides a mechanism forContinue reading “Azure Integration: Tracking, Exception Handling and Monitoring of Azure Logic App”

Dynamics 365 FO Integration using Business Events

This blog describes a method to use Azure Integration with Dynamics 365 FO Business Events. The Dynamics 365 FO Business Events can send events/trigger/notification to external applications such as Azure Integrations, which can use this trigger to handle specific integration or business process scenarios. The Events existed in Finance and Operations were previously confined toContinue reading “Dynamics 365 FO Integration using Business Events”