Query CDS/CRM Online Data using SQL Query in SSIS
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.
Using the Pre & Post Commands Feature in KingswaySoft Premium ADO.NET Components
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
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.
Extract Table Data from PDFs with Ease using our Premium PDF Source component
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.
Composing and Decomposing Data in SSIS
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.
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.