Oracle component release notes

This page lists the main features added to the Oracle Component.

Changelog

Version 2024.2.0

Features and improvements

  • DI-6371: Added support for using aggregation functions when Change Data Capture is active.

  • DI-7894: Template INTEGRATION Oracle: optimized NOT EXISTS uselessUpdate detection method with direct join when target column is not nullable.

Bug fixes

  • DI-8938: Template INTEGRATION Oracle: Fixed compatibility between the append integration strategy and the useDistinct option when calculating sequences on a target.

  • DI-9076: Added support for XML field types in database metadata and integration flows.

  • DI-9212: Fixed an issue which inserted a wrong number when copying an Int64 from MongoDB to Oracle Database.

  • DI-9232: INTEGRATION ORACLE TEMPLATE with CDC: fixed an issue which prevented INCREMENTAL_FLAG from appearing in a "group by" clause.

Version 2024.1.2

Bug fixes

  • DI-9076: Added support for XML field types in database metadata and integration flows.

Version 2024.1.1

Features

  • DI-7894: Template INTEGRATION Oracle: optimize NOT EXISTS uselessUpdate detection method with direct join when target column is not nullable.

Bug fixes

  • DI-8938: Template INTEGRATION Oracle: Fix compatibility between append integration strategy and useDistinct option calculating sequence on target.

Version 2024.1.0

Bug fixes

  • DI-7370: Remove AUTONOMOUS SQL transaction type, as it has no effect.

Version 2023.4.0

Bug fixes

  • DI-6672: Template Load Salesforce to Oracle: the error Unable to find class SForceToXmlActionCodeI is displayed when using this template.

  • DI-8061: Template INTEGRATION Oracle to File (SqlPlus): the "lineSize" option is miscalculated.

Version 2023.3.0

Bug fixes

  • DI-7829: Review the Oracle datatypes and their releated corresponding super types for consistency during datatype conversions.

Version 2023.2.0

Features

  • DI-7023: New Oracle NLS_Lang and Script File Encoding parameters added to the INTEGRATION Oracle to File (sqlplus) template named to control the charset of the output file by setting the NLS_LANG environment variable and defining the encoding of the SQL*Plus script.

Version 2023.1.10

New Features

  • DI-9076: Added support for XML field types in database metadata and integration flows.

Version 2023.1.9

Bug Fixes

  • DI-8938: Template INTEGRATION Oracle: Fix compatibility between append integration strategy and useDistinct option calculating sequence on target.

Version 2023.1.6

Bug fixes

  • DI-8061: Template INTEGRATION Oracle to File (SqlPlus): the "lineSize" option is miscalculated.

Version 2023.1.1

Bug fixes

  • DI-7132: In the INTEGRATION Oracle to File (sqlplus) template, the sort feature does not work.

Version 2023.1.0

Features

  • DI-4674: The Create indexes on Target Table parameter has been added to the INTEGRATION Oracle template.

  • DI-6021: An alternative template is now available to load a file into Oracle through a generic JDBC method instead of specific loaders.

  • DI-6537: The sorting feature has been added to the INTEGRATION Oracle to File (sqlplus) template.

Bug fixes

  • DI-5785: Temporary table names are unexpectedly truncated to 30 characters when using Oracle 12 or higher.

  • DI-5812: In the INTEGRATION Oracle template, the append mode creates and use an integration table for performance purposes.

  • DI-6020: The Purge Temporary Tables parameter is missing in some Oracle templates.

  • DI-6234: Some built-in templates cannot be saved after being modified and a NullPointerException is thrown.

Version 5.3.10 (component pack)

Bug fixes

  • DI-6702: Append mode does not work when reject control is enabled.

Version 5.3.10 (component pack)

Bug fixes

  • DI-6702: Append mode does not work when reject control is enabled.

Version 5.3.7 (component pack)

Features

  • DI-6021: Add an alternative template to load a file into Oracle through a generic JDBC method instead of specific loaders.

Bug fixes

  • DI-6020: The "Purge Temporary Tables" parameter is missing on some Oracle templates.

Version 5.3.6 (component pack)

