EWS retirement is fast approaching, and existing SSIS email integrations must be updated to avoid future failures. This step-by-step guide shows how to upgrade your current KingswaySoft Email Connection Manager to Microsoft Graph, update Azure Entra ID permissions, refresh component metadata, and transition your packages with minimal changes.

Ensure your business meets compliance and governance goals by extracting and saving historical data changes with Microsoft Dataverse audit logs. This blog post dives into the massive performance boosts made available in KingswaySoft’s SSIS Integration Toolkit v26.2, featuring exponentially faster log retrieval and reduced API workload.

Learn how to maintain relational integrity in NetSuite using KingswaySoft SSIS components. Discover a single Data Flow pattern to upsert Customer records, dynamically retrieve dependent Contacts via Premium Service Lookup, and link them without creating orphan records or duplicates.

Snowflake is moving toward mandatory MFA for password authentication later this year, which could disrupt automated, unattended SSIS scheduled jobs. Discover how to transition smoothly to modern OAuth 2.0 authentication using KingswaySoft's Snowflake Connection Manager to future-proof your ETL pipelines.

Managing SQL Server Agent jobs across a fragmented multi-server environment? Discover how to leverage KingswaySoft’s SSIS Integration Toolkit to extract execution history data, track incremental updates using a control table, and pipe unified telemetry straight into Splunk dashboards for real-time visibility.

Repetitive API calls and complex looping logic can slow down your integration packages and lead to data consistency issues. Learn how to utilize the Premium Recordset Source to capture child datasets, such as Shopify line items, once and reuse them across multiple SSIS Data Flows for a cleaner, more efficient design.

Looking for a secure and reliable way to bring Amazon S3 into your SSIS data flows? Discover how the KingswaySoft Amazon S3 Connection Manager simplifies cloud storage integration with flexible authentication methods like Access Keys, native IAM Roles, and secure VPC routing.

GridFS is a specification for storing and retrieving files that exceed the BSON-document size in MongoDB. In this blog post we demonstrate how to use KingswaySoft to seamlessly write or read large binary files from MongoDB for your integration and migration needs.

Learn how to pre-validate XML files in SSIS using PowerShell within our Windows command task to catch missing or empty critical nodes before they reach the XML Source.

As data ecosystems grow more complex, a shared language becomes essential. In this blog post, we explore the Common Data Model (CDM), its structure, and how KingswaySoft CDM components help you build a scalable, high-performance data architecture.

Tracking historical data changes shouldn't require hundreds of lines of complex SQL or cumbersome manual logic. Discover how KingswaySoft’s Premium SCD component automates Type 0, 1, and 2 changes, allowing you to scale your data warehouse while maintaining perfect historical accuracy—all within a high-performance SSIS environment.

Establishing secure connections to Google services often involves navigating a complex OAuth landscape. In this post, we provide a universal blueprint for creating a production-ready authentication setup that can be reused across multiple KingswaySoft Google components, ensuring reliable and unattended execution for your SSIS packages.

Working with nested JSON responses often makes reporting and analytics more complex than expected. In this post, we show how to flatten survey style JSON data using the Key Value Pivot feature in KingswaySoft's JSON Source component, eliminating the need for multiple lookups and conditional splits.

Migrating document templates in Dynamics 365 often leads to hiccups with custom entity associations, resulting in tedious manual rework. KingswaySoft offers a streamlined solution. In this blog post, we’ll demonstrate how to use our Integration Toolkit to automate document template migrations.

The ability to Upsert data is vital for businesses using HubSpot Custom Objects, as it ensures data integrity by preventing duplicates. The Upsert action intelligently either updates an existing record or inserts a new one based on a unique key. KingswaySoft makes this complex process easy by providing a reliable, low-code connector that automates the synchronization of external system data directly into your custom HubSpot fields, guaranteeing your CRM data is always current.

For Snowflake users, Internal Stages are secure, managed storage areas ideal for file storage. However, manually moving files to and from these stages often complicates existing ETL/ELT workflows and slows down data pipeline automation. This common challenge is streamlined by KingswaySoft's Snowflake components, and in this blog post, we'll see how this can be achieved

Duplicate data can undermine even the best CRM strategy. In this article, we’ll show you how to seamlessly identify and merge duplicate Salesforce records using KingswaySoft’s SSIS components - without writing a single line of code. Learn how to configure a deduplication flow that keeps your Salesforce instance clean, accurate, and free from duplicates.

Intuit is introducing a significant change to its QuickBooks platform that will impact how our SSIS Integration Toolkit connects to your data. To avoid service interruptions and ensure the stability of your data integration process, you will need to update your QuickBooks connection manager to use your own app. Read our full post to understand the change and follow our step-by-step guide to secure your connection.

Are you granting your SharePoint integrations access to every single site in your tenant? This common practice can create unnecessary security risks. Discover the modern, secure way to connect to SharePoint by granting permissions to specific sites only. Our step-by-step guide shows you how to leverage Microsoft's Resource-Specific Consent (RSC) to lock down your data pipelines and configure your KingswaySoft connection for maximum security and compliance.