FEATURED CONTENT EWS to Microsoft Graph: Update Your Email Integrations |
Organizations using Exchange Web Services (EWS) for their Exchange Online integration should begin updating their existing SSIS email connections to use the latest Microsoft Graph API. In this blog, we walk through the migration process for KingswaySoft Email connection managers, including updating Azure Entra ID permissions, refreshing component metadata, and resolving unsupported field mappings.
Key Highlights from the Blog: Update Azure Entra ID permissions and configure the Email Connection Manager to use Microsoft Graph API. Use the Advanced Editor to assign a newly created Microsoft Graph connection manager while helping preserve existing Email Source or Destination settings. Refresh component metadata, remove unsupported EWS-specific columns, and validate the updated package before deployment.
|
FEATURED WORKFLOW Accelerate Dynamics 365 Audit Log Retrieval via KingswaySoft |
|
Microsoft Dataverse and Dynamics 365 CRM audit logs provide important historical details about user activity, record changes, access events, and relationship updates. Efficiently retrieving this information can help support compliance, troubleshooting, security reviews, and operational analysis.
In this blog, we examine how the Dataverse/Dynamics CRM Source component in KingswaySoft's SSIS Integration Toolkit retrieves audit log data and highlight the v26.2 enhancements for performance, API efficiency, and error handling.
Key Highlights from the Blog: Retrieve audit headers, attribute changes, relationship changes, record-sharing updates, and role privilege changes through dedicated pipeline outputs. Use multithreaded reading, configurable batch processing, and FetchXML to extract audit records more efficiently. Review the preliminary benchmark results showing nearly 30 times faster performance after the upgrade.
|
FEATURED TECHNIQUE Streamline NetSuite Customer & Contact Integration with SSIS |
Integrating Customers and related Contacts into NetSuite requires the records to be processed in the correct order to preserve their parent-child relationship. This blog demonstrates how to upsert the Customer first, capture the returned NetSuite record ID, and use that value to associate and upsert the corresponding Contact records within a single SSIS data flow.
Key Highlights from the Blog: Use External IDs with Upsert operations to update existing records and create new records only when needed. Retrieve related Contact records with the Premium Service Lookup component. Map the returned NetSuite Customer ID to each Contact record to maintain the correct relationship and help prevent orphan records.
|
NEW RELEASE AVAILABLE
2026 Release Wave 2 |
This release expands the SSIS Integration Toolkit with Exchange Online (Microsoft Graph) support and new connector coverage, while the JDBC Driver Pack adds support for 30 newly added connectivity solutions. The release also includes continued platform enhancements and Integration Gateway updates to help organizations build and maintain modern integration solutions. |
PLATFORM UPDATE
EWS Retirement: Migrate to Microsoft Graph |
As we have discussed in one of the blog posts above, Microsoft is retiring Exchange Web Services for Exchange Online, making it important for organizations to review any existing EWS-based integrations and plan their transition path. As Microsoft continues to invest in Microsoft Graph as its modern API platform for Microsoft 365, teams relying on EWS should prepare for this shift to help maintain compatibility and support long-term integration needs.
Key Highlights from the Article: What the EWS retirement timeline means for existing Exchange Online integrations. Why Microsoft is moving from EWS to Microsoft Graph as its strategic API platform. How KingswaySoft helps organizations transition to modern Microsoft Graph-based connectivity.
|
REFERENCE IMPLEMENTATIONS
Jira & Zendesk Integration/Migration Starter Pack |
This new Integration/Migration starter pack provides two sample SSIS packages built with KingswaySoft's SSIS Integration Toolkit to support incremental data movement between Jira and Zendesk. It includes separate Jira-to-Zendesk and Zendesk-to-Jira packages that can be configured and extended based on your integration or migration requirements.
Key Highlights: Use separate directional packages for Jira-to-Zendesk and Zendesk-to-Jira data movement. Process tickets, issues, comments, attachments, status values, and related identifiers through a staging-table-first design. Support incremental loads, value mapping, dependency handling, centralized error logging, and extensions for additional fields and workflows.
|
Dataverse & Salesforce Integration/Migration Starter Pack |
This new Integration/Migration starter pack provides two sample SSIS packages built with KingswaySoft's SSIS Integration Toolkit for moving data between Salesforce and Dataverse/CRM. It includes separate directional packages that can be configured for full migration scenarios and extended to support ongoing incremental integration.
Key Highlights: Use separate packages for Salesforce-to-Dataverse and Dataverse-to-Salesforce data movement. Migrate accounts, contacts, emails, tasks, files, notes, and related attachments while managing record dependencies. Apply built-in lookups, option-set mapping, error handling, retry support, and extensible data flow logic.
|
NEW VIDEO RESOURCES Getting Started with MongoDB Components |
This video introduces the MongoDB components in KingswaySoft's SSIS Integration Toolkit. It walks through the MongoDB Connection Manager, along with the Source and Destination components, to show how MongoDB data can be read and written within SSIS for integration and ETL processing. |
Getting Started with Redis Components |
This video introduces the Redis components in KingswaySoft's SSIS Integration Toolkit. It covers the Redis Connection Manager, along with the Source and Destination components, and shows how Redis data can be retrieved and written within SSIS for data integration and ETL scenarios. |
Getting Started with Google Ads Components |
This video provides an overview of the Google Ads components in KingswaySoft's SSIS Integration Toolkit. It demonstrates how to configure the Google Ads Connection Manager and use the Source and Destination components to retrieve and write Google Ads data within SSIS for integration and ETL processing. |
IN-PERSON EVENT Power Platform Community Conference 2026 |
| | |
