Migrating Dynamics CDS/CRM Quote with Revisions in SSIS
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.
Real-Time Salesforce Integration with Virtually Any Application or Database System
Real-time data integration is now essential for immediate decision making by businesses across the world. With modern-cloud based services such as Salesforce and our Integration Gateway solution, integrate your Salesforce data with any application or database system in real-time.
Extracting Key/Value Pairs JSON Structure into Tabular Format
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
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
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
Learn how to quickly delete numerous records in Microsoft Dynamics 365 CRM at once with the BulkDelete action.
Uninstallation Done Properly for KingswaySoft Toolkits
There are cases that you might have to uninstall our software due to different reasons. Let's show you how this should be done properly.
Real-Time Integration: HubSpot to Dynamics CE/CRM
KingswaySoft Integration Gateway allows developers to set up webhook listeners to receive messages from modern cloud applications, and publish them to one or more message queues or file system. We'll show you how you can take it a step further by integrating HubSpot with Dynamics 365 CE/CRM in real-time.
Manipulate CRM ActivityParty Field Values
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
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.
Working with Dynamics 365 Business Central/NAV Codeunit in SSIS
Explore working with Dynamics BC/NAV Codeunit web service by using HTTP Connection Manager and Web Service components offered in our SSIS Productivity Pack.
Using KingswaySoft Components for Error Handling and Logging
When designing an integration package, you'd expect to run into errors that may break the execution of one of the tasks or even the entire package. In this blog post, we explore the different approaches of handling and logging error messages while sending notifications for either a record-level or a package-level failure.
Setting KingswaySoft Component Properties Dynamically
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.
Using OAuth 2.0 Authorization with a Certificate in SSIS
We explore the JWT assertion OAuth2 authentication process with a certificate and demonstrate the process of working with an OAuth2 authentication workflow in SSIS
Parameterizing CDS/CRM Connection Manager
Parametrize your CDS/CRM Connection Manager to execute the same SSIS package deployed to your SSISDB catalogue to integrate different CDS/CRM instances. Learn how.
Extracting Audit Logs for Multiple CRM Entities
KingswaySoft SSIS Integration Toolkit for Dynamics 365 offers a robust and easy way to retrieve and read audit logs. Learn how to extract these audit logs.
KingswaySoft returns to the Microsoft Business Applications Summit this June
Jumpstart your digital transformation. Join KingswaySoft at the Microsoft Business Applications Summit this summer from June 10 - 11 2019!
Working with Dynamics 365 WebAPI in your ETL Process
WebAPI is the latest web service interface for the CDS and Microsoft Dynamics 365 Customer Engagement platform. Working with WebAPI comes with a number of benefits. This blog post discusses how WebAPI can be used in your SSIS ETL process.
Using BIML with KingswaySoft SSIS Components
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.
Archive
Tags