fixed

Template - Replicator Rdbms - the SQL query generated from the action "createIndexOnWorkTable" was incorrect, the schema name was unexpectedly doubled

fixed

Databases - A Foreign Key could not be created manually in a sub-Metadata File

added

Databases - review to display order of the various items such as datastores, columns, query folder, and more to make sure they are displayed in a comprehensive order in Designer

added

RDBMS databases technologies - new attribute "Technical Columns Prefix" available, which will be supported by Templates gradually

fixed

Metadata Products - "Explicit Join in Bracket" attribute which is defined in products should be displayed with "true" as default value in the interface when no value is set, as this is the value used behind the scenes by Designer when no value is defined

fixed

Temporary exchange files using XML format will now use XML 1.1 format to avoid issues with some special characters

fixed

Reject message for Not Null checks unexpectedly changed for database rejects, which could cause some misunderstanding

fixed

Template - Replicator Rdbms - Columns of work table in synchronization mode were not generated in the correct order in statements

fixed

Template - Replicator Rdbms - Incorrect delete statement generated when deleting from MySQL database

added

Concat Files Process Action - new parameter to choose the order in which the files are processed

added

Concat Files Process Action - when using append mode, a new additional parameter has been added to define if a separator should be placed or not between the concatenated files

added

Foreign Key - ability to select in the "referenced column" attribute, a column from a table which is on another schema

added

WSDL Metadata - support to alternatively define the Proxy settings through a proxy node from Proxy Metadata, and making it supported in Reverse REST Wizard

fixed

JMS Send Message From File Process Action - the display name has been modified to be coherent between the one displayed in the palette and the one defined when creating the action

fixed

Metadata - "CreationDdl" XPath expression does not produce the correct schema in foreign key reference clause

fixed

Reject constraints - "User Message", "Reject Code" and "Security Level" attributes have been moved back to standard tab for clarity and to make them also appear again in Mapping when consulting constraint properties

added

XML and JSON Metadatas - The new Property Field named "nodeAbsolutePosition" has been added

added

XML and JSON Metadatas - The new Property Field named "nodeUUID" has been added

added

File Metadata - definition of which property fields can be used as source or target

added

File Metadata - A list of possible values for “Property field” has been added in new attribute named Property to allow user to select value he want to use

added

File Metadata - ability to sort data when writing files through a new Property Field named "sortKey", which supports SORT_DESC and SORT_ASC tags to define the sort order

added

NTLM Authentication - adding a dedicated wizard on NTML security node, and support NTLM security node in HTTP Security Metadata

added

SQL File Export Process Action - new value available for "generate header" parameter to allow indicating that the header should always be added (even in append mode)

added

SQL File Export Process Action - A new parameter named "SQL_EXP_STRING_DELIMITER_REPLACEMENT" has been added to allow to replace the string delimiter that is found inside the data when exporting data to file

added

SCP Actions and SSH Metadata - Added a new "SSH Additional Connection Properties" parameter to define specific connection properties

added

Template - Integration Rdbms to XML - The WRITE_KEY_VALUES parameter uses a reference: this is changed to an XPath retrieving the parameter value, to allow overriding this value from other Templates which are reusing it

added

XML Metadata - generation of XSD file is now in a dedicated wizard named "XSD Generation Tool"

fixed

JSON Property fields - the "nodeName" property field was not appearing in some other Metadata which are reusing JSON technology, such as HTTP REST Metadata

fixed

LOAD Xml to Rdbms Template : correction of the error message "Unable to load class: com.stambia.avro.reader.visitor.AvroDatatTypeConverter" with Avro

added

Mapping technology (map.tech) - support cdcMaxTimestamp option

added

Mapping technology (map.tech) - New parameter on XPath function tech:workName() which is available on steps to be able to enabled / disable object delimiters

fixed

Mapping technology (map.tech) - Staging Mask was not working when using [sessionTimestampName] on a database which has object name truncation size

fixed

Template - Unload Rdbms To File - fix split column prefix which is incorrect when mapping is multi-target

fixed

Template - UNLOAD Rdbms to File - generated temporary file names may unexpectedly contain object delimiters

fixed

