As of our v20.1.0.1561 release, Our Magento toolkit has been deprecated in favor of our SSIS Productivity Pack. Please read details below.

Version 20.1 - June 5, 2020

This release comes with the following updates and enhancements:

  • Deprecation: Our Magento toolkit has been deprecated in favor of our SSIS Productivity Pack, which offers a much more sophisticated infrastructure to handle complex integration scenarios. You may continue to use the toolkit as long as you can live with the existing capabilities, however this version will be our last release of the Magento integration toolkit on its own, there will be no further enhancements or bug fixes offered going forward. SSIS Productivity Pack offers a collection of over 250 components which can significantly boost your SSIS ETL development productivity with Magento API support included through our REST component framework (including REST connection manager, REST source component, and REST destination component). Our API support in Productivity Pack comes with much greater flexibility. We highly recommend you upgrade before the toolkit stops working due to changes and evolvements of the API from the vendor side.

    Before finalizing the upgrade, we strongly recommend you complete the migration of your SSIS packages by downloading our SSIS Productivity Pack from its download page. Unfortunately, we don't have a tool that can convert the package automatically due to vast metadata differences between the two different products.

  • Enhancement: Magento Destination component now supports working with duplicate column names from upstream components as long as the columns are coming from different sources.
  • Enhancement: We have made some minor improvements in our retry implementation on intermittent errors.
  • Update: We have adopted a new versioning strategy in this release. From this point on, all future releases will be versioned as YY.ReleaseWave.ServiceReleaseNumber.BuildNumber, where YY is the year in two digits. This helps simplify our communications with partners and clients in terms of a particular toolkit installation's maintenance status among many other benefits. This is implemented across the board for all of our SSIS toolkits including SSIS Productivity Pack. All our current releases should have the same version number of v20.1.0 with a revision number between 1561 and 1565.
  • Update: We have introduced a new branding panel in our UI forms to distinguish our components from those out-of-box ones.
  • Update: We updated .NET framework requirement to v4.6.1 for SSIS 2012 and above.
  • Update: Our license manager program now requires .NET Framework 4.0 or above.

Version 4.1 - October 3, 2019

This release comes with the following updates and enhancements:

  • Enhancement: We have improved the quality of metadata in Magento Source and Destination components.
  • Enhancement: There are some updates to the License Manager program that provide better tracking of license installation and easier license management by our client services team.
  • Enhancement: Improved Azure SSIS-IR licensing to avoid unexpected unsuccessful activations upon restart.
  • Fixed: Batch Size may not work properly for some specific objects in Magento Source component.
  • Fixed: Secondary output in Magento Source component may not return any records for some specific objects.
  • Fixed: Magento Source component may report "Error reading JArray from JsonReader. Current JsonReader item is not an array: Null." error when the response body is text value 'null' while working with some specific endpoints.

Version 4.0 - February 21, 2019

This release comes with the following updates and enhancements:

  • New: We have added support for SSIS 2019.
  • New: Custom attribute fields can now be used in the destination.
  • Enhancement: Various UI enhancements and performance improvements.
  • Deprecation: We removed support for SQL Server 2005.

Version 3.1 - August 17, 2018

This release comes with the following updates and enhancements:

  • Enhancement: We have updated the license manager program to now report details of distinct connections in use.
  • Fixed: Our software may report a connection metering related error during runtime for some specific system environments.

Version 3.0 - April 26, 2018

This release comes with the following updates and enhancements:

  • New: We added a new option to the Magento Connection Manager - IgnoreCertificateErrors, which can be used to ignore any SSL certificate errors.
  • New: We added support for Azure-SSIS Integration Runtime (IR) deployment and licensing.
  • New: Standard use licensing model, this limits the number of distinct connections to 8 per connection type within a 24 hour period at runtime.
  • Update: We have an updated version of License Agreement that covers the new Azure-SSIS IR licensing model along with many other revisions - the new agreement becomes effective as of today (April 26, 2018).

Version 2.2 - December 14, 2017

This release comes with the following updates and enhancements:

  • Fixed: Magento Destination component may fail to detect body parameters for some objects.
  • Fixed: You may get "OutOfMemory" error when loading Magento metadata if the schema contains self-reference objects.
  • Update: Update of licensing component to better support servers within a clustered environment to minimize potential false licensing errors.

Version 2.1 - October 6, 2017

This release comes with the following updates and enhancements:

  • New: We added a "Store Code" option in Magento connection manager, which allows to get the corresponding REST schema for different stores.
  • New: We added a documentation generation button to all SSIS components that can be used to generate a Word document which describes the component's metadata including relevant mapping, and so on.
  • New: Connections to Magento server are now made with the latest and greatest TLS protocol whenever possible.
  • Enhancement: We improved the error handling when Authentication Token is empty.
  • Update: Some updates to the licensing component.

Version 2.0 - July 7, 2017

This release comes with the following updates and enhancements:

  • New: We added support for SQL Server 2017.
  • New: We added an expression button in Magento source component.
  • New: We added an expression button in Magento destination component.
  • Enhancement: Improved high-DPI support.
  • Enhancement: Some minor GUI improvements.
  • Enhancement: We added command line support for License Manager program
  • Update: We no longer deploy Newtonsoft.Json.dll assembly to Windows GAC.
  • Fixed: If you have an Ultimate trial license, it may still report as not licensed.

Version 1.0 - January 27, 2017

This is our first public release of SSIS Integration Toolkit for Magento software.

  • Three main components
    • Magento Connection Manager
    • Magento Source Component
    • Magento Destination Component
  • Support for SSIS 2016, 2014, 2012, 2008R2, 2008, or 2005
  • Support for the following three actions in Magento Destination Component
    • Post
    • Put
    • Delete