How to Cope with the new Dynamics 365 API Limits

27 February 2018
Daniel Cai

There was a sudden announcement from Microsoft Dynamics 365 Customer Engagement team about an upcoming API Limits. This blog post discusses the strategies and options for you if you rely on some heavy integration in your organization.


Export data from SQL Server to Excel using SSIS

22 February 2018
Jessica Petta

In this blog post we will cover how you can take advantage of the SSIS Productivity Pack to easily export data from SQL Server to Excel using SSIS.

 SSIS 

Incremental Load in SSIS with Diff Detector

29 January 2018
Jessica Petta

Easily develop incremental load in SSIS within one data flow by utilizing SSIS Productivity Pack. In this blog post we will cover how you can use Diff Detector and Premium ADO.NET Source & Destination to quickly create performant incremental loads in SSIS.


Incremental Load in SSIS Made Easy

25 January 2018
Jessica Petta

In this blog post we will cover how you can use SSIS Productivity Pack to quickly develop SSIS incremental load packages within one data flow without needing to perform any lookups.


Integration between Magento and Microsoft Dynamics 365/NAV

05 December 2017
Jeremy Ji

In this blog post we will discuss how you can integrate your commerce platform (Magento) with your ERP (Microsoft Dynamics 365/NAV) to provide seamless data transfers between the two systems.


How to Retrieve Incremental Changes from CRM in your ETL Process

04 April 2017
Jeremy Ji

In this blog post we discuss how you can take advantage of CRM Change Tracking within your data synchronization project to only sync records that have changed.


Access CRM Fields in an Efficient Way

31 March 2017
Daniel Cai

As a professional Dynamics 365/CRM developer, you want your code to be as efficient as possible. I have often run into a code structure that first checks the existence of a particular field value in CRM entity property bag, and then trying to access the value using a dictionary lookup. This is very inefficient. In this blog post, I will show you why and how you can address the situation.


Migrate CRM close or resolution entity records in your ETL process

31 March 2017
Daniel Cai

Microsoft Dynamics 365/CRM uses some close entities to capture the reason why the primary record was closed with some additional information. In this blog post I discuss how to migrate CRM close or resolution entities in your ETL process properly to avoid creating duplicates for those entities in your target system.

comments powered by Disqus