Dynamics 365 availability monitoring with App Insights

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

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

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