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: Oracle Eloqua Source/Destination component now uses v2.0 REST API when working with Emails object.
  • 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).
  • New: We added custom fields discovery support in Oracle Eloqua Source/Destination component.
  • 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

This release comes with the following updates:

  • New: We added a new action button in the KingswaySoft License Manager which makes it easy to request a free trial.
  • New: We added limited password attempts feature to Connection Managers that use OAuth token file. When the limit is reached, access_token and refresh_token values will be deleted from the token file, this is to protect the file from unauthorized use.
  • New: We added Bulk API support when reading Activities in Oracle Eloqua Source component.
  • New: Oracle Eloqua Destination component now supports an addition setting which can be used to specify the Sync Actions that occurs when bulk importing data (mainly contacts at this moment) to Eloqua system. Supported actions include add, remove, and setStatus.
  • Enhancement: Oracle Eloqua Destination component now retains input mapping when it is disconnected and re-connected from upstream components.
  • Fixed: You may get "The supplied DateTime represents an invalid time" error in Oracle Eloqua Source component when reading some special datetime values with Bulk API.
  • Fixed: Retry on intermittent Errors may not work properly for Oracle Eloqua connections.

Version 21.1 - May 28, 2021

This release comes with the following updates:

  • 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.
  • Fixed: "Could not create SSL/TLS secure channel" error in Oracle Eloqua Source and Destination components.
  • Fixed: You may get an intermittent error "The OracleEloqua object could not be found" when executing multiple Oracle Eloqua Source/Destination components in parallel.

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:

  • New: We added list metadata support when working with Contact Segment object in Oracle Eloqua Source/Destination component.
  • Enhancement: Oracle Eloqua 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 have switched to use token files instead of relying on Windows registry for better security and easier deployment.
  • 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: You may get a "The authorization code is incorrect, malformed, expired, or has been invalidated" error when generating Oracle Eloqua tokens should the authorization code contain a "+" character.

Version 3.1 - October 3, 2019

This release comes with the following updates and enhancements:

  • New: Connections to Oracle Eloqua are now made with the latest and greatest TLS protocol whenever possible.
  • 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: Upsert action in Oracle Eloqua Destination component may fail when IsSyncTriggeredOnImport column value is set to true.
  • Fixed: Add User ID (In App) may fail with 400 Bad Request error while establishing Oralce Eloqua connections if the authorization code returned from the server contains '+' character.
  • Fixed: You may get InvalidCastError when exporting tokens in Oracle Marketing Cloud Token Manager.

Version 3.0 - February 21, 2019

This release comes with the following updates and enhancements:

  • New: We have added support for SSIS 2019.
  • New: Search expressions can now be configured with a UI instead of text.
  • New: Types of string and numeric fields can now be toggled to different types in the destination.
  • Enhancement: Various UI enhancements and performance improvements.
  • Deprecation: We removed support for SQL Server 2005.

Version 2.1 - August 17, 2018

This release comes with the following updates and enhancements:

  • Enhancement: We improved the error handling when using Bulk API in Oracle Eloqua destination component.
  • 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 2.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: Updated the metadata for custom object.
  • Enhancement: We added command line support for Oracle Marketing Cloud Token Manager program.
  • Fixed: Bulk API may work improperly in Oracle Eloqua Source component.

Version 1.0 - December 14, 2017

This is our first public final release of SSIS Integration Toolkit for Oracle Marketing Cloud software.

  • Three main components
    • Oracle Eloqua Connection Manager
    • Oracle Eloqua Source Component
    • Oracle Eloqua Destination Component
  • Support for SSIS 2017, 2016, 2014, 2012, 2008R2, 2008, 2005
  • Support for the following four actions in Oracle Eloqua Destination Component
    • Create
    • Update
    • Upsert
    • Delete