2.2.3 (Oracle Component)

    Download
  • added

    Template - INTEGRATION Oracle - use md:paramValue() instead of ${}$ syntax

  • added

    Template - INTEGRATION Oracle to File (Sqlplus) - Allow this template to be used with Transparent Staging Areas


    • 2.2.2 (Oracle Component)

    Download
  • added

    New template INTEGRATION Oracle to File (Sqlplus)

  • fixed

    Template - INTEGRATION Oracle - "Error Log Prefix" parameter was ignored


    • 2.2.1 (Oracle Component)

    Download
  • fixed

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


    • 2.2.0 (Oracle Component)

    Download
  • added

    Addition of some new datatypes In Oracle Metadata


    • 2.1.0 (Oracle Component)

    Download
  • fixed

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


    • 2.0.6 (Oracle Component)

    Download
  • added

    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

  • added

    Template - INTEGRATION Oracle - support target tables with no source datastore

  • added

    Template - INTEGRATION Oracle - New options deletionStrategy and deletionWhereClause

  • added

    Template - Load Rdbms to Oracle (with Sql Loader) - add support for the STR clause in the CTL file, for specifying the rowSeparator

  • added

    Template - Load Salesforce to Oracle - new dedicated optimized template to load data from Salesforce to Oracle (which uses sqlldr to improve performances)

  • fixed

    Template - STAGING Oracle As Table - fix missing variable during code generation

  • fixed

    Template - Staging Oracle as Table - "Transactional Mode On Work Tables" parameter does not work properly

  • fixed

    Template - LOAD Rdbms to Oracle (with SQL Loader) - generated temporary file names may unexpectedly contain object delimiters

  • fixed

    Template - Load Xml to Oracle - TIMESTAMP should be used instead of DATE in CTL file for timestamp fields

  • fixed

    Template - Load Rdbms to Oracle (with Sql Loader) - the datatype TIMESTAMP was unexpectedly producing a DATE clause

  • fixed

    Template - INTEGRATION Oracle - Add missing space character before the Error Log Clause

  • fixed

    Template - Load Xml to Oracle - export boolean datatypes as numbers to load them properly in the load table which expects them as numbers


    • 2.0.5 (Oracle Component)

    Download
  • added

    INTEGRATION Oracle - New options to add Oracle Hints on select and update statements

  • added

    Templates updated - support the "Default Table Storage Clause" and "Default Index Storage Clause" attributes which are defined in Metadata

  • added

    Templates updated - New Parameters 'Unlock Cdc Table' and 'Lock Cdc Table' to configure the behaviour of CDC tables locking

  • added

    Templates updated - New parameter 'Cdc Subscriber' on Templates on which it was not handled yet

  • added

    Templates updated - support having CDC sources on Templates which were not supporting it (such as staging templates)

  • fixed

    Template - STAGING Oracle As Table - the Template did not support having different sets

  • fixed

    Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates when querying the source data


    • 2.0.4 (Oracle Component)

    Download
  • added

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