Oracle Component Release Notes
This page lists the main features added to the Oracle Component.
Change Log
Version 2023.1.0
New 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)
New 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)
New 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