SSIS (KingswaySoft) and Dynamics 365


Interactive login option in CDS/CRM Connection Manager in KingswaySoft Dynamics 365 Integration Toolkit

With the new release, the CDS/CRM connection manager adds a new Interactive Login option in the CDS/CRM Connection Manager for Authentication Type as OAuth. Interactive login allows the user to log in using his account details (to establish the connection with CRM) without the need for registering the application in the Azure Active Directory. This … Continue reading “Interactive login option in CDS/CRM Connection Manager in KingswaySoft Dynamics 365 Integration Toolkit”

How to – improve data migration performance – SSIS & Azure Data Factory (Dataverse / Dynamics 365)

In one of our projects, we were executing SSIS Packages (KingswaySoft’s Dynamics 365 SSIS Integration Toolkit) under Azure-SSIS Integration Runtime in Azure Data Factory. Check out – Deploy and run SSIS Package in Azure Data Factory Deploy and run SSIS Packages that use KingswaySoft’s SSIS Integration Toolkit on Azure Data Factory. After trying out different … Continue reading “How to – improve data migration performance – SSIS & Azure Data Factory (Dataverse / Dynamics 365)”

Data Migration – Optimum batch size and threads for maximum throughput – Microsoft Dataverse (Dynamics 365)

For one of our projects, we were trying to figure out the optimum batch size and threads while using the CDS/CRM Destination component of KingswaySoft. https://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-365/help-manual/crm/destination Now with Service Protection API limits in place, to get the maximum throughput the first point to consider is User Multiplexing. Nicely explained here à https://powerplatform.se/fast-data-management-in-a-limited-cds-world/ We are using … Continue reading “Data Migration – Optimum batch size and threads for maximum throughput – Microsoft Dataverse (Dynamics 365)”

Retrieving security role privileges changes (audit) using KingswaySoft’s Dynamics 365 SSIS Integration Toolkit

We can specify Source Type as AuditLogs within the CDS Source Component Editor of KingswaySoft to fetch the Audit information. Get the details :- https://nishantrana.me/2018/10/08/using-kingswaysofts-cds-crm-source-component-to-get-audit-information-in-dynamics-365-ce-ssis/ The Souce Type – AuditLogs includes Output type – Audit Details (Role Privileges), which can be used to fetch any audit information related to security roles. Audit Details (Role Privileges) … Continue reading “Retrieving security role privileges changes (audit) using KingswaySoft’s Dynamics 365 SSIS Integration Toolkit”

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”

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.