TRAINING MATERIAL UPDATES
SSIS Integration Toolkit Crash Course: Microsoft Dynamics 365 CRM/Dataverse |
|
We are excited to share that we have completed a comprehensive refresh of our SSIS Integration Toolkit Crash Course: Microsoft Dynamics 365 CRM/Dataverse!
Our previous version of this course was developed more than five years ago. Since then, SSIS Integration Toolkit has continued to evolve significantly, with many new features, capabilities, and improvements introduced to help you build more powerful, flexible, and efficient Dynamics 365 CRM/Dataverse integrations. This completely refreshed course brings the training up to date and provides in-depth coverage of many of these newer capabilities.
Whether you are just getting started with SSIS Integration Toolkit or looking to refresh and expand your existing expertise, the updated course provides a practical and structured approach to building Microsoft Dynamics 365 CRM/Dataverse integrations. Topics range from core SSIS concepts and component configuration to implementation patterns, special field handling, real-time integration, licensing, upgrades, performance tuning, troubleshooting, and many of the latest features introduced to the toolkit.
Through updated instructional presentations and guided hands-on exercises, you will gain practical knowledge and skills that can be applied directly to your own integration projects.
If you have taken our Crash Course before - or have been waiting for an up-to-date training resource - now is the perfect time to check out the completely refreshed course and discover the many new capabilities available in SSIS Integration Toolkit! |
FEATURED CONTENT Connecting to NetSuite REST Using OAuth Client Credentials |
As NetSuite continues its transition toward REST Web Services and OAuth 2.0 for new integrations, choosing the appropriate authentication approach is increasingly important. In this blog, we walk through how to configure a certificate-based OAuth 2.0 Client Credentials connection for NetSuite REST using KingswaySoft's SSIS Integration Toolkit.
Key Highlights from the Blog: Configure a NetSuite integration record for the OAuth 2.0 Client Credentials grant and REST Web Services. Generate the required certificate and private key and create a Client Credentials mapping in NetSuite. Configure and test the KingswaySoft NetSuite Connection Manager using the Client ID, Certificate ID, algorithm, and private key.
|
FEATURED TECHNIQUE How to Effectively Extract Azure DevOps Data with KingswaySoft |
Azure DevOps work item data can provide valuable information for reporting, analytics, and maintaining historical records outside the platform. In this blog, we show how KingswaySoft's SSIS Integration Toolkit can extract Azure DevOps data using predefined or custom queries, while providing flexibility for centrally managed filters and more dynamic extraction requirements.
Key Highlights from the Blog: Use predefined queries to reuse work item filters already created and maintained in Azure DevOps. Configure custom queries with runtime variables to support dynamic criteria and incremental extraction scenarios. Access additional outputs for attachments, comments, and links to incorporate related work item information into SSIS data flows.
|
FEATURED WORKFLOW Building Incremental MongoDB Integrations with Change Streams and KingswaySoft |
Repeatedly extracting an entire MongoDB collection can be unnecessary when an integration only needs to process data that has changed. In this blog, we show how the MongoDB Source component in KingswaySoft's SSIS Integration Toolkit can use Change Streams and resume tokens to retrieve and process incremental change events within an SSIS workflow.
Key Highlights from the Blog: Retrieve events for document inserts, updates, replacements, and deletes using the Change Stream source type. Use operation details such as OperationType, DocumentKey, FullDocument, and UpdateDescription to support downstream processing. Store and reuse the MongoDB resume token with an SQL Server control table and Premium SQL Server Command Tasks to continue incremental processing between executions.
|
FEATURED SOLUTION Preparing and Ingesting Databricks Lakehouse Data into Dataverse |
Customer data can contain formatting inconsistencies, missing values, and other quality issues that should be addressed before reaching Dataverse. In this blog, we demonstrate how Databricks and KingswaySoft's SSIS Integration Toolkit can work together to prepare and validate customer data, route records based on validation results, and manage their downstream ingestion into Dataverse.
Key Highlights from the Blog: Apply reusable cleansing and validation rules through a Databricks SQL View before retrieving the prepared data into SSIS. Use a Conditional Split to route valid customers to Dataverse and preserve invalid records in a SQL Server table for further review. Configure the Dataverse/Dynamics CRM Destination with Upsert and other available options to support efficient ingestion of validated customer records.
|
NEW VIDEO RESOURCES Getting Started with Amazon DynamoDB Components |
This video introduces the Amazon DynamoDB components in KingswaySoft's SSIS Integration Toolkit. It walks through the Amazon DynamoDB Connection Manager, along with the Source and Destination components, and demonstrates how DynamoDB data can be retrieved and written within SSIS for data integration and ETL processing. |
Getting Started with Google Cloud Storage Components |
Learn how to work with Google Cloud Storage using the components available in KingswaySoft's SSIS Integration Toolkit. This video covers the Google Cloud Storage Connection Manager, Source, and Destination components, demonstrating how to connect to cloud storage and read and write data within SSIS-based integration workflows. |
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. |
|
|
|