Template - Load Rdbms to Rdbms - Index names should not contain a schema on some target databases (such as MySQL)

added

Databases - A new attribute named "Report Schema" have been added

added

Email Metadata and Send Email Process Action - A new key/ value attribute is added on Outgoing Server to define extra connection properties

added

Template - Load Xml To Rdbms - support custom loading mechanism with streamHook

added

Template - Integration Rdbms to Xml - Improved WRITE_KEY_VALUE parameter to be reusable when this Template is used in another Template

fixed

INTEGRATION Rdbms to Wsdl - The expression to get the Metadata attribute "Send Client Credential" has been corrected to be passed properly to the Template

fixed

Read Email Process Action - MAIL_EXTRA_PROPERTIES was ignored during read email action.

fixed

Send Mail Action - Added a new "Mail content file encoding" parameter to define the encoding to use to read the content of the file specified by the "Mail content file" parameter

added

Add a tooltip on "Enable CDC" attribute of an Rdbms column

added

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

added

INTEGRATION Rdbms to Rdbms (no load) - Addition of a new parameter "Fetch size" to configure the number of lines of each fetch of data when querying the source database

added

INTEGRATION File (FileExport) Template - new parameter to alternatively define the string delimiter as character instead of hexadecimal representation

added

INTEGRATION Rdbms to Rdbms (no load) - Addition of a new parameter "Split Parallel Degree" to enable parallel loading of source data

added

INTEGRATION File (FileExport) Template - the default numeric format specified on Metadata is now used automatically to define the numeric format used by the Template, and a new parameter on the Template allows to override it

added

Mapping generation (map.tech) - CDC improvement - tech:hasCdc() XPath function now supports defining a custom "sourceSetName", which will, most notably, allow the support of CDC on Mapping stages

added

Mapping generation (map.tech) - CDC improvement - new XPath function has been added on a step to improve the retrieval of CDC filter part (tech:cdcFilterPart2())

added

Mapping generation (map.tech) - CDC improvement - The test to generate the CDC Filter part on a source now also checks the fact that a CDC source exists

added

RDBMS databases Metadata - new attributes "Default Table Storage Clause" and "Default Index Storage Clause" on temporary objects tab

added

Support in product definition to define a new group by syntax using aliases

added

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

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

TOOL Ldap Extractor (search) - new parameter 'attributesFormattedAsSidString'

added

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

added

UNLOAD Rdbms to file supports defining if boolean values should be exported as numeric values or boolean values

added

UNLOAD Rdbms to File: add support for split

added

Web Services invocation - addition of new attributes in Metadata and Templates to declare a Connection Timeout and a Read Timeout

added

WSDL Metadata - Remove the name attribute on Fault node which is not required anymore, to have a consistent behaviour with Input and Output nodes which does not have name attribute either

added

Web Service authentication with OAuth2 - a new parameter named "Send Client Credentials" has been added to define how client id and client secret should be sent, with the support of a new mode to send them in Basic Auth header

fixed

INTEGRATION File Template - when using "generate header" parameter alongside with "truncate=true" and "line separator=after", the generate header line was unexpectedly missing a line separator after it

fixed

INTEGRATION HSQL - lock and Unlock CDC steps should be executed only on sources which are not loaded through a load step

fixed

INTEGRATION Hsql - 'Append Mode' parameter is ignored in some situations

fixed

Mapping generation (map.tech) - CDC improvement - Mapping stages were not taken into account by tech:hasCdcSource(), leading to issues when working with CDC

fixed

Mapping generation (map.tech) - CDC improvement - unable to distinguish directly journalized sources and sources involving journalization, which can lead to CDC actions being executed in some situations while they shouldn't

fixed

SSH Metadata - [techCode] and [productCode] XPath functions were unexpectedly returning "FTP" instead of "SSH"

fixed

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

fixed

Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates on Lock / Unlock CDC steps

added

Email Metadata and Read Email Process Action: on Incoming account, new attribute to provide additional key / value connection properties

added

Mapping Transparent Stage - support using transparent stage feature with "Integration Rdbms to Wsdl" Template

added

New Process Action "Raise Error" available to raise an error with a defined message

added

SQL To Parameters Process Action: a sample script is now provided in the body when creating the action