Using xMultiple along with User Multiplexing for improved performance – KingswaySoft SSIS Integration Toolkit (Dataverse / Dynamics 365)
Let us continue our previous post, where we observed performance improvements by using User Multiplexing Now let us try making use of the xMultiple feature (CreateMultiple, UpdateMultiple, and CreateMultiple messages) of the CRM / CDS Destination Component. We have updated the Batch Size to 100 to trigger the xMultiple However this time we got the…
How to use – User Multiplexing to get better performance for Data Migration /Integration using KingswaySoft Integration Toolkit for Dynamics 365 (Dataverse / SSIS)
Let us see how we can make use of User Multiplexing to get better performance. Below is our SSIS Package, which uses Data Spawner to create sample records, 20 K in this case, and CDS Destination to create those records (contact). Data Spawner is used to create the 20000 contact record. The CRM Connection is…
How to –Upload files to File Column / Attribute in SSIS from Azure Blog Storage – KingswaySoft (Dynamics 365 / CRM)
Below are a few ways we can upload files to the File Column type field using KingswaySoft’ s Integration Toolkit and Premium Flat File Source and Premium Derived column which are part of the SSIS Productivity Pack of KingswaySoft https://nishantrana.me/2022/03/17/how-to-upload-files-from-file-column-attribute-using-ssis-kingswaysoft-dynamics-365-crm/ Using the Import column – https://nishantrana.me/2022/08/10/how-to-upload-files-to-file-column-attribute-using-ssis-kingswaysoft-and-import-column-dynamics-365-crm/ Using the Script Component – https://nishantrana.me/2022/08/09/how-to-use-script-component-to-upload-files-to-file-column-attribute-in-ssis-kingswaysoft-dynamics-365-crm/ Here instead of…
How to – Use Import Column to Upload files to File Column / Attribute in SSIS KingswaySoft(Dynamics 365 / CRM)
A few weeks back had posted on how to upload files to the File Column type field using KingswaySoft’ s Integration Toolkit and Premium Flat File Source and Premium Derived column which are part of the SSIS Productivity Pack of KingswaySoft https://nishantrana.me/2022/03/17/how-to-upload-files-from-file-column-attribute-using-ssis-kingswaysoft-dynamics-365-crm/ Here we will see an example of achieving the same without using the…
How to – Use Script Component to Upload files to File Column / Attribute in SSIS – KingswaySoft (Dynamics 365 / CRM)
A few weeks back had posted on how to upload files to the File Column type field using KingswaySoft’ s Integration Toolkit and Premium Flat File Source and Premium Derived column which are part of the SSIS Productivity Pack of KingswaySoft https://nishantrana.me/2022/03/17/how-to-upload-files-from-file-column-attribute-using-ssis-kingswaysoft-dynamics-365-crm/ Here we will see an example of achieving the same without using the…
How to – Upload files to File Column / Attribute using SSIS – KingswaySoft (Dynamics 365/ CRM)
Let us take a simple example to understand how we can upload files to the file column through SSIS Package + KingswaySoft’s Integration Toolkit. Here we have a File Column defined for the Contact Entity. This is what our final package looks like – Our SSIS package will pick up the contact’s email, file path,…
How to – Download files from File Column / Attribute using SSIS – KingswaySoft (Dynamics 365/ CRM)
Let us take a simple example to understand how we can download files from the file column using SSIS Package + KingswaySoft’s Integration Toolkit. Here we have a File Column defined for Contact Entity. Our SSIS package will run on all the contact records and will extract the file from the records to one of…
Use ExecuteWorkflowAction to call Action and Workflow in CDS Destination KingswaySoft – Dynamics 365 / Dataverse
We can use ExecuteWorkflowAction in the CDS/CRM Destination Component of KingswaySoft’s SSIS Integration Toolkit for Dynamics 365 to execute workflow and custom action. If there is no Destination Entity defined (left blank), Workflow/Action options will list down all the global action available On selecting a specific entity/table e.g. lead entity, it is listing down the…
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…
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…
Loading…
Something went wrong. Please refresh the page and/or try again.
Related
Author: Nishant Rana
I love working in and sharing everything about Microsoft.NET technology ! View all posts by Nishant Rana
12 thoughts on “SSIS (KingswaySoft) and Dynamics 365”