SSIS Integration Toolkit for Oracle CRM On Demand

Version 24.1 - June 12, 2024

The following are the updates and enhancements made for each group of components:

• Update: We have introduced a newly designed exception message window for better usability.
• Enhancement: Some additional DPI display optimizations to various forms.

Version 23.2 - Semptember 7, 2023

This release comes with the following updates:

• Update: We have made various UI alignment and spacing related corrections in the Oracle CRM On Demand connection manager UI.
• Update: We have removed SSIS 2008 (Including SQL Server 2008 R2) support.
• Enhancement: We have some updates to the License Manager program UI to make it more responsive to changes made to the license installation in the background.
  

Version 23.1 - March 17, 2023

This release comes with the following updates - Note that this will be our last version that supports SSIS 2008 (SQL Server 2008):

• Update: The auto-update form now displays a warning message about required maintenance for software upgrade.
• Update: We have removed the dependency on Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll assembly.
• Fixed: KingswaySoft License Manager might report an incorrect grace period when the license is running under the grace terms.
• Some other general updates.

Version 22.1 - October 19, 2022

This release comes with the following updates:

• New: We have added support for SQL Server 2022 (SSIS 2022).
• Enhancement: We have updated the license manager program to make it more resilient in obtaining new license files or renewals should there be intermittent networking issues. The enhancement mainly applies to unattended license requests or updates using command line via Windows script, it is particularly helpful when you run our software on Azure SSIS IR as it involves license activation requests each time when the instance is started or restarted.
  
• Update: The entire program has received some major branding updates in various UI elements.

Version 21.2 - November 11, 2021

The following are the updates and enhancements made for each group of components.

• New: We added a new action button in the KingswaySoft License Manager which makes it easy to request a free trial.
• Enhancement: We now provide a fallback support for any custom WSDL files installed in the system from previous versions.

Version 21.1 - May 28, 2021

The following are the updates and enhancements made for each group of components.

• New: We now ship a new console version of KingswaySoft License Manager program which is designed to work more reliably in a container environment.
• New: KingswaySoft License Manager program now always uses a secure service endpoint for activation and deactivation requests.
  

Version 20.2 - November 4, 2020

This release comes with the following updates:

• New: KingswaySoft License Manager now includes the ability to show and copy the LicenseId within the program which can be used for renewal purposes without having to reveal the full license key details, for instance, if a third-party reseller or agent is involved.
• New: KingswaySoft License Manager program now offers a link in the UI to help renew license maintenance or subscription with one single click.

Version 20.1.0 - June 5, 2020

This release comes with the following updates and enhancements:

• Enhancement: Various UI enhancements.
• Enhancement: Oracle CRM On Demand 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 improvement with our retry implementation.
• 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: Oracle CRM On Demand components no longer retry on 500 Internal Server Error when a soap:Fault message is reported.
• 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.
• Fixed: The default output may contain those records that have failed when performing Upsert action in Oracle CRM On Demand Destination component.

Version 7.1 - October 3, 2019

This release comes with the following updates and enhancements:

• Enhancement: Enhanced error handling when an unsupported WSDL file is used in Oracle CRM On Demand Source/Destination component.
• 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 activation upon restart.

Version 7.0 - February 21, 2019

This release comes with the following updates and enhancements:

• New: We have added support for SSIS 2019.
• Enhancement: Various UI enhancements and performance improvements.
• Deprecation: We removed support for SQL Server 2005.

Version 6.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 6.0 - April 26, 2018

This release comes with the following updates and enhancements:

• 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).
• Enhancement: Some improved UI performance.
• Enhancement: Improved high-DPI support.
• Fixed: You may run into "500 Internal Error" error if there are duplicate input fields when working with Oracle CRM On Demand destination component.

Version 5.1 - October 6, 2017

This release comes with the following updates and enhancements:

• 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 Oracle CRM On Demand are now made with the latest and greatest TLS protocol whenever possible.
• Enhancement: Some improved UI performance.
• Fixed: Editor could take a long time to load for certain source objects.
• Update: Some updates to the licensing component.
  

Version 5.0 - July 7, 2017

This release comes with the following enhancements:

• New: We added support for SQL Server 2017.
• New: We added an expression button in Oracle CRM On Demand source component.
• New: We added an expression button in Oracle CRM On Demand destination component.
• Enhancement: Improved high-DPI support.
• Enhancement: Some minor GUI improvements.
• Enhancement: We added command line support for License Manager program
• Fixed: If you have an Ultimate trial license, it may still report as not licensed.

Version 4.0 - March 15, 2017

This release comes with the following enhancements:

• New: We added an "Output Timezone" option in Oracle CRM On Demand source component, which can be used to specify the timezone of datetime fields' output.
• New: We added an "Input Timezone" option in Oracle CRM On Demand destination component, which can be used to specify the timezone of input datetime values.
• New: We added a ProxyMode option to Oracle CRM On Demand connection manager, which now supports three types of proxy mode: No Proxy, Auto-detect and Manual.
• Update: We have an updated license agreement.

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