Many of our clients are switching their Authentication to OAuth for their connections in our CDS and Microsoft Dynamics 365 CRM components. OAuth provides a better security infrastructure to protect your Dynamics data. The process of switching to OAuth authentication can be a bit confusing in the beginning if you have never worked on the concept before. In this post, we will walk you through the process with some great details to help you understand what is required and how OAuth works for our CDS/CRM connections.

This post will demonstrate how to perform file existence check in SSIS without writing a single line of code by using KingswaySoft Premium File Properties Task.

This post will give examples of how to query the SharePoint REST API data with filters and expanded properties, invoke functions using Premium OData Source component.

Excel has a rich set of options to write and save values for DateTime and currency data, in order for them to be presented in a meaningful way. However writing such data in a correct format isn't always straightforward in an ETL process, and it can be challenging when there are some special business requirements. In this blog post, we will show you how to write a proper currency format leveraging the power of the Premium Excel Destination component. 

When working with REST API, a common scenario may arise where there could be additional information returned from the API response and user needs to process and handle, in some cases it is extremely value to save such results. The challenge is the response returned by the service call is different from service to service. This blog post will demonstrate how to configure KingswaySoft JSON Destination component to send out JSON formatted request and extract API response and associate the response back to the original input rows to provide the most accurate reporting and troubleshooting.

While our Dynamics 365 toolkit supports Microsoft Dynamics 365 BC/NAV for reading and writing data, but the toolkit does not currently support Codeunit services. In this blog post, we will show you how to call Dynamics BC/NAV Codeunit services using the OData components that we have in the SSIS Productivity Pack product.

The major advantage of using the bulk load features is a significant improvement in data load performance. In this blog post we will be discussing about the bulk loading capabilities of the Snowflake Destination component that is available in our SSIS Productivity Pack product, which helps facilitate high-throughput writing to Snowflake data warehouse utilizing the Snowflake API.

In this blog post, we will be discussing the bulk loading capabilities in our Amazon Redshift Destination component that are available in the SSIS Productivity Pack product offering. The blog post shows you how to leverage the features to enable a high throughput data load utilizing the Amazon Redshift API.

In this blog post, we will discuss how to perform file upload using HTTP multipart/form-data format in SSIS without having to write a single line of code.

In this blog post, we will be going through some complex JSON document structures and demonstrate how to configure KingswaySoft JSON Source/Extract component to extract data from those JSON documents efficiently.

Explore working with Amazon Marketplace Web Service API by using HTTP Connection Manager and XML Source component offered in our SSIS Productivity Pack without writing a single line of code.

In this blog post, we will be going through some of the most common API pagination methods and demonstrate how to configure KingswaySoft JSON Source component to send out the paginated requests in SSIS.

Our CRM migration starter pack has been widely used by many clients worldwide. We have just made some further enhancements to cover some important migration tasks.

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.