Happy Holidays from KingswaySoft: A Look Back at 2023
As we wrap up the final pages of 2023, the KingswaySoft team wants to extend heartfelt wishes to our extended customer and partnership community for a joyful holiday season and a prosperous new year. Reflecting on the past year, we are deeply grateful for your unwavering support throughout the year, and we want to thank you for the trust you've placed in us to address your data integration needs. We hope that we have been helpful.
In 2023, we proudly introduced three major release waves, each representing a leap forward in our commitment to innovation and excellence. We have forged some important partnerships that have enriched our community throughout the year. At the same time, we are proud that we have grown our team with more talents added.
At KingswaySoft, our mission is to empower you with sophisticated and productive integration solutions. We hope our efforts have not only met but exceeded your expectations, facilitating your journey to success. As we eagerly anticipate the new year, we are committed to providing even more value to your success in the future.
To share the highlights of 2023 and express our gratitude, we've compiled some important moments that showcase our collective achievements.
Three Release Waves in 2023
2023 Release Wave 3
Our final release of the year, the 2023 Release Wave 3, brought more than 86 new features and enhancements. We added support for Microsoft Graph APIs, which facilitates integration to various Microsoft services through one simplified framework. We also added three new REST services: Extensiv / 3PL Central, Microsoft Planner, and Webex. Additionally, we added Azure Key Vault and AWS Secrets Manager tasks and related connection managers to our SSIS Productivity Pack.
2023 Release Wave 2
In September 2023, we announced our major release of the year, the 2023 Release Wave 2. This version included several new features and enhancements, such as the new GraphQL components, which work with various GraphQL-based services. We added more than 10 REST services, including Blackbaud, Emfluence, Google Classroom, Google People, Google Search Console, Google Tag Manager, Paycor, Open Accounting, Zoho Sheet, Zoho Expense, and Zoho Invoice. In our SSIS Integration Toolkit for Dynamics 365, we introduced support for xMultiple messages, such as CreateMultiple, UpdateMultiple, and DeleteMultiple. This feature can provide some significant performance improvement with writing when enabled.
2023 Release Wave 1
In the first release of the year, the 2023 Release Wave 1, we added support for Airtable, Authorize.NET, BambooHR, Duo Security, Emarsys, Google Calendar, Google Maps, OneLogin, Ping Identity, RingCentral, among many more new services. We made significant improvements to our REST Services, including Acumatica, Facebook, LinkedIn, ServiceNow, Shopify, Square, TikTok, WordPress, etc. For the SSIS Integration Toolkit for Dynamics 365, we included support for outputting the results returned by the ExecuteWorkflowAction in the CDS/CRM destination component, and we have added support for the "Authorization Server URL" and "Use Integrated Authentication" options in the NAV/Business Central connection manager.
Summit Events
Community Summit North America
This year, we participated as Gold Sponsors at the Community Summit North America, the largest independent gathering of Microsoft's business applications ecosystem, which unites users, partners, and ISVs.
We want to thank the community and all attendees who visited our booth for a chat. We had a great time at this event, and we hope you did too.
PASS Data Community Summit
In November, we participated as sponsors at the PASS Data Community Summit 2023. The fall summit, held in Seattle from November 13 to 17, featured a five-day event with two days of Pre-Cons followed by three days of main conferences. It was a pleasure to spend a week with this growing community, and we want to thank all the attendees who dropped by our booth!
Google Cloud Ready Designations
In September of this year, we successfully achieved the Google Cloud Ready - Cloud SQL designation. We are proud to further strengthen our partnership with the Google team to provide the most sophisticated integration solution for Google Cloud SQL, Google Cloud’s newest fully managed relational database service for MySQL, PostgreSQL, and SQL Server.
In 2023, we also achieved our Google Cloud Ready - AlloyDB designation. Once again, we are pleased to deepen our partnership with the Google team, focusing on delivering a cutting-edge integration solution for Google AlloyDB, the newest fully managed PostgreSQL-compatible database service within the Google Cloud portfolio.
Moving Forward
KingswaySoft Announces 2023 Release Wave 3
OAKVILLE, ON: November 30, 2023 - KingswaySoft Inc., a leading provider of data integration solutions, today announced this year's Wave 3 release mainly focused on their widely-used SSIS Productivity Pack and its real-time integration solution - KingswaySoft Integration Gateway. This release contains over 83 new components, features, and improvements designed to enhance your ETL development process and productivity levels.
Boost Efficiency with the upgraded SSIS Productivity Pack
Our SSIS Productivity Pack has been enhanced and expanded with exciting new features. Here are some of the exciting new additions and enhancements showcased in this release:
- We have added support for Microsoft Graph APIs, which facilitates integration to various Microsoft services through one simplified framework.
- We have three new REST services: Extensiv / 3PL Central, Microsoft Planner, and Webex.
- Newly added support for Elasticsearch DataStream API.
- Newly introduced MQTT Connection Manager, Source, Destination, and Task components.
- Newly added Azure Key Vault and AWS Secrets Manager tasks and related connection managers.
- Many other enhancements and fixes in various components, including Redis, Flat File, PayPal, Freshservice, and many more.
Among the above-mentioned, we would like to quickly highlight the following:
With the AWS Secrets Manager task, you can establish connections with AWS Secrets Manager to read confidential information stored in the secrets manager to be used for SSIS executions or otherwise perform create, update, delete, and restore on AWS Secrets.
The Microsoft Graph SSIS components enable seamless connections and integration to access Microsoft Cloud service resources, while facilitating writing to OData endpoints.
The new Azure Key Vault task enables you to connect with Azure Key Vault (Gen1 / Gen2) to read confidential information stored in the vault during SSIS runtime, and perform actions like set, delete, and purge on Azure Key Vault.
Increase Efficiency with Your Real-Time Integration
Highlighted below are some important new updates within our Integration Gateway real-time solution:
What's New - KingswaySoft Integration Gateway
We have added a new 'BaseURL' property at the general/server level which simplifies the generation of full URLs for incoming webhook endpoints. In addition, we added support for 7 new applications as inbound webhooks, including Dataverse/Dynamics 365 Customer Engagement, Dynamics 365 Finance and Operations, Microsoft Teams, QuickBooks Online, Discord, FreshBooks, and Stripe. We have significantly improved the workflow when configuring a Dynamics 365 Business Central inbound connection.
About KingswaySoft
KingswaySoft is a leading integration solution provider that offers sophisticated software solutions that make data integration simple and affordable. Thousands of enterprise clients from over 100 countries rely on our no-code SSIS Integration solutions to integrate data with various application systems to drive business efficiency and leverage information assets.
Learn more at www.kingswaysoft.com
KingswaySoft Announces 2023 Release Wave 2
OAKVILLE, ON: September 8, 2023 - KingswaySoft Inc., a leading provider of data integration solutions, today announced its 2023 release wave 2 of their widely-used SSIS Integration Toolkit product family, along with SSIS Productivity Pack and its real-time integration solution - KingswaySoft Integration Gateway. This release contains over 290 new components, features, and enhancements, that will help streamline your ETL development and boost your productivity.
SSIS 2008 and 2008 R2 Support Removed
We should first highlight that we have removed SSIS 2008 and 2008 R2 support in this release. This move will help us better allocate our resources on new features in our development in the future. We should note that SQL Server 2008 has reached its end of life support back in July 2019.
More Power with the updated SSIS Productivity Pack
Our SSIS Productivity Pack has received many significant enhancements and exciting new features. Here are a few of the new additions and enhancements featured in this release:
- Newly introduced GraphQL components that work with various GraphQL-based services.
- More than 10 REST services including Blackbaud, Emfluence, Google Classroom, Google People, Google Search Console, Google Tag Manager, Paycor, Open Accounting, Zoho Sheet, Zoho Expense, and Zoho Invoice.
- Newly introduced Windows Command Task that allows execution of PowerShell scripts or Windows commands from within SSIS runtime.
- Newly introduced SMB Connection Manager to work with SMB file sharing.
- Newly introduced JSON Extract and XML Extract tasks.
- Newly introduced Google Ads Destination component.
- Numerous enhancements in various components, including Kafka, ADP, Freshservice, Magento, Teams, Shopify, Xero, and many more.
Among all the new components, we would like to quickly highlight the following:
The Dynamics CRM Command Task can be used to translate SQL scripts, including INSERT, UPDATE, DELETE statements, into operational Dynamics 365 service calls in order to facilitate data writing.
The Google Ads Destination component is an SSIS data flow pipeline component that can be used to write data to Google Ads services.
The new SMB Connection Manager component can be used to establish connections with SMB protocols.
Increase Efficiency with Upgraded Data Integration Toolkits
Here, we've highlighted some significant new features within our SSIS Integration Toolkits and our real-time integration solution:
What's New - SSIS Integration Toolkit for Microsoft Dynamics 365
We added support for the recently introduced xMultiple messages (CreateMultiple, UpdateMultiple, DeleteMultiple). This feature can provide some significant performance improvement with writing when enabled. In addition, we have added a Dynamics CRM Command Task that can make service calls based on the provided SQL scripts.
What's New - SSIS Integration Toolkit for Microsoft SharePoint
We added a new source type called <System>.ListMetadata in SharePoint source component, which can be used to retrieve the list of all lists and document libraries under a particular SharePoint URL or site with all their metadata returned.
What's New - SSIS Integration Toolkit for HubSpot
We have added support for Analytics Reports object in the HubSpot source component. In addition, we added support for various CRM v3 Engagement objects such as calls, communications, emails, meetings, notes, postal mail, and tasks.
What's New - SSIS Integration Toolkit for Salesforce
We now support subqueries in Salesforce Source component when the Object Query source type is used.
What's New - SSIS Integration Toolkit for QuickBooks
We have added support for DiscountDays, DueDays fields when working with the Term object.
What's New - SSIS Integration Toolkit for Directory Services
We added support for device object when working with an Azure Active Directory via the Active Directory source and Active Directory destination component. LDAP connections can now leverage the newly introduced SSL certificate support for a secured connection.
What's New - KingswaySoft Integration Gateway
We now encrypt sensitive properties in the app.config file. In addition, the Integration Gateway has received a number of UI optimizations and enhancements in this round of updates.
About KingswaySoft
KingswaySoft is a leading integration solution provider that offers sophisticated software solutions that make data integration simple and affordable. Thousands of enterprise clients from over 100 countries rely on our no-code SSIS Integration solutions to integrate data with various application systems to drive business efficiency and leverage information assets.
Learn more at www.kingswaysoft.com
Join KingswaySoft at PASS Data Community Summit 2023
Save the Date!
November 14 - 17, 2023
At KingswaySoft, we are thrilled to announce our presence at PASS Summit 2023! Join us for insightful sessions, partnership opportunities, and an opportunity to win an Amazon Kindle 16GB! Don't miss out and stay tuned for more updates!
Visit our booth and join our team of experienced professionals who will showcase our latest features and demonstrate how our solutions can adeptly tackle complex data integration challenges, ensuring smooth and efficient data flows.
About KingswaySoft
KingswaySoft offers over 300 SSIS components that facilitate the most complex integration scenarios. These include data masking and anonymization, duplicate detection, data comparison, data profiling, advanced expression, encryption and compression, JSON & XML processing, SFTP/FTPS, and message queuing, to name a few. Many other premium components support in delivering a rapid ETL development experience using Microsoft Visual Studio and SQL Server Integration Services (SSIS) as the platform.
Our solution also includes support for connecting to NoSQL databases, cloud storage services, REST APIs, and virtually any other API or web service endpoint (SOAP or REST). Connectivity solutions are also available for facilitating data integration with enterprise applications such as Microsoft Dynamics 365, Active Directory, HubSpot, Microsoft SharePoint, Salesforce, and many more. Similarly, REST connections are available for numerous applications, including Asana, Facebook Business, MailChimp, Microsoft Teams, MYOB, Twilio, Shopify, Slack, WordPress, Yammer, and Zuora, to name a few.
Join KingswaySoft at Community Summit NA 2023
Don't Miss Out!
October 15 - 20, 2023
We are excited to share that we are now back to in-person at events and we will be at the Community Summit North America 2023 as a Gold sponsor again! Visit our booth and experience the power of our seamless data integration solutions.
Stay tuned for more updates!
Join us at our booth for insightful demos and a firsthand look at how our solutions can streamline your data integration and management. Our team of experts will be ready to answer your questions and guide you through the powerful KingswaySoft capabilities that can empower your business.
About KingswaySoft
KingswaySoft offers over 300 SSIS components that facilitate the most complex integration scenarios. These include data masking and anonymization, duplicate detection, data comparison, data profiling, advanced expression, encryption and compression, JSON & XML processing, SFTP/FTPS, and message queuing, to name a few. Many other premium components support in delivering a rapid ETL development experience using Microsoft Visual Studio and SQL Server Integration Services (SSIS) as the platform.
Our solution also includes support for connecting to NoSQL databases, cloud storage services, REST APIs, and virtually any other API or web service endpoint (SOAP or REST). Connectivity solutions are also available for facilitating data integration with enterprise applications such as Microsoft Dynamics 365, Active Directory, HubSpot, Microsoft SharePoint, Salesforce, and many more. Similarly, REST connections are available for numerous applications, including LinkedIn, Facebook Messenger, Acumatica, Zoom, Shopify, ServiceNow, and Zendesk, to name a few.
KingswaySoft Achieves Google Cloud Ready - Cloud SQL Designation
Oakville, ON, August 29, 2023 - KingswaySoft, a leading provider of integration solutions for many enterprise application systems, announced today that it has successfully achieved Google Cloud Ready - Cloud SQL designation for Cloud SQL, Google Cloud’s fully managed relational database service for MySQL, PostgreSQL, and SQL Server.
Google Cloud Ready - Cloud SQL is a new designation for solutions from Google Cloud’s technology partners that integrate with Cloud SQL. Through close collaboration with Google Cloud, KingswaySoft added support for Cloud SQL MySQL, PostgreSQL, and SQL Server into their solutions, refining existing functionalities for unparalleled performance. In addition, refined documentation is available on their website to ensure the smooth onboarding of mutual customers.
By earning this designation, KingswaySoft has validated, in collaboration with Google Cloud's engineering teams, that their products fulfill a core set of functional and interoperability requirements, making them optimal choices for seamless data migration and integration with Cloud SQL. This designation helps Google Cloud customers make confident decisions when choosing KingswaySoft's solutions for their ETL development to work seamlessly with Cloud SQL.
As part of this program, KingswaySoft will also work closely with Google Cloud partner engineering and Cloud SQL teams to deliver cutting-edge solutions for their clients.
“At KingswaySoft, we are delighted to be certified with the Google Cloud Ready - Cloud SQL designation. Our team diligently worked with the Google Cloud team to deliver the best integration solution possible for Cloud SQL. We will continue working with Google to provide robust and feature-rich solutions for our clients.”, said Daniel Cai, the Managing Director of KingswaySoft.
“The Google Cloud Ready - Cloud SQL designation recognizes partner solutions that have met a core set of requirements to ensure the best possible integration between the partner product and Cloud SQL,” said Ritika Suri, Director of Technology Partnerships at Google Cloud. “With KingswaySoft, customers can save time on evaluating new tools, and focus on building solutions using partner products that have been proven through a rigorous validation process to work optimally with Cloud SQL.”
To learn more about KingswaySoft’s expertise with Cloud SQL, visit. To learn more about Google Cloud Ready - Cloud SQL designation and its benefits, visit.
KingswaySoft is a leading integration solution provider that offers sophisticated software solutions that make data integration simple and affordable. Thousands of enterprise clients from over 100 countries rely on our no-code SSIS Integration solutions to integrate data with various application systems to drive business efficiency and leverage information assets.
KingswaySoft Achieves Google Cloud Ready - AlloyDB Designation
Oakville, ON, March 29, 2023 - KingswaySoft, a leading provider of integration solutions for many enterprise application systems, announced today that it has successfully achieved Google Cloud Ready - AlloyDB designation for AlloyDB for PostgreSQL, Google Cloud’s newest fully managed PostgreSQL-compatible database service for most demanding enterprise database workloads.
Google Cloud Ready - AlloyDB is a new designation for the solutions of Google Cloud’s technology partners that integrate with AlloyDB. These partners have closely collaborated with Google Cloud to add support for AlloyDB into their solutions and tune their existing functionality for optimal outcomes.
By achieving this designation, KingswaySoft has validated, in collaboration with Google Cloud engineering teams, that their products fulfill a core set of functional and interoperability requirements, making them ideal solutions for data migration and integration with AlloyDB. In addition, refined documentation is available on their website for ease of onboarding by customers. This designation helps Google Cloud customers make confident decisions when choosing KingswaySoft's solutions for their integration needs in order to work seamlessly with AlloyDB data.
As part of this program, KingswaySoft will also work closely with Google Cloud partner engineering and AlloyDB teams to further develop joint roadmaps and provide the best data integration solutions for their clients.
“At KingswaySoft, we are excited that our solution has been certified by the Google Cloud Ready - AlloyDB designation. During the process, our team had the opportunity to work with the Google Cloud team on the new database service offering, which has been proven to be incredibly capable and robust. We will continue working with them to provide the best integration solution to our clients.”, said Daniel Cai, the Managing Director of KingswaySoft.
“We’re delighted to recognize KingswaySoft with the Google Cloud Ready - AlloyDB designation,” said Ritika Suri, Director, Technology Partnerships at Google Cloud. “KingswaySoft’s integration with AlloyDB means users can expect a seamless experience in deploying and utilizing its data integration capabilities alongside AlloyDB.”
To learn more about KingswaySoft’s expertise with AlloyDB, visit. To learn more about Google Cloud Ready - AlloyDB and its benefits, visit.
KingswaySoft is a leading integration solution provider that offers sophisticated software solutions that make data integration simple and affordable. Thousands of enterprise clients from over 100 countries rely on our no-code SSIS Integration solutions to integrate data with various application systems to drive business efficiency and leverage information assets.
KingswaySoft Announces 2023 Release Wave 1
OAKVILLE, ON: March 17, 2023 - KingswaySoft Inc., a leading provider of data integration solutions, today announced its 2023 release wave 1 of their widely-used SSIS Integration Toolkit product family along with SSIS Productivity Pack and its real-time integration solution - KingswaySoft Integration Gateway. This new release is packed with over 265 new components, features, and enhancements, that are designed to help further improve ETL development and achieve more in complex ETL development projects.
More Power with the new SSIS Productivity Pack
- We have added support for Airtable, Authorize.NET, BambooHR, Duo Security, Emarsys, Google Calendar, Google Maps, OneLogin, Ping Identity, RingCentral, among many more new services.
- Our team has been working hard to bring you improvements to our REST Services, including Acumatica, Facebook, LinkedIn, ServiceNow, Shopify, Square, TikTok, WordPress, etc.
- We have made enhancements to the Premium ADO NET destination component so it now supports Bulk Update/Upsert/Delete and Full Sync actions against Oracle database when using the ODP.NET Managed data provider.
- We have added OAuth 2 support for SMTP and Email connection managers that use IMAP and POP3 protocols.
The Tableau Hyper components are SSIS message queue components that can be used to establish a connection with Tableau Hyper, read/retrieve data from Tableau Hyper, and write data to Tableau Hyper.
Couchbase components can be used to work with Couchbase, which is a popular NoSQL database engine. We provide support for both reading and writing which are facilitated by the Couchbase source and Couchbase destination components respectively.
The new Premium File Watcher Task component can be used to watch for changes in a file folder.
Greater Efficiency with Enhanced Data Integration Solutions
Below we would like to showcase a selection of noteworthy new features in our SSIS Integration Toolkits of our 2023 Release Wave 1:
What's New - SSIS Integration Toolkit for Microsoft Dynamics 365
We added support for outputting the results returned by the ExecuteWorkflowAction in the CDS/CRM destination component, and we have added support for the "Authorization Server URL" and "Use Integrated Authentication" options in the NAV/Business Central connection manager.
What's New - SSIS Integration Toolkit for Microsoft SharePoint
We added "Client Credentials using Custom App" OAuth Type support to SharePoint Connection Manager when working with the REST service endpoint. In addition, we have made various enhancements to the REST connections to make them more efficient, and at the same time, we have made various enhancements related to SharePoint view threshold restrictions.
What's New - SSIS Integration Toolkit for NetSuite
NetSuite connection manager now supports infinite timeout when the Timeout option is set to 0. Additionally, NetSuite API support has been updated to v2022_2.
What's New - SSIS Integration Toolkit for HubSpot
HubSpot destination component now supports creating or updating Contact, Company, Deal, Line Item, Product, Ticket, and custom objects with batch size. In addition, there is an enhancement to the HubSpot source component so that it no longer fails the SSIS data flow, but rather it would report a warning message in the SSIS log when reading using Search API has reached the maximum 10,000 records API limit.
What's New - SSIS Integration Toolkit for Salesforce
We updated the API support to version 57.0.
What's New - SSIS Integration Toolkit for QuickBooks
We have updated various metadata for Customer and Invoice objects when working with QuickBooks online. Additionally, we added QuickBooks SDK v16.0 support when working with QuickBooks Desktop.
What's New - SSIS Integration Toolkit for Directory Services
Generating OAuth token in Active Directory Connection Manager now supports modifying the OAuth scopes.
What's New - KingswaySoft Integration Gateway
We added support for SSIS Package outbound connection as an integration destination, so that it can trigger the execution of SSIS packages on incoming webhook events, which can facilitate a much smoother real-time integration experience. We have also added the capability to schedule SSIS package executions from within the gateway directly.
About KingswaySoft
KingswaySoft is a leading integration solution provider that offers sophisticated software solutions that make data integration simple and affordable. Thousands of enterprise clients from over 100 countries rely on our no-code SSIS Integration solutions to integrate data with various application systems to drive business efficiency and leverage information assets.
Learn more at www.kingswaysoft.com
Happy Holidays: A Look Back at 2022
We have reached the end of another year! At KingswaySoft, we would like to wish everyone Happy Holidays and a fantastic new year! As always, we are grateful for your continued support and the trust you have placed in us for another year with your data integration needs. This year, KingswaySoft continued growing with new talented team members, an expanded and enhanced product line, and exciting new partnerships. We also hope you had a productive and healthy 2022 and continue to streamline your data integration projects by leveraging the most sophisticated integration solution created by our team.
2022 Release Wave 1
In October 2022, we proudly announced our major release of the year, the 2022 Release Wave 1. This new version contains over 428 new components, features, and enhancements! We improved our Productivity Pack with new components, such as Azure Queue Storage, Google AlloyDB, and Kafka. Additionally, it now supports more than a dozen of new REST services, such as ChargeBee, Ceridian Dayforce, Auth0, Discord, Mailjet, ShipStation, and Typeform. For the SSIS Integration Toolkit for Dynamics 365, we introduced User Multiplexing support in CRM/CDS Connection Manager, which can help improve data load performance if used properly, and the CRM/CDS source component now supports multi-threaded reading when working with Audit Logs source type.
Branding Updates
This year, we launched a major update to our branding, in which we have adopted a new color schema for our logos. As part of the effort, we have revamped our website to give it a new look. In addition, with the 2022 Release Wave 1, our entire program received those branding updates in various UI elements. This visual refresh, with brighter colors and updated component logos, is one more step in our branding changes of 2022, which we hope makes your experience more enjoyable.
Nordic Summit
This year we also participated as a Silver Sponsor of the 2022 Nordic Summit. We were excited to be part of the event to showcase our integration solutions with the Power Platform and Dynamics 365 community.
Moving Forward
We look forward to the next year! Our team is already working on exciting new integration features and looking for opportunities to create more value for our clients. If you have any feedback on how we could simplify and make your ETL development more efficient, please do not hesitate to contact us to share your insights with our team.
We are thankful for the great year we just had and are ready for 2023! We want to thank all our clients and partners who trust us with our products to maximize their data efficiency.
The KingswaySoft team wishes you Happy Holidays and a fantastic new year!
KingswaySoft Announces 2022 Release Wave 1
OAKVILLE, ON: October 14, 2022 - KingswaySoft Inc., a leading provider of data integration solutions, today announced this year's new release of their widely-used SSIS Productivity Pack along with its SSIS Integration Toolkits. This version presents over 428 new components, features, and enhancements, which will increase efficiency and eliminate the complexity of your ETL development projects. Also, we added SSIS 2022 support across our products and from this version moving forward, only the 64-bit build will be available.
Our SSIS Productivity Pack just got a lot bigger!
- We have added support for ChargeBee, Ceridian Dayforce, Auth0, Discord, Expensify, Mailjet, Okta, Power BI, PrestaShop, among many more new services.
- Our team has made important enhancements to our REST Services, including Constant Contact v3 API support and Pardot v5 API support.
- We have added a "License" option in Address Verification Connection Manager when working with SmartyStreet service, which can be used to specify the license or licenses to use for the address verification process.
The Kafka components are SSIS message queue components that can be used to establish a connection with Kafka, read/retrieve data from Kafka, and write data to Kafka.
Okta components can be used to establish connections with an Okta-compliant broker, allowing you to read, deceive and send messages to it.
Power BI components allow you to easily achieve bidirectional integrations with Power BI. With this component, you can produce column data which then can be consumed by a downstream SSIS pipeline component.
Enhanced tools in our Data Integration Solutions
Below we would like to showcase a selection of noteworthy new features in our SSIS Integration Toolkits of our 2022 Release Wave 1:
What's New - SSIS Integration Toolkit for Microsoft Dynamics 365
We added User Multiplexing support in CRM/CDS Connection Manager, which can help improve data load performance if used properly. The CRM/CDS source component now support multi-threaded reading when working with Audit Logs source type. Also, The CRM/CDS source component has a new source type called Metadata which can be used to extract metadata (EntityMetadata, FieldMetadata, LookupMetadata, and OptionSetMetadata) from the system.
What's New - SSIS Integration Toolkit for HubSpot
HubSpot Source and Destination components now support working with "CRM Associations v4" object. We also added an 'excludeFilteredEvents' filter parameter in HubSpot Source component when reading from EmailEvents object.
What's New - SSIS Integration Toolkit for NetSuite
NetSuite Source/Destination component now show Script ID values in Columns page for custom fields. Additionally, NetSuite API support has been updated to v2022_1.
What's New - SSIS Integration Toolkit for Salesforce
We updated the API support to version 55.0. We also added support for working with a token file stored in Azure Blob Storage by specifying an Azure SAS URL as the token file path in Salesforce Connection Manager.
What's New - SSIS Integration Toolkit for QuickBooks
The QuickBook Source component now supports reading InvoiceLink data from Invoice object when working with QuickBooks online connection. Furthermore, we added "ClassRef" metadata fields to Item object when working with QuickBooks online environment.
What's New - SSIS Integration Toolkit for Directory Services
We added Case Insensitive Matching support when working with Manually Specified Keys in Active Directory Destination for Active Directory on-premises connection. Client Secret is now an optional property when generating Azure AD OAuth token in Active Directory Connection Manager.
What's New - SSIS Integration Toolkit for Microsoft SharePoint
We added support for the REST service endpoint in the SharePoint connection manager which provide some advanced integration features that were not possible using the SOAP service endpoint. Also, SharePoint service is now supported in Premium File System source/destination and Premium Properties Task components.
What's New - KingswaySoft Integration Gateway
We added Business Central and AS2 webhook support. We also added support for Kafka and Azure Queue Storage connections.
About KingswaySoft
KingswaySoft is a leading integration solution provider that offers sophisticated software solutions that make data integration simple and affordable. Thousands of enterprise clients from over 100 countries rely on our no-code SSIS Integration solutions to integrate data with various application systems to drive business efficiency and leverage information assets.
Learn more at www.kingswaysoft.com
Back to News