In your ETL integration development, you might run into a situation where you need to obtain some information from a JSON or XML file served by an HTTP service endpoint via either SOAP or REST framework. Without a proper strategy, this process design can impose some interesting challenges. In this blog post, we will showcase how to use our HTTP Requester Task and JSON Extract Task to accomplish this with ease.

Message queues are pivotal when it comes to communicating within a system or between multiple systems. It allows different parts of a system to communicate and process operations asynchronously. A message queue provides a lightweight buffer that temporarily stores messages and endpoints, which allow client components to connect to the queue and send and receive messages. KingswaySoft has various message queue components and control flow tasks that can be used in your integration workflow. Today, we will be looking into a specific constraint that queues could cause with higher volumes of messages, and how these can easily be handled within SSIS with KingswaySoft.

Power BI reports are a great way to get quick and detailed snapshots of data sources. In this blog post, we will discuss how to export reports in your preferred offline format (such as PDF) and send them to any email address required, all within a single data flow. Additionally, you will be able to dynamically set how frequently to send the report and to add or remove recipients receiving this email.

Sending emails is a common scenario in integrations, whether for logging a process status, sending a periodic report, job monitoring, etc. Handling this within the SSIS package can be advantageous in many ways, and with KingswaySoft's Email Destination Component, we make it as easy as possible.

Associations are used in HubSpot to define a relationship between objects and activities. It is critical to have these properly defined to keep your data and relationships as intended. In this blog post, we will show you how to use KingswaySoft components to easily create and maintain HubSpot associations.

Moving emails across Dataverse or Dynamics 365 environments, especially handling email attachment records, poses unique challenges due to the specific behaviors of the Dataverse/CRM email attachment entity. In this blog post, we will demonstrate how to work with the ActivityMimeAttachment entity in Microsoft Dynamics CRM for accurate data migration, using the CDS/CRM Destination components available in our Dynamics 365 Toolkit.

Azure Key Vault is a popular key and secrets management solution from Microsoft, and it can be beneficial to use it for storing your sensitive SSIS connection credentials for runtime job execution. In this blog post, we will see how KingswaySoft can be used to store and retrieve such sensitive connection information from Azure Key Vault to facilitate a secure connection seamlessly.

Custom access tokens are commonly used to obtain authorization tokens. Sometimes, they process requires using one of the parsing and extraction strategies. In this blog post we will illustrate some advanced use cases for this feature when using the HTTP connection manager offered in our SSIS Productivity Pack product.