SSIS Integration Toolkit Winter 2017 Release Wave 2

3/15/2017

OAKVILLE, March 15, 2017 - KingswaySoft Inc., a leading provider of data integration solutions, today announced a second Winter 2017 release wave of their SSIS Integration Toolkit. This Winter 2017 Release Wave 2 includes new components and enhancements to many of the toolkits within the SSIS Integration Toolkit including the SSIS Productivity Pack.

This second Winter 2017 Release Wave brings great enhancements to the SSIS Productivity Pack, SSIS Integration Toolkit for Salesforce, and SSIS Integration Toolkit for Microsoft SharePoint. It also includes enhancements to the Microsoft Dynamics 365, Marketo, HubSpot and Oracle CRM On Demand toolkits. As part of this release, the Microsoft OneDrive and Dropbox toolkits are now included within the SSIS Productivity Pack to bring further enhancements and functionality to the pack.

  • v3.0 of SSIS Productivity Pack
    • New Components
      • Along with the addition of the OneDrive and Dropbox integration components, this new release also introduced 9 other components to the SSIS Productivity Pack. These include support for more Message Queue services, MSMQ and RabbitMQ. We have also added our first in a line of NoSQL components with the introduction of our MongoDB integration components.
      • In total there are now 55 premium and unique components included within the SSIS Productivity Pack to help make SSIS more powerful, and bring more tools and potentials into the hands of developers.
    • New Enhancements
      • We've added new features to many of the existing components include support for more ADO.NET data providers in the Premium ADO.NET Source & Destination components. Added enhancements many components including Email Source, Premium Slowly Changing Dimension components and the FTPS and SFTP Connection Managers. Full details can be found within the release notes.
    • Read the full release notes here.
  • v7.0 of SSIS Integration Toolkit for Salesforce
    • Salesforce Wave Destination
      • We've added a new component to the toolkit which enables writing data into Salesforce Wave Analytics. With this destination component you will be able to perform, Append, Delete, Overwrite and Upsert operations to Salesforce Wave.
    • New Merge Action
      • We’ve added a new write action to the Salesforce Destination component, which allows you to merge two Salesforce Account, Contact, Lead and Person Account records.
      • This can be incredibly useful for cleaning duplicate data with the help of our Duplicate Detector found in our SSIS Productivity Pack.
    • Support for SQL Server 2008 R2 or earlier
      • With this release we have made it possible to continue using the SSIS Integration Toolkit for Salesforce with SQL Server 2005, 2008 or 2008 R2 even after TLS 1.0 has been disabled.
      • This fix was made possible due to a Windows hotfix which enables TLS 1.2 support in .NET Framework 3.5 (including .NET framework 2.0)
      • To use SQL Server 2008 R2 or earlier to integrate with Salesforce you will need our v7.0 of the SSIS Integration Toolkit for Salesforce and the appropriate Windows hotfix:
      • Note that no equivalent hotfix is available for Windows 10, Build 1507, an update of the operating system will be needed. The hotfix is built-in for Windows 10, Build 1607 and Windows Server 2016, therefore there is no need to install anything other than our latest release.
    • Read the full release notes here.
  • v5.1 of SSIS Integration Toolkit for Microsoft SharePoint
    • Added support for Audit fields which can be enabled for writing in SharePoint destination component.
    • The Source component now handles the situation when invalid XML characters are returned from SharePoint server if any such characters were previously saved in SharePoint.
    • Read the full release notes here.
  • v8.1 of SSIS Integration Toolkit for Microsoft Dynamics 365
    • Support added for the German CRM online region for selection in CRM connection manager.
    • Other enhancements and fixes to the CRM, NAV & AX components
    • Read the full release notes here.
  • v2.2 of SSIS Integration Toolkit for Marketo
    • A new Partition Name option in Marketo destination component, which can be used to specify lead partitions with Upsert action.
    • A new field called marketoGUID added to Lead Activities and Lead Changes objects within the source component and to the Custom Activities object in the destination component.
    • Read the full release notes here.
  • v3.0 of SSIS Integration Toolkit for HubSpot
  • v4.0 of SSIS Integration Toolkit for Oracle CRM On Demand

Back to News