In this blog post, we demonstrate how a Bing Ads Source component can be used to read from Reports and extract data in a tabular format, and how it can be utilized to write to a database.

In this blog post, we demonstrate how to connect to CDS/CRM Online SQL database through an ADO.NET Connection Manager and query data using the Premium ADO NET Source component, a part of our SSIS Productivity Pack.

In this blog post, we demonstrate how to use the Pre & Post Commands feature in the Premium ADO.NET components to run SQL statements or set session variables before or after executing our components.

For most of you who work in the Dynamics or Power Platform community, you must have heard, Microsoft has recently announced some of the terminology changes for the CDS and Power Platform. In this blog post, I would like to share some of my personal perspectives on those changes.

With a simple setup, extract PDF table data with ease using KingswaySoft's Premium PDF Source component, our latest offering from our 2020 Release Wave 2.

When integrating data between different applications or database systems, what do you do when certain fields hold data in a different format than what the target system is expecting? This blog post will demonstrate how using our latest components within the SSIS Productivity Pack, Composition and Decomposition, you can parse each individual value from a delimited text form with ease.

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 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.

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.

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.

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.

Learn how to quickly delete numerous records in Microsoft Dynamics 365 CRM at once with the BulkDelete action.

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.

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.

Manipulating input data can be challenging when working with the JSON format of CRM's ActivityParty fields. Let us take you through the process.

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.

Explore working with Dynamics BC/NAV Codeunit web service by using HTTP Connection Manager and Web Service components offered in our SSIS Productivity Pack.

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.

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.