Parsing Advanced JSON Structures with Ease Using SSIS Productivity Pack

16 February 2021
KingswaySoft Team

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.


Working with Amazon Marketplace Web Service API in SSIS

19 January 2021
Chen Huang

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.


Paging REST requests in SSIS using KingswaySoft JSON Source Component

14 January 2021
Chen Huang

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.


Announcing Migration Starter Pack v4.0 for Microsoft CDS and Dynamics 365/CRM

17 December 2020
Chen Huang

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.


Extract Bing Ads Reports with KingswaySoft

04 December 2020
Aswin Manmadhan

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.


Query CDS/CRM Online Data using SQL Query in SSIS

20 November 2020
Chen Huang

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.

 FetchXML   SQL   SQL2FetchXML   SSIS 

Using the Pre & Post Commands Feature in KingswaySoft Premium ADO.NET Components

19 November 2020
KingswaySoft Team

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.


Some personal perspectives on recent CDS terminology changes

14 November 2020
Daniel Cai

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.


Archive

Tags