Bug fixes

  • DI-5812: Template - INTEGRATION Oracle: Append mode should not create and use an integration table for performance purposes.

  • DI-5785: Temporary table names are unexpectedly truncated to 30 characters when using Oracle 12 or higher.

Version 3.0.0 (component pack)

Features

  • DI-4508: Update Components and Designer to take into account dedicated license permissions

  • DI-4727: Rebranding: Templates and sample projects

  • DI-4731: Rebranding: Template messages

  • DI-4962: Improved component dependencies and requirements management

Version 2.2.3 (Oracle component)

Features

  • DI-5024: Template - INTEGRATION Oracle - use md:paramValue() instead of ${}$ syntax

  • DI-5025: Template - INTEGRATION Oracle to File (Sqlplus) - Allow this template to be used with Transparent Staging Areas

Version 2.2.2 (Oracle component)

Features

  • DI-4811: New template INTEGRATION Oracle to File (Sqlplus)

Bug fixes

  • DI-4869: Template - INTEGRATION Oracle - "Error Log Prefix" parameter was ignored

Version 2.2.1 (Oracle component)

Bug fixes

  • DI-4835: Template - Integration Oracle - Creation of index on preintegration table should be done in the prepare step for performance and optimization purposes

Version 2.2.0 (Oracle component)

Features

  • DI-2719: Addition of some new datatypes In Oracle Metadata

Version 2.1.0 (Oracle component)

Bug fixes

  • DI-2529: Oracle Metadata - When adding a column in an Oracle Metadata, INTEGER type was missing

Version 2.0.6 (Oracle component)

Features

  • DI-2001: Oracle Metadata and INTEGRATION Oracle Template - Allow to specify an 'Error Log Mask mask in Metadata for the Error Log Table, and new parameters on integration Template to enable error logging

  • DI-2167: Template - INTEGRATION Oracle - support target tables with no source datastore

  • DI-2170: Template - INTEGRATION Oracle - New options deletionStrategy and deletionWhereClause

  • DI-2553: Template - Load Rdbms to Oracle (with Sql Loader) - add support for the STR clause in the CTL file, for specifying the rowSeparator

  • DI-2645: Template - Load Salesforce to Oracle - new dedicated optimized template to load data from Salesforce to Oracle (which uses sqlldr to improve performances)

Bug fixes

  • DI-2171: Template - INTEGRATION Oracle - Add missing space character before the Error Log Clause

  • DI-2552: Template - Load Rdbms to Oracle (with Sql Loader) - the datatype TIMESTAMP was unexpectedly producing a DATE clause

  • DI-2643: Template - Load Xml to Oracle - export boolean datatypes as numbers to load them properly in the load table which expects them as numbers

  • DI-2644: Template - Load Xml to Oracle - TIMESTAMP should be used instead of DATE in CTL file for timestamp fields

  • DI-2746: Template - LOAD Rdbms to Oracle (with SQL Loader) - generated temporary file names may unexpectedly contain object delimiters

  • DI-2778: Template - Staging Oracle as Table - "Transactional Mode On Work Tables" parameter does not work properly

  • DI-2820: Template - STAGING Oracle As Table - fix missing variable during code generation

Version 2.0.5 (Oracle component)

Features

  • DI-1772: INTEGRATION Oracle - New options to add Oracle Hints on select and update statements

  • DI-1788: Templates updated - support the "Default Table Storage Clause" and "Default Index Storage Clause" attributes which are defined in Metadata

  • DI-1912: Templates updated - support having CDC sources on Templates which were not supporting it (such as staging templates)

  • DI-1910: Templates updated - New parameter 'Cdc Subscriber' on Templates on which it was not handled yet

  • DI-1909: Templates updated - New Parameters 'Unlock Cdc Table' and 'Lock Cdc Table' to configure the behaviour of CDC tables locking

Bug fixes

  • DI-2961: Template - STAGING Oracle As Table - the Template did not support having different sets

  • DI-1907: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates when querying the source data

Version 2.0.4 (Oracle component)

Features

  • DI-2119: Oracle Component - update module definition to propose more accurate driver and urls

Version 19.0.25 (Designer)

Bug fixes

  • DI-1932: Oracle Component: Maximum VARCHAR2 size should be up to 32767 on Oracle 12 and above