Generating complex text files from Dynamics 365 with KingswaySoft and XSLT

Recently I needed to build an SSIS package that would generate a delimited text file with multiple sets of related (but different entity) Dynamics 365 records combined in a single grouping. Each record would be on a separate row (with different formats for each record type), and each grouping of »

Real-time Dynamics 365 data integrations with SSIS + KingswaySoft

I'm a big fan of KingswaySoft's Dynamics 365 SSIS integration toolkit for moving data between Dynamics 365 and other systems. Because the integrations are run in SSIS packages, there's a lot of power and flexibility, and you can use SQL Server Agent to orchestrate your integration jobs. This is great »

Updated version of Dynamics 365/CRM Deployment Wizard

I've released an updated version of my Dynamics CRM Deployment Wizard that supports Dynamics 365. The Deployment Wizard is designed to automate your solution deployments much like the SDK's Dynamics CRM Package Deployer, but while the SDK tool requires you to build a deployment package using Visual Studio, my Deployment »

Dynamics 365 Configuration Data Mover v2.1

I've released an updated version of my popular CRM Configuration Data Mover utility that includes the following features: Steps can now be set as create-only, update-only or create+update. You can browse to data files using a standard file open dialog window. This upgrade is fully compatible with existing job »

Dynamics 365 Configuration Data Mover v2.0.1.2

I've released an updated version of my popular CRM Configuration Data Mover utility that fixes a small annoyance in the previous version where you could open multiple instances of the set connection, about and check for upgrade windows. This upgrade is fully compatible with existing job files. Getting the Dynamics »

Working with Dynamics 365 lookup data in PowerApps

One of the main problems I have with PowerApps at present is that it doesn't nicely support Dynamics 365 lookup fields out of the box. Today I will show how I've worked around its limitations to make Dynamics 365 lookup fields easily viewable and editable in PowerApps. For today's demonstration, »

Dynamics 365 and Python integration using the Web API - part 2

Last week I wrote a post that showed how to update Dynamics 365 data from a Node.js application using the Web API. Today I will share equivalent Python code. This code builds on my Dynamics 365 and Python integration using the Web API post from last year, so if »

Dynamics 365 and Node.js integration using the Web API - part 2

Last year I wrote a post that showed how to retrieve data from a Dynamics 365 Online organization in a Node.js application using the Web API. Today I will share sample code that shows how to update data from a Node.js application using the Web API. Updating a »