Oracle Component Release Notes
New template Integration Oracle to File
A new Integration Template named "Integration Oracle to File (Sqlplus)" has been added.
This Template allows to generate a Flat File using SQL*Plus and provides usually better performances than Standard templates.
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.
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.
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.
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).
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.
Version 5.3.11 (Component Pack)
DI-6537: The sorting feature has been added to the INTEGRATION Oracle to File (sqlplus) template.
Version 5.3.10 (Component Pack)
Version 5.3.7 (Component Pack)
DI-6021: Add an alternative template to load a file into Oracle through a generic JDBC method instead of specific loaders.
Version 5.3.6 (Component Pack)
Version 3.0.0 (Component Pack)
Version 2.2.3 (Oracle Component)
Version 2.2.2 (Oracle Component)
Version 2.2.1 (Oracle Component)
Version 2.2.0 (Oracle Component)
Version 2.1.0 (Oracle Component)
Version 2.0.6 (Oracle Component)
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
Version 2.0.5 (Oracle Component)
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