Azure Integration
Dynamics 365 UO: Set financial dimension using oData integration
Use case: I had to set financial dimension values for Purchase Order Lines using oData while inserting data into D365 Unified Operations. To set the financial dimensions, we need to set the value for the field “DefaultLedgerDimensionDisplayValue“. When I tried to set the value, I got the following error. Write failed for table row ofContinue reading “Dynamics 365 UO: Set financial dimension using oData integration”
Azure Integration using Managed Identity
This blog describes managed identities and different types of managed identities. Managed Identities are in essence similar to Service Principals and they are actually Service Principals. The biggest difference between both is that Azure Managed identities manage the initial creation of the service principal and automatic renewal of the service principal without any additional workloadContinue reading “Azure Integration using Managed Identity”
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: 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”
D365UO https vs finance connectors
HTTPS vs D365UOconnectors for integration with D365UO Microsoft Dynamics 365 for Unified Operation provides project-driven organizations with the tools they need to connect and manage their clients, finances, projects, and people in a unified, integrated environment. D365UO helps services organizations streamline key finance and project-related business processes, simplify the management of their human capital, andContinue reading “D365UO https vs finance connectors”
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 UO: Recurring Integration to avoid DMF parallel execution issue
This blog entry provides the implementation deatils for recurring integrations
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”
Azure Integration Release Management best practices
This blog describe the best practises and guidelines for using Azure DevOps for Azure Integration development and release management. Introduction This blog describe the best practises and guidelines for using Azure DevOps for Azure Integration development and release management. Figure 1: High Level view of AIS Release management Azure DevOps / Release management Branches ForContinue reading “Azure Integration Release Management best practices”
Azure Integration: ARM visualiser on Azure portal
Azure Resource Manager visualization is part of Azure Portal now. It provides a visual way of visualizing Azure Resource Manager Templates. It helps to understand the components in the ARM template, how they interact and components used in the template. It provides a way to understand the components in a resource group. Azure Integration: ARMContinue reading “Azure Integration: ARM visualiser on Azure portal”
Azure: Enumerating all the Logic App runs history using PowerShell and REST API
What Are Logic Apps? Logic Apps are a piece of integration workflow hosted on Azure which is used to create scale-able integrations between various systems. These are very easy to design and provide connectivity between various disparate systems using many out of the box connectors as well as with the facility to design custom connectorsContinue reading “Azure: Enumerating all the Logic App runs history using PowerShell and REST API”
D365FO: Interacting with Data Management framework using REST API
This blog describes the method to interact with the Data Management framework using REST API to export the delta changes of an entity. The package API lets third party applications to integrate by using data packages. Use case scenario: The vendor changes are tracked using the “Change Tracker” functionality available on D365FO at Entity Level.Continue reading “D365FO: Interacting with Data Management framework using REST API”
Dynamics 365 UO: Data Task automation
Dynamics 365 UO Data task automation is a framework which helps with following features Demo Data Setup Golden Configuration Setup Data Migration Validation Data Entities and Integration Test automation D365 UO: Intrduction to Data Task Automation Data packages from the Shared Asset Library or Project Asset Library can be downloaded and imported automatically into D365FOContinue reading “Dynamics 365 UO: Data Task automation”
Azure Integration: Installing and configuring On-premises data gateway
The on-premises data gateway provides quick and secure data transfer between on-premises data sources and Azure components. It acts as a bridge between onPremise and Azure Cloud. Currently, the gateway supports connections to the following data sources hosted on-premises: Azure Logic Apps Power BI Power Apps Power Automate Azure Analysis Services Azure Integration: Install AzureContinue reading “Azure Integration: Installing and configuring On-premises data gateway”