Oracle component release notes

DI-9382: Template LOAD File to Oracle: fixed an issue that generated an incorrect Oracle control file when not all source columns are mapped.

DI-9617: Optimized the queries for CDC Data View and CDC Lock View to speed up reads from CDC tables.

DI-6933: Added a new deserializer template: DESERIALIZER Oracle String as Json.

DI-9616: Template INTEGRATION Oracle: fixed an issue that stopped target indexes from being created in a target schema.

DI-9856: Fixed an issue that prevented Salesforce integrations from recognizing OAuth2 JSON properties.

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.

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.

DI-9382: Template LOAD File to Oracle: fixed an issue that generated an incorrect Oracle control file when not all source columns are mapped.

DI-9617: Optimized the queries for CDC Data View and CDC Lock View to speed up reads from CDC tables.

DI-9616: Template INTEGRATION Oracle: fixed an issue that stopped target indexes from being created in a target schema.

DI-9856: Fixed an issue that prevented Salesforce integrations from recognizing OAuth2 JSON properties.

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

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.

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

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

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

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

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.

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

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.

DI-9382: Template LOAD File to Oracle: fixed an issue that generated an incorrect Oracle control file when not all source columns are mapped.

DI-9617: Optimized the queries for CDC Data View and CDC Lock View to speed up reads from CDC tables.

DI-9616: Template INTEGRATION Oracle: fixed an issue that stopped target indexes from being created in a target schema.

DI-9856: Fixed an issue that prevented Salesforce integrations from recognizing OAuth2 JSON properties.

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

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.

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

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

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

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

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.

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.

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

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

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

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

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.

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

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

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

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

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

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

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

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)

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

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

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

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

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