Oracle component release notes

DI-11707: Increased the default maximum size for Oracle Database column and datastore names to align with recent Oracle releases. The update increases the default size to 128 characters from 30 characters.

DI-11491: Fixed an issue that broke mappings to older Oracle versions when having to truncate temporary table names.

DI-11009: Fixed an issue that created incorrect types when reverse engineering timestamp fields from Oracle databases.

DI-9032: Template LOAD File to Oracle (with Loader): updated the template to use mapping filters to filter the load with WHEN clauses.

DI-9384: Template LOAD File to Oracle (with Loader): added the ability to specify a separated directory for ctl/log/dsc/bad/out temporary files.

DI-9532: Template INTEGRATION - Oracle to File (Sqlplus): added a useDistinct parameter.

DI-9533: Template INTEGRATION - Oracle to File (Sqlplus): added a header parameter.

DI-10951: Added a check for the maximum column name size depending on the Oracle Database version.

DI-9914: Fixed an issue that generated queries with placeholders instead of actual column names.

DI-10150: Template INTEGRATION Rdbms: corrected the template’s behavior so it avoids trying to create indexes on tables that already have one, which causes processes to fail.

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