Using BIML with KingswaySoft SSIS Components

21 December 2018
Mohamed Abdalkarim

BIML can be used to automate the generation of multiple SSIS packages. In this blog post we will show you how you can utilize BIML when working with SSIS Integration Toolkit or SSIS Productivity Pack components.

Using SSIS to Mask Data to Assist with GDPR Compliance

27 June 2018
Jessica Petta

SSIS can be a useful tool in assisting with GDPR compliance. In this blog post we will demonstrate how to use SSIS to mask information in an environment so that the data structure remains intact but no sensitive information is stored on the environment.

How to Work with RESTful Endpoints in your SSIS ETL Process

27 February 2018
Jeremy Ji

Connecting to an integrating with a REST API in SSIS can be a tricky process. In this blog post we will walk you through how our SSIS Productivity Pack can be used to simplify the development process. We will be working with ZenDesk as an example to demonstrate integration with a REST API feeding data in JSON format.

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.

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.

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.

Dance with CRM Statuses In ETL Project

31 March 2017
Daniel Cai

Microsoft Dynamics 365/CRM entities often have some special statuses that would prohibit update of the entity record when there are any other fields involved but the record itself is in a certain status. One of such entities is the CRM case entity which has a physical name of incident in the system. If a case is resolved, you can't make any further updates to the record, otherwise you will receive an error indicating the case has been resolved, it needs to be reopened in order to make changes. This applies to other entities that might have similar restrictions, and it imposes a challenges to data integration (or ETL) development. In this blog post, I will show you how to work around this situation.

comments powered by Disqus