Extracting HTML Table Contents from Email Bodies

30 August 2021
KingswaySoft Team

There might be cases where you would be receiving emails with some tables contained in the email body and you are tasked to extract data from those tables and transform them into a flat file or otherwise a database table. This can be a challenging situation without proper tools. In this blog post, we will demonstrate how to extract tables structures from an email using the Email Source component and HTML Table Source component from the KingswaySoft SSIS Productivity Pack.


Switching to OAuth in Dynamics 365 CDS/CRM/CE/Dataverse connections

27 July 2021
KingswaySoft Team

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.


Writing Excel Currency Data with Proper Currency Formatting

31 May 2021
KingswaySoft Team

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. 


Proper Output Handling with KingswaySoft JSON Destination Component

28 April 2021
KingswaySoft Team

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.


Bulk Load to Snowflake using KingswaySoft

24 March 2021
KingswaySoft Team

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.


Bulk Load to Amazon Redshift using SSIS Productivity Pack

04 March 2021
KingswaySoft Team

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.


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.

Archive

Tags