Downloading JSON or XML files typically requires saving them to a local staging area first. With KingswaySoft’s SSIS Productivity Pack, you can skip that step by processing the data entirely in memory. In this blog post, we demonstrate how this can be achieved.

Dynamics 365 Customer Insights Journeys is incredibly important for businesses as it is able to provide insight and help visualize the journey that customers take when engaging with your products or services. The data can help you improve how your business engages with customers and get a better understanding of the customer journey life cycle. Due to the importance of Dynamics 365 Customer Insights Journeys, you may want to work with the Customer Insights journeys data in your data integration solutions. With our newest release, this can be easily done with our Premium Data File Source component with OneLake Connection Manager.

In NetSuite, we have introduced the option to work with REST Token-Based authentication to establish a connection with your NetSuite environment. This modern approach offers flexibility with access to objects and the actions to perform on them and is lightweight.

In SQL, Stored procedures provide the option to use Output parameters as a way to return back data to the query which has called the procedure, and this can in turn, be beneficial for improved code organization and better performance. With our latest version of SSIS Productivity Pack, we have introduced Output parameter handling support to a few of our component tasks. In this blog post, we will be looking specifically at our Premium SQL Server components and how they can manage this.

Azure AD (Microsoft Entra ID) Enterprise Applications have long provided robust authentication for Dynamics 365/Dataverse integrations using client secrets or certificates - proven methods that remain secure when properly managed. However, for teams seeking to further streamline operations and align with modern Azure-native practices, we’re thrilled to announce the newly added Azure Managed Identity authentication option in the Dataverse/CDS/CRM Connection Manager in our v25.1 release of SSIS Integration Toolkit for Microsoft Dynamics 365 made available on April 4, 2025.

There are various ways to schedule and run SSIS packages once deployed onto a server with integration services enabled on it. In this blog post, we will be going over the steps that are involved to easily schedule your packages and automate the process using our KingswaySoft Integration Gateway, which is an easy and efficient approach.

While working with Azure Active Directory (AD) objects like users and groups, if you require additional fields to fit your requirements, these can be managed by creating custom extension attributes. These are user-defined custom metadata that can be created in the Azure portal or through the API. In this blog post, we will go over the steps involved in manually adding and working with these custom extension attributes in your SSIS data flow using KingswaySoft.

GraphQL offers significant advantages over REST, making it the preferred choice for Shopify integrations. In this blog, we'll show how to configure KingswaySoft's GraphQL components to efficiently connect, read, and write data to Shopify's GraphQL API. From authentication and pagination to querying nested data, we'll cover key setup steps and best practices for optimizing your integration.

Having an incremental load or capturing delta changes is crucial for any integration scenario. This increases efficiency and allows to reduce the load during each package execution run by reading only the changes that occurred after the last execution from the Source system. In this blog post, we will show you a simple design using KingswaySoft components that can be applied to almost any data flow requiring incremental load capabilities.

Assignment rules are a set of criteria that determine how a lead or case will be assigned. They are a powerful feature in Salesforce that can help automate your organization's process for working with leads and cases. In this blog post, we will go over how to create Assignment Rules and how to effectively use them when importing records with Kingswaysoft SSIS Integration toolkit for Salesforce.

HubSpot CMS is a powerful system of tools for companies to manage both their website and content strategy. One of the most important aspects of HubSpot CMS is its use of Templates. Due to their significance within HubSpot CMS, our SSIS Integration Toolkit for HubSpot specifically supports working with Templates, which can be used to migrate them from one instance to another with ease. However, working with HubSpot Templates has some nuances that need to be addressed. In this blog post, we will go over two different scenarios for working with HubSpot Templates.

This blog post will walk you through various methods we have implemented for working with OAuth in our Premium SQL Server components, providing secure access for applications and users.

Firestore is a popular NoSQL database and offers some advantages over traditional relational database models. With its scalability, querying, and indexing capability, complex data structure can be easily handled for real-time business requirements. KingswaySoft offers Firestore components to connect, read, and write to it. In this blog post, we will delve into such a scenario for handling the data.

Switching to modern Salesforce OAuth helps enhance the security of your integration connection. For this reason, we have outlined the benefits of making the transition. This walkthrough covers creating a Salesforce app for OAuth, gathering the necessary information, and setting up a Salesforce Connection Manager to connect to your Salesforce application for integration purposes.

In this blog post, we will focus on implementing a more complex Update action when writing using the KingswaySoft Premium Lookup component, giving users greater control over which records to update. For example, only updating the record if it was modified before a certain date.

In Dynamics 365 CE/CRM, Actions are a type of process that can be invoked to perform a specific task. They supports input parameters that can be passed in as arguments if required, as well as Output parameters to obtain a status or any parsed value. In our KingswaySoft Dynamics CRM Destination component, you can easily trigger an Action by using the ExecuteWorkflow option and configure the output parameters as well. In this blog post, we will go through the steps to accomplish this.

Msiexec allows you to install MSI files silently without user interaction, which can be useful for deploying KingswaySoft's SSIS Integration components. In this blog post, we'll cover how to use this feature with our toolkits, to enable unattended installations in your environment, making automated deployments and installations more efficient.