The Ultimate Edition is a single license that allows you to download the SSIS Productivity Pack and any of our 16 SSIS Integration Toolkit without purchasing individual licenses for each. Since the Ultimate Edition is not a downloaded product, the following updates and enhancements provide a summarized changelog related to each of the SSIS Integration products available when you purchase the Ultimate Edition license.
- Dynamics 365 CE/CRM & CDS: We added an option called "Optimization on Source Duplicates" in CRM/CDS Destination component, which can be used to specify how you want to handle duplicates in your source data when perform Update/Upsert actions.
- Dynamics 365 CE/CRM & CDS: We added support for two new outputs in CDS/CRM source component when working with AuditLogs source type: Audit Details (Record Sharing) and Audit Details (Role Privileges).
- Dynamics 365 BC/NAV: We added Manually Specify matching criteria support when performing Update/Delete action in NAV Destination component.
Read More
- New API and service support - Azure Data Lake Storage, HDFS, AMQP, CosmosDB, Asana, Facebook Business, Infusionsoft, Microsoft Teams, MYOB, Twillio, Yammer, Zuora.
- Various major enhancements to the HTTP and JSON/XML components as well as Premium Derived Column, Premium ADO.NET, RabbitMQ, MongoDB, Premium File Pack and SFTP/FTPS components.
- A number of new spawn/anonymization types added to Data Spawner and Data Anonymizer components.
- Using Entities to create connected data with the Data Spawner and Data Anonymizer components.
Read More
v4.0 of SSIS Integration Toolkit for NetSuite
- NetSuite Source component now supports retrieving Saved Search without enabling Advanced option, which can be used to get full records result when executing a saved search.
- We added an option called "Override Search Columns" in NetSuite Souce component, which can be used to override existing search return columns with new search return columns when using saved search with Advanced option enabled.
- We added pagination support in NetSuite custom fields auto-detection by specifying page size and number of pages.
Read More
v11.0 of SSIS Integration Toolkit for Salesforce
- We added components for Salesforce Marketing Cloud: Salesforce Marketing Cloud Connection Manager, Salesforce Marketing Cloud Source, and, Salesforce Marketing Cloud Destination.
- We added support for REST API.
- We added a new default output column option called "UpdatedRelatedIds" in Salesforce Destination component, which returns the ID of all related records for the Merge action when using SOAP service endpoint.
- Various other enhancements.
Read More
v8.1 of SSIS Integration Toolkit for Microsoft SharePoint
- We added better support for SharePoint sites that use Modern Authentication.
- We added a new option called Authentication Cookie Name in SharePoint Connection Manager which can be used to set custom authentication cookie.
- We now support downloading the version history of files in Document Library in SharePoint Source component.
- We added retry support for 503 error from HTTP response.
Read More
v6.1 of SSIS Integration Toolkit for Directory Services
- New fields called MemberContainer and MemberType have been added to GroupMembership object in Activt Directory Destination component when working with On-Premises connection.
Read More
v4.1 of SSIS Integration Toolkit for Microsoft Dynamics GP
- We have improved error handling.
- Improved Azure SSIS-IR licensing to avoid unexpected unsuccessful activations upon restart.
Read More
v4.1 of SSIS Integration Toolkit for Microsoft Dynamics SL
- Improved Azure SSIS-IR licensing to avoid unexpected unsuccessful activations upon restart.
Read More
v7.1 of SSIS Integration Toolkit for HubSpot
- HubSpot Source component now supports retrieving property history when working with Contact, Company and Deal objects.
- We added support for working with Product and Line Item in HubSpot Source and Destination components.
- We added support for using My Own App in HubSpot Connection Manager.
Read More
v5.1 of SSIS Integration Toolkit for Marketo
- We added support to retrieve Marketo leads and Marketo programs by filterType and filterValues in Marketo Source component.
- We have added the ability to quickly toggle string, numeric and datetime fields to different types.
- Reading Marketo programs by tag now work properly in Marketo Source component.
Read More
v4.1 of SSIS Integration Toolkit for Magento
- We have improved the quality of metadata in Magento Source and Destination components.
- We fixed issues when Batch Size may not work properly for some specific objects in Magento Source component.
- We cleared bugs that arose when Secondary output in Magento Source component may not return any records for some specific objects.
Read More
v5.2 of SSIS Integration Toolkit for QuickBooks
- QuickBooks Source component now handles invalid emun values better when working with QuickBooks Desktop objects.
Read More
v3.1 of SSIS Integration Toolkit for Team Foundation Server
- The release provided enhanced licensing management and better Azure SSIS-IR support from licensing perspective like any other toolkits.
Read More
v7.1 of SSIS Integration Toolkit for Oracle CRM On Demand
- We enhanced error handling when an unsupported WSDL file is used in Oracle CRM On Desmand Source/Destination component.
Read More
v4.1 of SSIS Integration Toolkit for Microsoft Project Server
- We now support connecting to the Project Server environment that uses modern authentication.
Read More
v4.1 of SSIS Integration Toolkit for Xero
- We added support of Allocation action for Credit Notes object in Xero Destination component.
Read More
v3.1 of SSIS Integration Toolkit for Oracle Marketing Cloud
- We fixed an issue where Upsert action in Oracle Eloqua Destination component may fail when IsSyncTriggeredOnImport column value is set to true.
Read More
