Version 3.0 - August 10, 2016

This release comes with the following enhancements:

  • New: We added an Upsert action to Oracle CRM On Demand destination component, which allows to perform Update or Insert depending on whether a match can be found in the target system using defined matching criteria.
  • New: We added the option to enable or disable Oracle CRM On Demand destination component's default output columns (OracleCRMId, IsNew).
  • Enhancement: We enhanced the validation in Oracle CRM On Demand destination component as you may run into "The HTTP request did not contain a valid SOAPAction header." when an unsupported web service operation is selected.

Version 2.2 - May 5, 2016

This release comes with the following enhancements:

  • Enhancement: Updated support for the latest SQL Server 2016 release candidate builds.
  • Enhancement: Running the 32-bit installation package on a 64-bit operating system is now blocked, as doing so makes our connection manager unrecognizable in 64-bit runtime.
  • Enhancement: We removed the requirement of .NET Framework 3.5 SP1 for SSIS 2012 and later.
  • Fixed: When there are more than one source component in a data flow task, if the source components are reading from different objects, you get the "Namespace value in SOAPAction does not match Namespace value in xml tag". (Thanks to Steven for reporting this issue)

Version 2.1 - January 22, 2016

  • New: We added support for SQL Server 2016 (Visual Studio 2015 SSDT for design time).

Version 2.0 - September 15, 2015

  • New: We added support for child objects.
  • New: Added support for DeleteItem service API.
  • Enhancement: The license manager program now works in the system that has FIPS compliance policy enabled.
  • Enhancement: Some minor UI adjustments including positioning UI windows in the center of parent screens upon initialization.
  • Breaking Change: Decreased the default length of text field from 4000 to 255 to avoid potential errors you may receive when reading from a large number of columns in the Source Component.

Version 1.2 - June 9, 2015

  • New: We added support for SSIS Integration Toolkit - Ultimate Edition, you can now license all our SSIS Integration Toolkit products using one single license key.

Version 1.1 SR-1 - February 26, 2015

This release contains one minor update:

  • Update: The Oracle CRM On Demand connection manager can now handle special characters in its connection string.

Version 1.1 - December 12, 2014

This release comes with the following updates and enhancements:

  • New: We have added field filtering capabilities in Oracle CRM On Demand destination component, which include Hide Mapped Fields, Hide Unmapped Fields buttons, and a textbox that accepts a search string.
  • New: We have enabled the support of using SSIS variables for filters in Oracle CRM On Demand source component.
  • Update: We have disabled the use of SSL v3 due to its recently revealed security vulnerability.

Version 1.0 - October 9, 2014

This is our first public release of SSIS Integration Toolkit for Oracle CRM On Demand software.

  • Three main components
    • Oracle CRM On Demand Connection Manager
    • Oracle CRM On Demand Source Component
    • Oracle CRM On Demand Destination Component
  • Support for SSIS 2012, 2008R2, 2008, or 2005
  • Support for the following three actions in Oracle CRM On Demand destination component
    • Create
    • Update
    • Delete