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.

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.

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.

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

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.

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.

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.

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.