A common request from cloud & infra operations teams is a centralized place to monitor the environments availability. Lifecycle Services portal already provide a fair amount of metrics... but it's not that straight forward to get what we want and it's a different portal. It's not possible to integrate with Log Analytics and Azure Monitor … Continue reading Dynamics 365 availability monitoring with App Insights
Author: Fabio Filardi
Dynamics 365 FinOps: OData load testing
We all know... it's rarely a good idea to allow direct calls from the front-end system (e.g. an e-commerce website) to the back-end (ERP). But in some situations we have to expose the OData endpoints for either internal or external consumers. Like when you integrate the ERP with a warehouse management system, where the communication … Continue reading Dynamics 365 FinOps: OData load testing
Dynamics 365 FinOps: Batch import automation with Azure Functions, Business Events and PowerBI
Design automation for real-time/synchronous interfaces in Dynamics 365 for Finance has its challenges but it’s quite often less complex than do the same for batch/asynchronous interfaces, for a couple reasons. On batch interfaces we need to manipulate files across servers, be aware of network traffic, quotas, operation timeouts, storage limits and costs, and so on. … Continue reading Dynamics 365 FinOps: Batch import automation with Azure Functions, Business Events and PowerBI
Exporting DMF files using JSON
One common question from people working with Data Management Framework in Dynamics 365 for Finance is about the possibility to use other file formats - more specifically JSON - rather than the standard ones (XML, CSV, Excel). The answer is yes, it's possible using a XSLT (eXtensible Stylesheet Language Transformations) file in your export project. … Continue reading Exporting DMF files using JSON
Azure Functions: event-driven integration with Dynamics 365 for Finance and Operations
Business events for Dynamics 365 Finance comes with a couple of out-of-the-box endpoints that enables a seamless integration with most Azure tools available for event-based integration scenarios: Event Grid, Event Hub, Service Bus Queue and Topics, Power Automate and Blob Storage. For anything else not listed, like any web API or web application hosted on-premises … Continue reading Azure Functions: event-driven integration with Dynamics 365 for Finance and Operations
Exporting extended data entity metadata for FinOps
One of the most time consuming - and critical - exercise for data migration and integration is data mapping between source and target systems. Extract the schema details from the legacy systems and map to a xCBL or directly to other systems is always a challenge for many reasons - old technologies, database highly normalized, … Continue reading Exporting extended data entity metadata for FinOps
Business Events for Dynamics 365 for Finance and Operations
Microsoft has finally introduced a new and long waited feature for Dynamics 365 For Finance and Operations – the Business Events. In a nutshell, it’s a mechanism to create trigger points and send event notifications to external systems. Any business process, from posting an invoice to inserting a record in the database, can be set … Continue reading Business Events for Dynamics 365 for Finance and Operations
Part 4: Using PowerBI for real-time data analysis
The last and perhaps the most important part of a data analyses is to built a good visualization on the output, transforming the data acquired, cleansed and processed into rich reports, bringing valueable information for the business. Decision can be more precise, accurate and less risk if we have the right data in the right … Continue reading Part 4: Using PowerBI for real-time data analysis
Part 3: Using Machine Learning to calculate chance of precipitation and saving the output
Stream Analytics is used to examine high volumes of data streaming from devices or processes, extract information from that data stream, identify patterns, trends, and relationships. Those patterns can trigger other processes or actions, like alerts, automation workflows, feed information to a reporting tool, or store it for later investigation (check Stream Analytics Introduction article for more … Continue reading Part 3: Using Machine Learning to calculate chance of precipitation and saving the output
Part 2: Creating an alert using Service Bus and Logic Apps
IoT Hub offers device-to-cloud message routing to specific services endpoints, based on rules created using message properties values as filters without requiring any additional code. If a single message matches the condition of multiple rules, it will be delivered to each endpoint associated with the routes. However, there's a protection against duplicated messages - if … Continue reading Part 2: Creating an alert using Service Bus and Logic Apps