Construct ActivityParty JSON Values for Dataverse Activity Entity Migration

30 March 2022
KingswaySoft Team

In this blog post, we will show a simple solution that can be used to generate the JSON structure from database tables which can be sent to CDS/CRM destination components for writing, we demonstrate the use of SQL FOR JSON clause to achieve the purpose.


Executing Snowflake Functions in SSIS ETL Processes

28 March 2022
KingswaySoft Team

The Snowflake command task that is a control flow level task can be used to easily execute functions in Snowflake and use it for further data flow executions.


Convert Word documents to PDF Leveraging Google Drive Platform

28 February 2022
KingswaySoft Team

It is a very common business requirement that in our job we may receive documents in some particular formats, which the business team would like to have them converted into PDF files. Such requirements arise from many of the advantages when using PDF formats for file exchanges, such as portability, universal compatibility, reliability, security, size reduction, versatility, professionalism, etc. Given such common requirement, it would be highly useful to have a tool that can pick up documents from a specific location and have them converted to a PDF files in an automated manner, such as an automated ETL process. In this blog post, we will show you how to easily achieve this using components from our SSIS Productivity Pack product offering.


Working with Business Central/NAV REST API v2 in SSIS

27 January 2022
KingswaySoft Team

This post will walk you through how to query the Dynamics Business Central/NAV REST API data by using the Premium OData Source component.


Working with Microsoft Graph API in SSIS using KingswaySoft Productivity Pack

26 January 2022
KingswaySoft Team

In this blog post we will demonstrate how to use the Premium OData Source component to work with SharePoint site data through Microsoft Graph REST API.


Perform Lookups When your Target Values are Padded

22 December 2021
KingswaySoft Team

In our ETL development, we don't always receive the data in the exact format that we expect it to be. For instance, there might be cases that the incoming data is a string value while we expect an integer, or in some other cases, there might be unexpected whitespaces which can make the lookup difficult. This blog post will specifically cover the lookup scenario and show you how to achieve the lookup functionality without additional extra work.


Extracting RSS Feed Data in ETL Process using KingswaySoft

26 October 2021
KingswaySoft Team

It’s a very common practice to receive news updates using RSS feeds. Even though users are shifting to social media for getting news and headlines that are prominent, these platforms are controlled by algorithms that decide what news goes to which user, and users may see the headlines which the platform decides. RSS feeds provide all the contents that are published by the sources that can be subscribed to. Now, when it comes to integration, extracting RSS feeds data can be a challenging task without a proper tool. In our blog post here today, we will show how you could leverage KingswaySoft SSIS Productivity Pack to achieve this with ease, so that you could possibly consume the data in your ETL process with great control.


Working with Custom Authentication Token in KingswaySoft HTTP Connection Manager

30 September 2021
KingswaySoft Team

There are cases where you might need to work with a custom token for your HTTP connection's authentication. This is not very straightforward to achieve for your HTTP-based service calls. In this blog post, we will show you how you may leverage the Custom Token option offered in the KingswaySoft HTTP Connection Manager to extract such custom token and then use it in subsequent HTTP service calls.

 About 

Archive

Tags