SSIS (KingswaySoft) and Dynamics 365


Azure Data Lake Storage Component in KingswaySoft – SSIS

Download and install the SSIS Productivity Pack https://www.kingswaysoft.com/products/ssis-productivity-pack/download/ Drag the Azure Data Lake Storage Source component in the data flow Double click and click on New to specify the connection Provide the connection details and test the connection It supports both Gen 1 and Gen 2 Supports the below Authentication modes Inside the Azure Data … Continue reading “Azure Data Lake Storage Component in KingswaySoft – SSIS”

Transfer files from local drive to Azure Blob using Azure Blob Upload Task – SSIS

Similar to Premium File Transfer Task, The Azure Blob Upload Task component can be used to easily transfer files from local drive to Azure Blob storage. https://docs.microsoft.com/en-us/sql/integration-services/control-flow/azure-blob-upload-task Let us take a simple example to see it in action. Here we will pick the folder Customer and its subfolders along with the files inside it and … Continue reading “Transfer files from local drive to Azure Blob using Azure Blob Upload Task – SSIS”

Transfer files from local drive to Azure Blob using Premium File Transfer Task – SSIS

The Premium File Transfer Task component of KingswaySoft can be used to easily transfer files from local drive to Azure Blob storage. https://www.kingswaysoft.com/products/ssis-productivity-pack/help-manual/premium-file-pack/premium-file-transfer-task Let us take a simple example to see it in action. Here we will pick the folder Customers and its subfolders along with the files inside it and will transfer it’s content … Continue reading “Transfer files from local drive to Azure Blob using Premium File Transfer Task – SSIS”

Process Optimization – Dynamics 365 CE / CRM / CDS SSIS Integration toolkit – KingswaySoft

Process Optimizations is a new feature added in the CDS / CRM Destination Component of KingswaySoft’s SSIS Integration Toolkit as part of November 2020 Release. Check other posts on SSIS and Dynamics 365 https://nishantrana.me/2020/10/16/ssis-kingswaysoft-and-dynamics-365/ These options if enabled, will turn off or disable plugin, workflow, entity auditing during pre-execution temporarily, during the writing process, and … Continue reading “Process Optimization – Dynamics 365 CE / CRM / CDS SSIS Integration toolkit – KingswaySoft”

Changes in CDS / CRM Destination Component – SSIS Integration Toolkit for Dynamics 365

With version 20.2 November 2020 release, there have few updates added to the KingwaySoft’s CDS/CRM Destination Component, few are changes in the label and others are metadata changes, that one should be aware of before updating. Check Post on SSIS and Dynamics 365 https://nishantrana.me/2020/10/16/ssis-kingswaysoft-and-dynamics-365/ Label changes. Version 20.1 – Version 20.2 – CrmRecordId renamed to … Continue reading “Changes in CDS / CRM Destination Component – SSIS Integration Toolkit for Dynamics 365”

Extract attachment from Notes in Dynamics 365 / CE / CDS – SSIS (KingswaySoft)

Recently we were exploring ways of extracting attachment from notes to a local drive for our case entity. We also wanted to organize it based on Case Number. For this, we used KingswaySoft’s SSIS components. Other posts on SSIS and Dynamics 365 – https://nishantrana.me/2018/11/26/ssis-and-microsoft-dynamics-365/ This is how our final package looked like For CDS Source, … Continue reading “Extract attachment from Notes in Dynamics 365 / CE / CDS – SSIS (KingswaySoft)”

Replicate / Export Dynamics 365 (CDS) data – different options

The most common use case to export Dynamics 365 or Common Data Service data to an external database/datastore is to have more control over the data (without going through API route) with the ability to run analytics such as Power BI Reporting, Machine Learning, Data Warehousing, Integration, etc. For analytics, we can also use our … Continue reading “Replicate / Export Dynamics 365 (CDS) data – different options”

Using KingswaySoft Azure Blob Storage component with Dynamics 365

KingswaySoft provides 3 components specific to Azure Blog Storage Azure Blob Connection Manager Azure Blob Storage Source Azure Blob Storage Destination Check other blog posts on SSIS https://nishantrana.me/2020/10/16/ssis-kingswaysoft-and-dynamics-365/ Let us take a simple example where we are extracting \ reading contact data from Dynamics 365 \ CDS and saving it as a text file in … Continue reading “Using KingswaySoft Azure Blob Storage component with Dynamics 365”

Connect to Dynamics 365 through Script Component – SSIS

For complex data migration requirements, usually we’d be using 3rd party tools like KingswaySoft or Scribe, or Informatica as they already have components (connection, transformation, source, destination etc.) built for Dynamics 365 instead of building our own. Check other posts on data migration https://nishantrana.me/2020/10/16/ssis-kingswaysoft-and-dynamics-365/ https://nishantrana.me/2020/05/19/data-migration-in-dynamics-365-key-considerations/ For some simple / basic requirements instead of using 3rd … Continue reading “Connect to Dynamics 365 through Script Component – SSIS”

Loading…

Something went wrong. Please refresh the page and/or try again.

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

11 thoughts on “SSIS (KingswaySoft) and Dynamics 365”

Please share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.