Thank You for a Remarkable 2025 from KingswaySoft |
As we close out 2025, we would like to thank our business users, partners, and community for your continued trust and support throughout the year.
This year marked meaningful progress for KingswaySoft, with two major release waves, expanded connectivity, new partnerships, continued team growth, and active engagement with the data community, including our participation at the PASS Data Community Summit 2025.
We have put together a year-end recap highlighting the key milestones, product advancements, and moments that shaped 2025.
From all of us at KingswaySoft, we wish you a joyful holiday season and a successful start to 2026. |
SSIS 2025 NOW AVAILABLE
SSIS 2025 is Here: Secure Your ETL and Modernize with Microsoft Fabric |
SSIS 2025 is now Generally Available, introducing mandatory Microsoft Entra ID authentication, TLS 1.3 encryption, and a clear path to Microsoft Fabric while retiring legacy components such as 32-bit execution and older connectors. These changes significantly raise the bar for security and compliance but also create modernization challenges for existing ETL environments.
KingswaySoft helps organizations navigate this transition seamlessly with codeless, enterprise-grade SSIS connectors that keep packages secure, compliant, and ready for Fabric today and beyond. |
FEATURED CONTENT
Flattening Nested JSON Data Using Key Value Pivot with KingswaySoft |
Nested JSON structures are common when working with modern REST APIs, especially for survey, feedback, and form-based systems. These responses often include a single parent record with multiple related child values, making it difficult to produce a clean, tabular dataset for reporting.
In this blog, we demonstrate how to use the Key Value Pivot feature in KingswaySoft's JSON Source component to flatten nested JSON data directly at the source. By pivoting key value pairs during extraction, you can avoid complex Conditional Split and Lookup patterns while producing a single, wide record per entity.
Key Highlights from the Blog: Understand why traditional lookup-based designs create unnecessary complexity when flattening nested JSON Learn how to configure Key Value Pivot in the JSON Source Document Designer Produce a clean, analysis-ready dataset using a single component with fewer transformations
|
FEATURED TECHNIQUE
Effortless Dataverse/CRM Document Template Migration with KingswaySoft |
Document Templates play a key role in Dynamics 365 Dataverse and CRM, enabling teams to generate standardized Word and Excel documents directly from records. While migrating these templates is usually straightforward, templates tied to custom entities introduce an added challenge due to differing entity type codes between environments.
In this blog, we walk through how KingswaySoft’s SSIS Integration Toolkit for Dynamics 365 handles this scenario reliably, ensuring document templates remain correctly associated with custom entities during migration.
Key Highlights from the Blog: Understand why custom entity document templates can break during cross-environment migration Learn how the associatedentitytypecode.old field resolves entity code mismatches automatically See a step-by-step SSIS data flow design for migrating document templates safely and efficiently
|
We are always looking to showcase the work of organizations achieving meaningful results through integration. Participating in a case study is an opportunity to highlight your success, gain visibility within your industry, and share your story with a broader audience.
If this is something you'd be interested in, you may contact us at marketing@kingswaysoft.com or submit the details using the form below. |
We Want to Hear From You! |
We would love to hear from you. We want to make sure that your interactions with us are easy and smooth. Fill us in - it will only take 3 minutes. Your feedback is greatly appreciated and will help improve your future experience with us. |
|
|
|
