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 theuseDistinct
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.1
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.7 (component pack)
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