Migrating Dynamics CDS/CRM Quote with Revisions in SSIS

16 September 2020
Chen Huang

In a prior blog post, we explained how to migrate quotes from one Dynamics CRM system to another however it only focused on the most recent quote. In this post, we expand on that migration and show you how to use our software to migrate Dynamics CDS/CRM quotes with revisions in SSIS.


Extracting Key/Value Pairs JSON Structure into Tabular Format

02 September 2020
Mohamed Abdalkarim

When working with JSON data, a scenario may arise where there could be a format of a JSON Document that makes it challenging to extract the data into a typical tabular form. This blog post will explore using the "Key Value Pivot" Output type found in our JSON Source/Extract Components to parse Key/Value pairs from JSON documents with ease.


Using Premium Hash for Efficient and Easy Change Tracking in SSIS

28 August 2020
Chen Huang

It is always crucial for an ETL process to have a change tracking mechanism to identify when a change has happened to any set of data and only process data that has changed. Let's show you how to implement change tracking with our Premium Hash component.


Salesforce Attachments Integration with Microsoft Team Foundation Server

17 August 2020
Mohamed Abdalkarim

Extracting and integrating attachments from Salesforce or Azure DevOps (formally Team Foundation Server) can be useful when moving attachments to different cloud storage or syncing the attachments between different systems. In this blog post, we detail how to extract attachments from both systems as well as write attachments to them.


Performing BulkDelete Action in Microsoft Dynamics 365 CRM

14 July 2020
Aswin Manmadhan

Learn how to quickly delete numerous records in Microsoft Dynamics 365 CRM at once with BulkDelete action.


Manipulate CRM ActivityParty Field Values

12 May 2020
Mohamed Abdalkarim

Manipulating input data can be challenging when working with the JSON format of CRM's ActivityParty fields. Let us take you through the process.


Joining Parent and Child Records Efficiently

14 April 2020
Aswin Manmadhan

Dealing with more than one output from a Source component? Most likely your endpoint has parent and child records. Let's show you how to join these records efficiently.


Setting KingswaySoft Component Properties Dynamically

14 January 2020
Aswin Manmadhan

Parameterizing a component has many advantages over hardcoding the value. In this blog, we will see how parametrization can be done easily in KingswaySoft components.

 REST   SSIS 
comments powered by Disqus