Schedule and Automate SSIS Package Executions Using KingswaySoft Integration Gateway
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.
Working with Custom Attributes in Azure Active Directory using KingswaySoft
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.
Working with Shopify API using KingswaySoft GraphQL Components
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.
Achieve Incremental/Delta Data Load Logic in Any Data Flow with KingswaySoft
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.
Applying Assignment Rules During Salesforce Integration Using KingswaySoft
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.
Migrating HubSpot Templates Using KingswaySoft HubSpot Toolkit
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.
Connect to Your Azure SQL Instance in SSIS ETL Process Using Modern Authentication
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.
Introducing Firestore NoSQL Component for Handling Complex Data Structures
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.