Oracle Component Release Notes
This page lists the main features added to the Oracle Component.
Feature Highlights
Version 2.2.2
Version 2.2.0
Addition of datatypes
Some new datatypes have been added, such as BINARY_DOUBLE, BINARY_FLOAT, CHARACTER, CHARACTER VARYING, CHAR VARYING, DECIMAL, DOUBLE PRECISION, NATIONAL CHAR, NATIONAL CHARACTER, NATIONAL CHARACTER VARYING, NATIONAL CHAR VARYING, NCHAR VARYING, NUMERIC, UROWID
Most of them are aliases of existing datatypes.
Version 2.0.5
INTEGRATION Oracle Template
Two new parameters have been added to define Oracle hints to be added to generated select and update statements:
-
Target Update Hint
-
Target Select Hint
Temporary Objects Storage clause
In Oracle Metadata, two new attributes have been added in the "Temporary Objects" tab on a schema.
They allow to specify additional table storage clauses which will be added to the statements generated for temporary objects.
For Oracle, this allows to define for instance a custom tablespace to be used for the temporary objects.
The new attributes are the following:
-
Default Table Storage Clause
-
Default Index Storage Clause
Example of tablespace definition:
Change Data Capture (CDC)
Multiple improvements have been performed to homogenize the usage of Change Data Capture (CDC) in the various Components.
Parameters have been homogenized, so that all Templates should now have the same CDC Parameters, with the same support of features.
Multiple fixes have also been performed to correct CDC issues. Refer to the changelog for the exact list of changes.
Version 2.0.4
JDBC Drivers classes and URLs
Prerequisites \ Stambia DI Designer 2020 (S20.2.0) or higher |
Stambia DI Designer 20.2.0 introduces an improvement which allows Components and Modules definition to provide themselves the proper JDBC drivers classes and URLs, for the connection wizard to automatically adapt depending on the Module selected.
This Component has therefore been updated to take into account this improvement and provide the necessary JDBC drivers classes and URLs information.
Version 2.0.2
Maximum VARCHAR2 size
From Oracle V12, the size of VARCHAR2 type fields is no longer limited to 4000 characters.
Define the Oracle Version on your Metadata, in the "database major version".
If this version is less than 12 or empty, the size remains limited to 4000.
If this version is greater than or equal to 12, the size is no longer limited (up to 32,767 characters maximum).
Version 2.0.1
Fix an issue with creation mask for VARCHAR2 and CHAR datatypes
Creation mask for VARCHAR2 and CHAR datatypes should use 'CHAR' as character type when no information is provided.
Now when loading data into Oracle from any source, if there is no character type information defined on the sources Metadata, the columns created using the creation will use "CHAR" as character type instead of specifying an empty value.
For instance: mycolumn VARCHAR2(255 CHAR) instead of mycolumn VARCHAR2(255)
This will make sure the same character type is used when no information is provided instead of relying on the database default value which may vary between databases configuration and which can cause issues.
Change Log
Version 2023.1.12
Version 2023.1.0
Feature improvements
-
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)
Feature improvements
-
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)
Feature improvements
-
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