fixed

Project Explorer - Some files was unexpectedly missing in the exported archive file after performing an "Export Models and Dependencies", when exporting a process containing a mapping with "Export built files" option checked

fixed

Preferences / JDBC Drivers - java.lang.ExceptionInInitializerError error is thrown when opening JDBC drivers preferences while the jdbc-odbc driver is not configured

added

JSON Component: New XPath function tech:fieldPath() to return the path of the current node

added

Mapping "tech:tag()" XPath expression has been updated, allowing a parameter to be taken into account to find if a given tag exists

fixed

Oracle Component: Maximum VARCHAR2 size should be up to 32767 on Oracle 12 and above

fixed

PostgreSQL Component: fix creation mask for BIT datatype which was not taking into account the size defined and CHARCATER VARYING datatype which should ignore sizes greater than 1000

fixed

SVN Subclipse installation: sample installation repository proposed has been replaced with the new repository location as the previous one is no longer available

fixed

Temporary objects names are not generated correctly when temporary objects masks contain Metadata Variables or Process Parameters in technologies where names are truncated automatically based on a size limit

fixed

Upgrade Mapping models context menu can unexpectedly break some Mappings in some rare situations where Internal Resources are not handled properly

added

Navigator: Runtimes refresh operation is now performed in background

fixed

Linux installation: stambia.ini file is wrong for linux environments

fixed

SQL Explorer: when performing a query which returns numeric values, a 'java.lang.NullPointerException:null' exception is thrown when there are null values in returned data

fixed

When adding a note on an Exist / Not Exist operator in a Mapping, the Mapping cannot be opened anymore, throwing a java.lang.ClassCastException error

fixed

ODBC: unable to execute Mappings / Processes which are using ODBC because exceptions are thrown at execution (such as "java.lang.UnsupportedOperationException" or "java.sql.SQLException: No suitable driver")

added

Amazon Redshift: new driver and JDBC URL example for Amazon Redshift JDBC driver which is now the default proposed driver

added

Generic technology: prefix element nodes name with its type in the editor for clarity and allow to reorder manually the element nodes between them

added

Improve XML datatype conversions

added

Remove Google Sheets Component from default installation, it is now shipped as an additional Component

added

Runtime View: when clicking on 'Runtime Editor' while the default localhost Runtime is selected, it now opens Runtime Metadata creation wizard

added

SQL Explorer: ability to specify in preferences the number of decimals to display when no decimal information is returned by the driver

added

SQL Explorer: ability to specify in preferences to trim additional zeroes in queries results

added

SQL Explorer: new entry in JDBC Drivers preferences for the new Google Sheet Component driver

fixed

A generation error might be thrown in some rare cases during generation because of XSL and XPath variables not being resolved properly, which leads to an error such as "Failed to evaluate [...]" when trying to generate a Mapping or Process

fixed

A Mapping located inside a project or a folder containing « & » in the name can unexpectedly be opened multiple times

fixed

Database Reverse Wizard: Configuration added on a property is not taken into account inside wizard

fixed

Designer Preferences: "Configuration > Runtime Configuration File" preference is unexpectedly updated with a path prefixed with a "/" when creating a new engine configuration file (conf.egc) in a workspace where there is no engine configuration file

fixed

Designer is not taking into account the changes of Process palette actions definition at start, forcing to perform a rebuild cache for them to be taken into account when installing a new version for instance

fixed

Expression editor: keyboard shortcuts for preparing / executing Mappings or Processes were not working when the focus was on Expression Editor

fixed

Enable Insert and Enable Update options on datastore columns might sometimes unexpectedly become enabled when saving Mappings generated from Migration Tools, whereas they were disabled before saving

fixed

Expression editor: syntax coloring and completion was missing on Mapping Computed Fields

fixed

Fix an issue where the Designer tries to build the same Mapping in an infinite loop

fixed

File Metadata and SQL Editor: when performing queries through SQL Editor on a File Metadata, using the "Execute SQL and display result in batch mode" button is unexpectedly producing "String index out of range: -1" error

fixed

Graphical glitch on target filters may happen when moving a datastore which is the source of target filter in a Mapping

fixed

IBM DB2 UDB / IBM DB2 UDB for zos / IBM DB2 400: generated truncate table statements are missing the IMMEDIATE keyword, which is causing errors when executing them

fixed

JDBC Wizard: when an error occurs while trying to connect through the wizard, the message returned might unexpectedly be "null" if the returned error has no associated message

fixed

JDBC-ODBC Bridge Wrapper: connecting multiple times to an ODBC datasource with the JDBC-ODBC Bridge Wrapper driver may unexpectedly return a "null null" error message

fixed

Metadata Editor: when performing an impact analysis through Impact View or through shortcut inside a Metadata Editor, the editor unexpectedly becomes dirty / unsaved

fixed

Mapping Outline Search: search by expression does not search in Computed Fields

fixed

Mapping Expressions source are not found when the full alias of a field contains ']' between double quotes

fixed

Metadata Editor: wrong layout on boolean attributes with default value

fixed

Mapping built reference files (*.map_ref files) might not be encoded in UTF-8

fixed

Mapping: when saving and executing a Mapping from Mapping Editor, the generated process unexpectedly closes if it is already opened

fixed

Oracle technology: creation mask for VARCHAR2 and CHAR datatypes should use 'CHAR' as character type when no information is provided

fixed

OAuth2 wizard: impossible to generate tokens with some application providers which return a warning about non-secure browser under windows

fixed

Parameters and Attributes documentation: pop-up window for tooltips should close automatically when moving the mouse out

fixed

Process parameter: in some situations, the value of a Process Parameter defined as list is displayed as a plain text value instead of a list of values in Properties View

fixed

Process Editor: bind links are unexpectedly not copied when copy / pasting multiple Process Actions at the same time

fixed

Runtime View: Runtimes defined through a Runtime Metadata are not ordered alphabetically in the list of Runtimes of the View

fixed

Runtime Metadata - Runtime defined through a Runtime Metadata do not appear in Navigator

fixed

SQL Explorer: fix an issue about queries which may result in out of memory exception with some JDBC Drivers when the query is returning decimals

fixed

SQL Explorer: the decimals of numeric fields are not displayed when performing queries on File Metadata

fixed

Technology development: INTERNAL_MAPPING_TYPE XPath expression should accept the same values as Mapping type property for clarity purposes

fixed

Unable to execute a Mapping in some situations despite the removal of all items with error inside it

fixed

When using a stage with custom datatypes on its fields, generated queries when retrieving stage data in a target datastore might be incorrect in some situations

fixed

When updating some information in Metadata and trying to use JDBC Wizards, modified values may not be taken into account by the Wizards if a connection was already created previously

fixed

XSL Variable visibility attribute is not taken into account

added

Ability to connect to HTTPS secured Runtimes

added

File technology : support xpath expression for adding delimiter around name

added

Google Sheet driver: support fetch mechanism when retrieving data

added

Google : Add Google Cloud Platform and Google Storage entry in Metadata List

added

Kafka : Add kafka entry in Metadata List

added

New md functions to process hierarchies and repeat strings

added

New options available to allow ignoring certificates checks when trying to connect to an HTTPS secured Runtime

added

New statistics for Google Storage tools

added

RDB technology: add reverse of indexes

added

XSL Transformation Process Action: support using custom session class loaders

fixed

Default JDBC Fetch Size defined in products is not taken into account

fixed

Microsoft SQL Server technology : temporary columns created with "binary" datatype are unexpectedly created with a size of "1" instead of real size

fixed

Oracle technology: when loading VARCHAR2 and CHAR columns the temporary tables columns may be created without specifying the CHAR or BYTE keyword when defining their datatypes

fixed

User Defined Functions : Unable to add product code on an implementation

fixed

Scheduler: schedules are not starting anymore, logging java.lang.NullPointerException in log files

added

Database Metadata: new xpath function and action to generate truncate table statement

added

File Metadata: Cp1252 charset is now included in the charset example list available in the wizard and in Metadata attribute

added

MySQL technology: reverse is now also retrieving Alternative Keys (unique constraints) and Indexes

added

Mapping generation supports a new internal mechanism for specifying that staging should be treated as table, in which case the table name will not be surrounded with parenthesis in next SQL queries "from" clauses

added

New Designer command lines are available for Package and Delivery operations

added

SQL File Export : New parameter (SQL Exp Enclose All Fields) to add String Delimiter to every fields

added

WSDL Metadata: new binding type "http:urlReplacementNotEncoded" available to send input parameters without encoding them

added

WSDL Metadata: new "Exchange File Path" attribute on operations to customize the temporary exchange file created at invocation

fixed

Authentication error did not display systematically with Runtime HTTP connections secured with user / password

fixed

An error icon and message should be displayed on Metadata files which contain invalid reference nodes

fixed

Adding / Removing “FORCE_LOAD” tag on a target datastore does not refresh the Templates selectors on the given datastore (Load Templates do not appear / disappear)

fixed

Connection information included in delivery should be computed from both rdbms mechanism and xpath mechanism

fixed

Fix potential memory leak

fixed

File Metadata: an error message should be displayed when the "core / position" attribute of a field is empty

fixed

Fix some cases where the Designer gets blocked indefinitely on an operation (deadlock)

fixed

It was unexpectedly possible to use "Build / advanced / build Metadata and Process" context menu on a Mapping with some crossref errors

fixed

Package Generation: when generating a multi-delivery Package, externalized metadata attributes indexes are incorrect in generated file

fixed

REST Wizard: the reverse page is empty when trying to reverse XML input / output structure on an operation which has already been reversed previously

fixed

REST Wizard: when reversing the output returned by a web service, output's Mime-Type value is not reversed properly

fixed

REST wizard: characters which are used in the "resource" part of the URL should be encoded

fixed

REST Wizard: when opening the REST Wizard on an operation which has already been reversed, the input Media Type should be filled automatically from the Metadata Value

fixed

REST Wizard: Media Type field should allow custom values

fixed

Runtime Editor: accessing the description unexpectedly enabled the save option, even if there was no change

fixed

Rest Wizard: A NullPointerException error message appears when creating an OAuth2 security Node from the Rest Wizard

fixed

Unable to execute an action which has been encrypted from the Designer

fixed

When building delivery using substitution mode, configuration attribute values with special characters are incorrectly generated in built delivery

added

Ability to communicate with Runtime through HTTP

added

Add the ability to specify SQL commands that are triggered each time a connection is initialized

added

About Stambia popup: ability to select and copy to clipboard the Designer version information

added

Ability to define custom xpath datastore expression in XSL function analyzing datastore structure

added

Ability to rename a Process Parameter and XSL Variable through F2 shortcut

added

Error message which is returned when generating a process which contains mutliple steps with the same name has been revised to be clearer

added

MySQL technology: charset of tables is now reversed

added

Metadata Editor: ability to enable / disable externalization of an attribute on multi nodes at the same time through multi-selection

added

Package generation: a manifest file containing information about the environment used to generate the Package is now included inside Package file

added

User Defined Functions: ability to use in function implementation another UDF from another UDF library

added

User Defined Functions: new attribute in Metadata to define the UDF librairies required by the current one

added

WSDL Metadata: new attribute on "WS Security" allowing to specify a raw wsse content

fixed

"gatherSingleBookmark" error is logged in Error Log View when doing operations (drag and drop, remove datastore, ...) in a newly created Mapping / Process

fixed

"Unhandled event loop exception" error is logged in Error Log View when clicking on a datastore which is inside a dataset containing joins with warning or errors

fixed

Build Package Command Line utility: build is failing when the designer path contains a space character

fixed

Deleting multiple datastores at once in Mapping through multi-selection might fail and produce UI issues in some cases

fixed

Delivery generation: when generating delivery multiline connection parameters values, special characters such as line returns are unexpectedly replaced by a space character

fixed

Generation issues in some cases when datastore name label starts with 'S' within a Mapping

fixed

Loading data into Salesforce "base64" fields is unexpectedly throwing an error because of an incorrect datatype conversion

fixed

Metadata editor: editor of unbounded multiline attributes should be a text area

fixed

Message Queue technology: password attribute should be defined as password type instead of string

fixed

Process Parameter Direct Edition should only allow modifying Parameter Name

fixed

Package Generation: when generating a multi-delivery Package, generated deliveries might be incorrect when they contain Mappings with stages

fixed

Runtime commands are not working when being used from Designer's Console View

fixed

SQL Explorer: default driver class name defined on Oracle Drivers should be oracle.jdbc.OracleDriver instead of oracle.jdbc.driver.OracleDriver which is deprecated

fixed

Unable to remove from a Mapping a field which does not exist anymore in the Metadata if the given field is used as source and target

fixed

When replacing a datastore reference in a Mapping through drag and drop, missing references on the new datastore are generated with an invalid internal URI which is missing the Metadata fileId

fixed

When using a Runtime Metadata on "Execute Delivery" Process Action, user and password attributes from Metadata should be used to define corresponding parameters values

fixed

When clicking on "License" in "About Stambia" popup generated file URL which is opened in a browser might be incorrect in some cases

fixed

When generating a multi-deliveries Package, User Defined Functions involved are not computed and not included in generated Package

fixed

When a stage field is mapped an orange asterisk icon should be displayed on the left of field icon

fixed

When changing field attributes in Mapping such as 'aggregate' or 'execute location' from context menu or quick tools buttons, the Properties View is not refreshed dynamically

fixed

When deleting from a Mapping a mapped field which does not exist in Metadata, Mapping might not be rebuild automatically when saving

fixed

Performing a generation operation from a Process Editor unexpectedly performs the operation on all the models selected in the project explorer instead of the actual Process Editor

added

When adding a parameter in a Process, the created parameter is now initialized with a default name

fixed

Change default Scripting Language selected when creating a Bean Scripting Process Action to "beanshell"

fixed

DB2-ZOS technology: add information about NULL keyword which should be used in select query

fixed

Launch Package Configuration: all Mappings / Processes include in a launch should be referenced by their internal id instead of their path to avoid issues when they are moved in the workspace

fixed

Process Parameters created on Process References or Mapping References should not be hidden by default

fixed

Sybase IQ and Sybase ASE should be renamed to SAP IQ and SAP ASE

fixed

Temporary object names are not generated correctly when table name contains Metadata Variables or Process Parameters in technologies where names are truncated automatically based on a size limit

fixed

Temporary Objects: "sessionTimestampName" mask should generate a name containing the target name whether a truncation size is defined or not

fixed

Unable to execute Mapping from Project Explorer when the active editor is a Process

fixed

When removing a stage with datatyped fields from a Mapping, built files corresponding to the stage are not removed

fixed

When clicking on a Mapping Reference inside a Process the Mapping is unnecessarily loaded in memory

added

Alternative XPath expressions added for retrieving NULL and NOT NULL keywords in DDL situations

added

File Metadata: new example charsets available in the wizard

added

File Metadata: charset name attribute is now a list of charset examples

added

File Metadata: new XPath function to retrieve the charset name specified on a file

added

Metadata Query Folder nodes can now be created also under schema nodes

added

New attribute and XPath expression available in Rdbms Technology Products to define NULL keyword to be used in select queries

added

New statistics for LDAP tools

fixed

As PostgreSQL's autocommit mode does not support defining a fetch size, select operations retrieving PostgreSQL data should not use autocommit mode to avoid memory issues while retrieving large sets of data

fixed

Cancel button when replacing a datastore in a Mapping does not work

fixed

Drag and dropping a Metadata node which name is not a QName inside a Process makes the Process unusable

fixed

ERROR_UDF_MISSING_PRODUCT_IMPLEMENTATION is unexpectedly displayed on expression when using a function on fields coming from a source dataset which also contains other technologies on which the function is not implemented

fixed

Informix technology: add information about NULL keyword which should be used in select query

fixed

JDBC Reverse: NullPointerException might be thrown while reversing tables when JDBC Driver does not return any data for Primary Keys or Foreign Keys

fixed

Metadata Editor: unable to order nodes of different types with drag and drop when they are defined with "Natural" order type

fixed

Metadata Editor: icons are not refreshed dynamically (when removing tags from a field for instance, tag icon does not disappear until Metadata Editor close)

fixed

Metadata Editor: nodes are not displayed in correct order when "Natural" order type is used

fixed

Metadata not externalized in Package when used in root Process Parameter

fixed

New attribute in rdbms technologies products to define how autocommit should be managed when performing select operations

fixed

Project Explorer: Mapping built objects should be hidden by default and have their own content filter entry in customize view menu

fixed

Schedule Editor: delivery input parameters do not appear on editor when opening an existing schedule

fixed

When an attribute or a node in a model is referencing another attribute or node of the same model using a full URI instead of a relative URI, the reference is unexpectedly indexed, which might cause issues in some operations such as managing duplicates

fixed

When Unsuccessful or Anyway links are used to link actions that have parallelized repetition queries the links are incorrectly generated in delivery, making then ignored at execution

fixed

When starting the Designer, Mappings which have changed on the file system since last launch are unexpectedly flagged as unbuilt instead of being rebuilt automatically

fixed

When copy / pasting a Mapping which contains a stage with datatyped fields, built files of the copy are not generated correctly

added

Add Snowflake entry in Metadata creation and Snowflake driver in default JDBC Drivers preferences

added

JDBC Reverse: new JDBC reverse mode for JDBC drivers which return information through a column index instead of a column label

added

New technology: DB2 UDB for Z/OS

added

When double clicking on an error / warning listed in Session Detail View, the popup which opens now displays the full stack trace of the error instead of only the error message

fixed

"Edition Mode" in Processes may be lost when navigating within Sub-Processes (making Expression Editor disabled whereas Edition Mode is still enabled)

fixed

Delivery Generation: when generating a delivery using a Sub-Metadata, attributes values are unexpectedly generated with Configuration value instead of empty value when the given parent attribute has a Configuration but no default value

fixed

Datastore layer selection popup on hierarchical datastores does not disappear when clicking outside of the popup

fixed

Informix technology: add missing datatype LVARCHAR

fixed

Menu Build/Execute > Publish > Delivery not always working when being used on a folder

added

Improve generation error message thrown when a requested Metadata is not found in the workspace

added

JSON Wizard: encoding is now set automatically to UTF-8 when not specified

added

JSON Reverse: revise the reverse mechanism to have better performances

added

JSON Wizard: a list of encodings is now proposed

added

Mapper improvements and fixes

fixed

"No more items are matching" popup should not appear when typing a value which returns no result in the search filter of Selective Reverse

fixed

Designer does not retrieve Template Parameters when opening for the first time a Mappings which have been migrated using Migration Tools

fixed

Delivery Generation: wrong link generated in delivery for a step which previous step is not generated

fixed

Generation is failing with java.util.NoSuchElementException when an execution condition which needs generation in its expression comes from a steps which is not generated

fixed

JSON Reverse: out of memory exceptions might be thrown when reversing huge files

fixed

JSON Reverse: exceptions are thrown when reversing a JSON which contains invalid XML characters

fixed

JSON Reverse: when there are null values in an array the reverse unexpectedly creates additional nodes for them

fixed

Metadata Editor: Configuration nodes listed under a configured node are not grouped together in some technologies

fixed

Oracle technology: foreign keys referencing unique constraint are not reversed

fixed

OAuth2 wizard: when clicking on finish some attributes are unexpectedly reinitialized to the default value (such as the "Flow Type" attribute when using "Implicit Grant")

fixed

Process editor: Actions / Sub-Processes / Mappings with repetition query are not resized when adding or removing Metadata Links / Process Parameters on them

fixed

Project Explorer: Mappings models contents should not be displayed under Mapping files by default

fixed

REST Wizard: Missing method PATCH in method list

fixed

Rest Wizard: menu to open the Rest Wizard should appear only in the Metadata Editor

fixed

REST Wizard: invocation might unexpectedly be performed twice when clicking on the run button

fixed

Template / Process Properties: vertical scrolling bar position unexpectedly lost and reset when the focus changes

fixed

Using a Metadata node with an invalid QName as datastore in a Mapping makes the Mapping unusable

fixed

When importing additional installed technologies from Internal Resources in the workspace the project in which they are imported might unexpectedly be different than "technology"

added

Ability to connect to Runtimes on which RMI is secured through TLS

added

Enable the Execute button of the main toolbar when a Mapping or Process editor is opened, even if the Mapping or Process is not the currently focused resource (when being in Expression Editor for instance)

added

Improve the error message which is returned when a User Defined Function is using in its implementation a parameter which has not declared

added

Metadata Creation Wizard: search is now also performed on the technologies categories

added

New shortcuts to Prepare and Execute a Mapping or Process: CTRL+ALT+P and CTRL+ALT+E

added

Normalize the temporary fields names (such as load fields) generated in Mapping built files to avoid unnecessary differences when re-generating deliveries multiple times

added

Normalize the steps ids generated in Mapping built files to avoid unnecessary differences when re-generating deliveries multiple times

added

Oracle technology: the PURGE keyword is now added to drop table statements by default, with an option on schema nodes to disable it if needed

added

WSDL Metadata: new OAuth2 parameters for the "Client Crendentials" and "Resource Owner Password Credentials" flows: "Send Client Id" / "Send Client Secret"

fixed

"java.lang.IllegalStateException" might be logged in Error Log View when clicking multiple times on an attribute in the "Externalize" tab of a Metadata

fixed

A more comprehensive error message should be thrown when using a Metadata which contains multiple Configuration nodes for the same configuration name

fixed

Copy-pasting objects in a Sub-Process Reference while in 'Enable Edition' mode will successfully duplicate these, but copies will unexpectedly not appear on the UI until the Sub-Process is saved

fixed

Delivery Generation: when there are multiple links between two same steps, only one of them is written in the generated delivery

fixed

Delivery generation: a NullPointerException is thrown when a disabled step with parallelized repetition query is linked to another disabled step

fixed

Deleting a Stage or Datastore which is used in a join might not unset the left right of the join, which may lead to graphical issues

fixed

Evaluating an XPath Expression from the contextual menu on the root node of a Sub-Metadata unexpectedly returns the value from the parent

fixed

Git Plugin: "Auto-ignore derived resources has encountered a problem" might be thrown when rebuilding mappings shared on git or when trying to ignore models

fixed

Metadata Reverse: when reversing comments, invalid XML characters should be automatically removed to avoid issues when saving the Metadata

fixed

Mapping Stage: if the name is not changed when renaming a stage field, the stage field name is unexpectedly suffixed with "_2"

fixed

Mappings which have been migrated using Migration Tools might be unexpectedly generated with multiple Templates with the same internal name when being saved for the first time

fixed

Normalize the ids generated for unbounded attributes (such as tags) in deliveries files to avoid unnecessary differences when re-generating them multiple times

fixed

Navigator: when creating a new schedule the execution mode of the schedule is greyed out and cannot be changed when another schedule already exist in the Runtime for any other delivery

fixed

OAuth2 wizard: the wizard should allow changing the HTTP method used to retrieve the token of "Client Credentials" and "Resource Owner Password Credentials" flows

fixed

OAuth2 wizard: typos in some of the descriptions

fixed

OAuth2 wizard: values defined for client_id and client_secret are unexpectedly ignored when being specified in the wizard of "Client Credentials" and "Resource Owner Password Credentials" flows

fixed

OAuth2 wizard: when using the wizard on an existing OAuth2 node which does not have a name, the wizard unexpectedly creates a new node when clicking on finish instead of saving information in the existing one

fixed

Package generation: some attributes might have an empty example value in the Package Configuration file when a sub-Metadata inherits externalized values from its parent

fixed

Rest Wizard: unable to parse JSON / XML response when the returned content-type is a specific content-type such as application/vnd.api+json

fixed

REST Wizard: invocation fails when working on an operation which uses an OAuth2 Security with "Client Credentials" or "Resource Owner Password Credentials" flows configured with "Send Client Id" and "Send Client Secret" options

fixed

Remaining temporary Mapping pre-build files should be removed at startup

fixed

Removing a datastore which has just been joined does not remove it from the Mapping and generates a NullPointerException in the Error Log View

fixed

REST Wizard: when specifying or updating "Security Reference" and "Security Proxy Reference" parameters, corresponding parameters in the Metadata are not updated when saving wizard modifications

fixed

Sub-Metadata: attributes which are not overridable but on which a value is manually set inside the Metadata file are not handled correctly: value returned by native evaluation and value displayed on the Designer are incorrect

fixed

Sub-Metadata: attributes which are not overridable but on which a value is manually set inside the Metadata file should be editable

fixed

Technology editor: when editing a technology file, shortcuts such as CTRL+C or CTRL+V cannot be used from the embedded properties

fixed

When an expression in a Mapping ends with a round bracket the whitespace characters that are used after the expression are deleted in the generated code

fixed

WSDL Reverse Wizard: some elements are not reversed when using multiple references on multiple targetNamespace

fixed

When drag and dropping a Metadata Variable on a Variable Manager action, the visibility of the Metadata Link created should be set on "parent"

fixed

XPath Native Evaluation unexpectedly fails when the list of elements returned contains attributes from which the type does not exist in the associated technology

fixed

builddelivery.bat / builddelivery.sh scripts: -extract option does not work on multi-deliveries packages

added

Add Designer Version and JVM Version on License Manager View

added

Build Mappings: performance improvements

added

Command Line utility: new command to automatically upgrade all the Mappings which are using an old model version within a specified workspace

added

Datatype conversion matrix now supports converting "integer" datatype to "bigint" datatype (conversion.xml file updated)

added

Delivery Preferences: Default "Output Level" has been changed from "Verbose" to "Info" to avoid overloading the console with debug logs which are not needed in common use, and which can temporarily lock the UI in some cases

added

Datatype conversion matrix now supports converting "string" and "varchar" datatypes to "longvarchar" (conversion.xml file updated)

added

Datatype conversion matrix now supports converting "decimal" datatype to "double" and "float" datatypes (conversion.xml file updated)

added

Mapping a stage field onto another stage field which is on another connection is now allowed if a datatype is specified on the target field and if it set on source location

added

Mappings which have an internal version prior to the current model version are now flagged as outdated

added

Memory management improvements on Build Mappings operations

added

Mapping: a new mapper utility has been added to ease the mapping of fields, available on the context menu of a field or when double clicking on a field

added

Memory management improvements on cache operations (such as rebuild cache)

added

Sybase ASE technology: new default JDBC driver entry for Jconn4

added

Sybase IQ technology: new default JDBC driver entry for Jconn4

fixed

"Errors Accepted" label should be the same on the editor button and in the Properties

fixed

A warning icon might unexpectedly appear on a Process Reference that has just been drag and dropped

fixed

ClassCastException might be thrown when using "suppr" key on a node in Metadata

fixed

Delivery Generation: connection parameters are not encoded correctly in the generated delivery

fixed

Expression Editor: some expressions make the editor unusable (unable to focus on it and use scrollbars)

fixed

Foreign Key Reference is not displayed when Referenced table is in another Metadata

fixed

File technology: columns whose name start with a number are not enquoted when used in a Mapping

fixed

Memory Leak issue when building the documentation of Processes / Mappings

fixed

Metadata Reverse: label of the reverse progress popup is incorrect at first reverse

fixed

Metadata Reverse: "Invalid thread access" Exception is logged in Error Log View when reversing items for the first time on a Metadata which has not been saved yet

fixed

Metadata Variable: using the ref:refresh() xpath function in a refresh query does not work

fixed

Memory Leak issue when upgrading Mapping models

fixed

Memory Leak issue during cache indexation

fixed

Metadata wizard: JDBC server wizard does not open when one of the JDBC Drivers configured in SQL Explorer Preferences cannot be instantiated

fixed

Opening a Mapping or Process which doesn't have a diagram while a "Build Mappings" job is running in the background unexpectedly blocks the Designer until the job is finished ("User Operation Is waiting" popup is displayed)

fixed

Oracle Technology: Unique Constraints should be reversed in Metadata

fixed

Oracle Metadata: the order of index columns is not respected when reversing indexes

fixed

Project Explorer: on Mappings having multiple stages with datatypes, only one stage Metadata is displayed under the Mapping tree

fixed

RDB technology: some datatypes are missing creation mask and super type, causing issues at table creation and datatype conversions

fixed

RDB technology: add missing datatype "DOUBLE"

fixed

Rest Wizard: when accessing the selective reverse, the page may be empty

fixed

REST Wizard: some nodes might unexpectedly be reversed without a name, leading to "Local Name cannot be null" errors at invocation

fixed

Sybase ASE technology: reversed datatype was incorrect when it was a user defined datatype

fixed

Sybase IQ technology: add missing datatypes BINARY and VARBINARY

fixed

Sybase ASE technology: add some missing datatypes

fixed

UDF are not detected in Mappings when they are preceded by special characters such as operators instead of a white space

fixed

Unable to build a Mapping using an UDF when it is preceded by an operator instead of a white space

fixed

Unable to build a Mapping using an UDF when the template is using the "tech:fullName()" xpath expression on the involved fields

fixed

When building a Package, necessary information about the User Defined Functions which are used by the Mappings / Processes are unexpectedly not included in the final Package, causing issues when trying to build Package's delivery from command line tools

fixed

When editing a JDBC Connection in Metadata, the title of the popup is incorrect ("Duplicate Connection Profile" instead of "Edit Connection")

fixed

When renaming a Project / folder / Mapping / Process / Metadata, some generated built files (such as .cross or datatyped stage Metadata files) are not moved

fixed

When changing the case of a Project / folder / Mapping / Process / Metadata, the built files for those are not renamed or moved correctly, which might lead to generation issues

fixed

When using a non-existing UDF in a Mapping, the error icon that should appear on the field to inform the user about the issue is unexpectedly not displayed

fixed

When modifying a Template Chooser (TPC) file, the changes might not appear in Mappings which were already opened during the modifications

fixed

When a Mapping Template was using the tech:workName('prefix','suffix') xpath function, the value returned was unexpectedly not containing the prefix and suffix specified

fixed

When saving a Mapping containing a datastore from a technology which cannot be found in the workspace, incorrect remove operations are performed on the Mapping, which can break the Mapping

fixed

builddelivery.bat / builddelivery.sh scripts generate incorrect deliveries when the Package is using User Defined Functions

fixed

indy.build is not created as a Linked folder when pasting a mapping in an empty project

fixed

"Failed to evaluate variable" exception randomly raised when generating packages or deliveries using XSL Variables in XPath and XSL modes

fixed

Build Package command line utility: unable to build individual packages

fixed

Build Package command line utility: unable to build multiple Launch at once

fixed

Build Delivery / Build Package: build duration is unexpectedly increased with the number of Metadata in the Workspace (the more Metadata there were in the Workspace, the more build duration was increased)

fixed

Build Package command line utility: unable to build Launch Packages on which "Generate Documentation" option is set to false

fixed

Build Package command line utility: unable to build multiple Package / Launch with documentation in the same build script

fixed

Metadata Move operation: impacted models which are modified with new references are not re-encoded properly when containing special characters

fixed

Memory Leak issue when indexing models, cross references were kept in memory instead of being persisted in files

fixed

Metadata Move operation: line returns contained in attributes values are unexpectedly removed from all the Metadata impacted by the Move

fixed

Multi-valuated Metadata attributes do not return any value at generation (E.g. Datastore "User Properties" attribute)

fixed

Mapping expression is not generated when containing an UDF preceded by a space character

fixed

Performance issues when indexing many models at once (E.g. when importing projects or fetching new models from versioning systems)

fixed

Unable to build a Mapping using an UDF which contains < or > characters in its implementation

fixed

builddelivery.bat / builddelivery.sh scripts do not handle correctly values from submetadata inherited from parent metadata, producing deliveries with incorrect values when a value is set on the parent metadata in the conf file

added

"Build/Execute > Build > Advanced" context menu is now available on project / folder / multi-selection

added

Metadata attributes which are not overridable should be disabled on Sub-Metadata Configurations

added

Metadata Move operation: Performance improvements on moving multiple nodes (multi-selection) from one Metadata to another

added

Performance improvements when building multiple Mappings at once

fixed

Build Documentation: building documentation of complex process takes a lot of time

fixed

Copy / Pasting a Mapping and its associated Metadata does not regenerate the references in the new Mapping's built Process

fixed

Datastore Columns from parent Metadata should not appear in columns selection lists in Sub-Metadata

fixed

Invalid thread access exception is thrown when reversing from Properties Popup

fixed

Metadata Reverse: Foreign keys are not referencing any columns when being reversed in a Sub-Metadata

fixed

Mapping expressions using XSL functions such as prefix::function are not correctly evaluated, causing generation issues

fixed

Metadata Reverse: when reversing foreign keys of a datastore, datastores on which they depend should also be reversed if they do not exist yet in Metadata

fixed

Metadata Reverse: Foreign Keys are unexpectedly referencing columns from the parent Metadata when being reversed in Sub-Metadata

fixed

Structure tab does not appear on the Properties View of Mapping Datastores / Fields / Stage Fields

fixed

The value returned by "md:formatDate" xpath function is incorrect

fixed

Unable to build a Mapping using an UDF which requires more than one Metadata Variable

fixed

Unable to build a Mapping when an expression contains extra space charaters before XSL functions such as prefix::function

fixed

Unable to build a Mapping containing an expression which has SQL comments containing bad syntaxes (Content of SQL comments should be ignored)

fixed

User Defined Functions: expressions containing UDF might not be correctly evaluated, causing empty expressions in generated Process

added

Create an Internal Expression to convert a Metadata Node into a key / value Java Properties string

added

Mapping tooltips: New "Problem" tooltip on Metadata Variable / Expression when there is a conflict of variable name because of UDF requirements

added

Metadata Reverse wizard: values in the Schema / Catalog combo-boxes are now sorted alphabetically

added

New preference to display the Mapping's Map / Join / Exist prompt in a control popup instead of the traditional one

added

New icon to visualy identify in Metadata missing Metadata Links

added

Required Models View: new button to perform link with editor on a model

added

Required Models View: ability to open a model by a double click

added

SQL Explorer: Add SAP Hana driver in default JDBC Drivers preferences

added

User Defined Functions: When using Metadata Variables in UDF Implementation, corresponding Variable Manager are now automatically added on Mapping's generated Process

added

WSDL Metadata: new OAuth2 'Additionnal Properties' attribute which is filled when generating tokens

added

WSDL Metadata: support the standard OAuth2 grant types

fixed

Add an information icon on Process Actions, Templates, Parameters, and Metadata attributes displaying the available documentation

fixed

Arrange All Horizontal sometimes does not use optimal placement to display join links

fixed

A NullPointerException is thrown when canceling on the JDBC Database Reverse Wizard

fixed

Copy / Pasting a Metadata Node Configuration does not re-generate the internal ids of the copied attributes

fixed

Data Lineage: "java.lang.IllegalArgumentException: Argument cannot be null" might be thrown when clicking on a node

fixed

Deleting Mappings / Processes with multiple selection might not delete the corresponding diagrams

fixed

Functions should not be displayed in the RDBMS Reverse Wizard

fixed

Generation fails when the encoding of a Metadata is not UTF-8

fixed

Generation fails when the Mapping / Process is using a Metadata containing a Configuration whose Name is not set

fixed

Metadata Configuration: when clearing the value of an attribute, the attribute unexpectedly remains externalized with an empty value in the Metadata file

fixed

Metadata attributes display: attributes configured in the same group in technology are incorrectly displayed in different groups if they are not following each other in the definition

fixed

Mapping tooltips: "Problem" tooltips are missing on Metadata Variables which have issues

fixed

Metadata Reverse: key / value attributes which are defined as unbounded in the technology are unexpectedly empty at first reverse

fixed

Newline characters which are in Link Execution Conditions are not reported in generated delivery

fixed

Package Generation: Metadata attributes without value must not be externalized

fixed

Package Generation: Metadata Attribute of type Reference must not be externalized

fixed

Package Generation: Metadata Attributes which require generation are not externalized in the generated package

fixed

REST Wizard: XML output might not be reversed in some cases

fixed

REST Wizard: when reversing input and output parameters, the content-type should be defined only on parameters that require it

fixed

REST Wizard: Basic Authentication might fail in some cases

fixed

Template located in project P1 should not appear in a mapping located in project P2

fixed

Unable to build a Mapping / Process when the temporary generation folder is customized in Preferences

fixed

User Defined Functions: Mapping expression appears in error when a parameter value contains parenthesis

fixed

Unable to build a Mapping / Process which is located inside a folder that contains an apostrophe in its name (or in one of its parent folders)

fixed

WSDL Metadata: user and password proxy attributes should be listed in the 'Proxy' tab of the Metadata instead of the 'Deprecated' one

fixed

XPath functions retrieving expressions from Mappings or Processes should keep the "\r \n \t" characters that are in expressions as is in the generated code

fixed

java.lang.NoClassDefFoundError: org/eclipse/core/runtime/Assert might be thrown when using buildDelivery.bat / buildDelivery.sh scripts

added

Ability to export license usage from the License Manager to clipboard

added

License popup: trim license URL and license key to avoid issues with whitespace characters

added

Project Explorer: new context menu to show both the required and missing models for the selected item

added

Reorganize Process Actions Parameters display order

fixed

Duplicated parameters on some Process Actions

fixed

Generation is failing when using a Dynamic Name on / in a Process Reference which is instanciated multiple times

fixed

Link Execution Condition is incorrectly generated when it contains scripting expressions with line returns

fixed

Oracle Metadata: columns defined as NUMBER are unexpectedly reversed as NUMBER(22,0)

fixed

Provide more information when generation is failing within %xsl{}xsl% block

fixed

Package Generation: Package is missing externalized Sub-Metadata attributes when the Sub-Metadata is overriding some parent values

fixed

Package Generation: Externalized Metadata attributes values may be truncated

fixed

Unable to perform xpath evaluation in Internal Resources

added

Add support for Caché database

added

Allow to deploy a Package into Analytics from Package Configuration

added

Provide more information in generation errors

added

SQL Explorer: add Netezza driver in default JDBC Drivers preferences

added

SQL Explorer: add Vertica driver in default JDBC Drivers preferences

fixed

Aggregate flag should not remain on the target when adding a stage between source and target

fixed

A link of link should not be calculated when the source Process Action is not generated

fixed

A NullPointerException is thrown when launching the 'Properties' action menu on a Table Metadata which contains nodes (columns, indexes, ...) without a name

fixed

A NullPointerException is thrown when reversing a Metadata which uses a connection without user / password

fixed

A NullPointerException is thrown when building a Package on a Configuration used on attributes with multiline values

fixed

Externalization of Metadata attributes with 'Reference' type should not be possible

fixed

Generation is failing when a Generation Condition is testing the existence of a Metadata node

fixed

Generated Packages might be missing Metadata attributes when working with Sub-Metadata

fixed

Generation is failling when using a Dynamic Name on a Sub-Process / Process Reference

fixed

Link Execution Conditions using scripting syntaxes such as %e(rhino){}%e(rhino) are incorrectly generated: the scripting starting and ending blocks are duplicated in the delivery

fixed

Renaming a Metadata that has just been copied from a dupplicated Metadata makes it appear as dupplicated

fixed

REST Wizard: Input structure with UTF-8 characters is not encoded correctly when testing the Web Service

fixed

Rest Wizard: Output of Content-type "text/plain" is not reversed correctly

fixed

The "Hide unused" option is ignored on Stages when reopening the mapping

fixed

Unable to perform generation on a Metadata when one of its attribute has a Default value and the node has some children

fixed

User Defined Functions: add a warning on UDF Metadata to prevent using the 'user' prefix, which is reserved for functions defined with user.xsl

fixed

User Defined Functions: when a metadata variable is used in the function implementation some characters after metadata name are omitted

fixed

User Defined Functions: syntax value::type used to cast values in PostgreSQL is interpreted by designer as User Defined Function

fixed

User Defined Functions: evaluation on built Mapping Metadata does not handle UDF expressions

fixed

User Defined Functions: Expression containing UDF are in error when an UDF parameter is on multiple lines

fixed

User Defined Functions: Error at generation when a UDF is calling another UDF with parameters in implementation

fixed

User Defined Functions: In Mapping, a UDF that is used in an expression appears in error when the preceding character is not a space

fixed

Generation is not performed on Step Dynamic Name

fixed

Two steps configured with a parallel repetition query may unexpectedly start at the same time

fixed

Unable to build a Mapping / Process using a Metadata node which contains generation involving both %x{}x% and %{}% expressions

fixed

Unable to build a Mapping / Process in which the generated value of a Process Parameter used as XSL Variable contains single quotes

fixed

Unable to build the Package of a Mapping / Process that is using multiple Sub-Metadata having the same parent

fixed

Unable to build deliveries from Packages generated on versions prior to S19 Designer

fixed

'Export Models and dependencies" on Windows generates an archive file that cannot be imported correctly on Linux

fixed

A Process Action configured as 'Begin Action' is unexpectedly not executed when it is designed to perform a loop with another Process Action

fixed

Bind links incorrectly generated in some cases

fixed

Navigator: repositories configured in Runtimes S17.4.10 and higher are not displayed

fixed

Parent Configuration is not applied when using nodes of a Sub-Metadata file

fixed

Unbounded Metadata attributes of 'Reference' type should display the references using their label instead of their XML Element representation

fixed

Unable to delete Metadata Links which are in error

fixed

Xsl Variables might be treated in the wrong order during generation when some are defined on Process parameters through meta-inf

fixed

buildDelivery.bat / buildDelivery.sh scripts are not using the configuration specified to the build command

fixed

A Mapping that has been created through a copy / paste cannot be built right away after its creation

fixed

Generation on Mapping and Processes is failling when the designer installation path or the stambia.runtime.home variable contains a space character

fixed

REST Wizard: output HTTP Headers are incorrectly reversed as mime:header instead of http:header

fixed

The table physical name used in generated Mapping queries is incorrectly using the Mapping's table alias when the table is both source and target

fixed

Error when using buildDelivery.bat / buildDelivery.sh when a Parameter contains some meta-inf

fixed

The Mapping / Process internal name should not be cleared when it matches its file name

fixed

Unable to Reverse RDBMS tables when JDBC driver does not support DatabaseMetaData.getFunctions

fixed

User Defined Functions creation wizard: parameter names should be trimmed when they are created

fixed

User Defined Functions are incorrectly generated when their expressions contain multiple words

fixed

Unable to use buildDelivery.bat / buildDelivery.sh scripts

added

Add Support to Build multiple Deliveries in the same Package

added

A new meta-inf is available to indicate that a Process Parameter is deprecated

added

A disabled field / clause with error should not prevent building mapping

added

Add a warning on Metadata which are not properly formed (which does not respect the internal Metadata structure)

added

An hyperlink is added on Metadata attributes when a default value is defined in their technologies

added

Ability to create a Launch Package Configuration, which allows to define and create groups of deliveries to build at the same time

added

Add contextual menu Build/Execute > Publish when multiple Processes / Mappings are selected

added

Allow to define and select Datastore Layers on hierarchical Datastores

added

Add the ability to generate a screenshot representing the current Process

added

Build Package Command Line Application: ability to execute a Package Configuration

added

Create a custom event management system to improve the workspace synchronization system

added

Cross References Errors in Metadata are now impacting all affected Mappings / Processes in cascade to prevent building them

added

Cache: performances improvements in cache operations

added

Cross References Errors in Processes are now impacting all affected Mappings / Processes in cascade to prevent building them

added

Data Lineage: new data lineage utility to perform impact analyses on Metadata

added

File Metadata: positional files fields cannot be moved anymore by drag and drop in the Metadata to avoid any unwanted position issue

added

Improve Delivery Generation performances

added

Kerberos technology: externalize properties

added

Kerberos technology: offer the possibility to disable the security

added

Metadata icons are now included in built Packages

added

Metadata: the nodes of a Metadata can now be re-arranged using drag and drop

added

Mapping stages: datatypes can now be defined on stage fields

added

Mapping Computed Fields have a new 'Standard' tab in Properties to make their configuration easier

added

Metadata Creation Wizard: be exhaustive about available and unavailable products in the list

added

New preference in the Designer to specify the folder to be used for the temporary generation objects used during the prepare step

added

New button in the Project Explorer View to reveal the item that is selected in the Editor: "Link selection with Project Explorer"

added

New context menu entry in Mappings and Processes to open the Metadata of the currently selected node

added

New shortcut to perform a one time Link with Editor operation on an item: CTRL+ALT+L

added

New 'Initial Value' property on .tech attributes to define the value that should be used when the attribute is created

added

New 'Default' property on .tech attributes to define the default value that should be used when the attribute is not specified

added

New REST Wizard to test, invoke, and reverse REST Web Services

added

New arrange all alternative option in Mappings: arrange all (horizontal layout)

added

New operators in Mapping: EXIST, NOT_EXIST

added

New wizard to test SAP Bapi from Metadata

added

New Metadata to define Runtimes

added

Syntax Coloring in Expression Editor

added

Stage fields now support 'Source' Execution location

added

The Process Parameters tooltip popup has been reviewed to be more convenient and to remain until the user leaves the area

added

The logical "Name" parameter which is available on Mappings and Processes cannot be edited anymore from the Standard Properties

added

The usage replacement prompt that is displayed when deleting a stage is not necessary when the stage is not used

added

The Metadata attributes that are configured as 'unbounded' in their technology are now displayed in a more convenient window in the Properties

added

User Defined Functions support

added

Update rdbms.tech "Drop table" and "Delete table" actions to use the dedicated xpath expressions

added

WSDL Metadata: new wizard to generate OAuth2 token

added

WSDL Reverse Wizard: add the ability to reverse secured WSDL

fixed

A Metadata node disappears from the Metadata Editor when it is drag and dropped on another node of the same level (or itself)

fixed

An overridden resource from which the internal id has been changed should not appear anymore has overridden in the Designer

fixed

An error icon appears on Mapping / Process References when they are moved / renamed from outside of the Editor without closing it

fixed

Completion on Stage Multiset expressions should not be case sensitive

fixed

Externalized Metadata Attributes having an xpath expression in their value should be evaluated in generated Packages

fixed

File Metadata: the generated file path is incorrect when using a sub-metadata created from a sub-directory

fixed

Import Internal Resource sets the encoding to default encoding which might be different than UTF-8

fixed

Multi-valuated Metadata attributes having an xpath expression in their value are not evaluated at generation

fixed

Resolving "ERROR_MAPPING_BY_OWN_DATASET" does not remove the error icon on the field

fixed

The execution order is incorrect when there are actions with 'sequential' repetition type in a Process with repetition query

fixed

The Load Template might unexpectedly disappear from a Mapping when performing operations on the Metadata involved while working on it

fixed

The Order declared on a datastore in a Mapping is not reflected in the Mapping Metadata and generated Process

fixed

The source dataset is not re-calculated when setting the left / right parts of an empty Join which doesn't have any expression or left / right parts

added

New default RDBMS function which returns the Java mask converted to a SQL mask: "tech:convertJavaTimestamp()"

added

New field in RDBMS products to define a function to convert a timestamp to a char

fixed

Mapping: the order of generated work fields should not vary between builds

fixed

Navigator: Schedules are not listed under deliveries when connecting to a Runtime version prior to 17.3

fixed

The Designer cannot use rhino with Java 8

added

Add a warning when disjointed datasources are used to feed xml structure and parent element is mapped

added

New multivaluated Template Criterias on Integration steps: srcProductList, srcTechList

added

The text area for the 'Order' parameter of a Mapping Join should resize automatically when adding new digits

fixed

A warning should appear when a Mapping Expression set as 'Target' Execution Location is using a source field

fixed

Build Package Command Line Application: generated packages are incorrect when used with "-importFrom" option

fixed

The Console View is unexpectedly activated when executing a Mapping

fixed

Unable to Reverse RDBMS from a Sub-Metadata

added

Add the ability to provide an internal xpath expression to overload the one used to connect to database with SQL Editor

added

Add the ability to specify a custom mask for staging objects

added

Get Files with FTP Process Action can be used as the source of a bind link

added

Handle the xPathExpression GEN_CONNECTION_EXTRA_PROPERTIES to generate connection properties in delivery

added

Handle the xPathExpression INTERNAL_PROPERTIES_REF for JDBC connections from SQLExplorer

added

Handle a new xPathExpression INTERNAL_EXTRA_PROPERTIES to add JDBC Connection properties

added

New Template Criteria CompatibleTechList

added

New technology: Ingres

added

New technology: Kerberos

added

SQL Explorer: Add Impala, Hive, HBase and Google Big Query drivers in JDBC Drivers preferences

fixed

File Server Sub Metadata: Incorrect path is used when reversing a file in a sub metadata

fixed

Foreign keys are incorrectly reversed in a Sub Metadata File

fixed

Metadata not exported to package when used only in a process parameter

fixed

Metadata List Property: the Metadata Level attributes defined as list should always have an empty / null value available in the list to allow the user to unset it if needed

fixed

Menus that appear when performing a drag and drop in Mappings and Processes (Map / Join popup, available actions popup) don't work correctly when a touchPad is enabled

fixed

Native Evaluation on sub Metadata duplicates the parent Metadata node in the XML tree

fixed

The filters defined in Mappings are unexpectedly generated in a random order in the built files

fixed

Template Choser Evaluation (TPC): the CONTAINS operator should handle multi-valuated criterias

fixed

Typo in Error Log message: Error while refresh decroator

added

Cache: Increase the cache save frequency

added

Execute Delivery action: new parameter to specify if the delivery should be searched in the local or remote Runtime: 'Deliv Remote Delivery Mode'

added

Mapping Build: avoid to delete Built files when a Mapping becomes in error

added

Mapping Build: the tags specified on Join / Filter conditions are now added into the generated Mapping Metadata

fixed

Clean Project: Avoid unnecessary LinkedJob when cleaning a Project

fixed

Cache: Handle orphan cache objects to prevent errors

fixed

Mapping Build: the xPath function INTEGRATION_STEP_REF doesn't work properly in some cases

fixed

Mapping Reject: the wrong table might be used in the generated code

fixed

Mapping Problems tooltips: The 'ERROR_AMBIGOUS_SRC_REF_FULL_PATH' tooltip is not shown when the involved columns / fields don't have the same case

fixed

Mapping Build: Avoid unnecessary Mapping Rebuild in some cases

fixed

Navigator: NullPointerException when adding a Purge schedule

fixed

SQLExplorer: unable to load some drivers since DS-1731 resolution

fixed

The Console view doesn't print the generation errors (since DS-1732)

fixed

The content of the indy.build folder should be ignored by GIT

fixed

Unable to drag and drop files from the Operating System into the Project Explorer

added

JDBC Drivers configuration: ability to select multiple libraries in the "Extra Class Path" / "Add JARs" window

added

WSDL Metadata: new wizard to generate OAuth 1.0 Token

fixed

Datastore Selective Display: applying Unsynchronization on large XML target is very slow

fixed

File Metadata: new xpath expression to fix the incorrect "from" part generated in the select queries

fixed

Hierarchical Target Datastore: a node that contains mapped fields in its descendant should appear in blue and italic in the Mapping

fixed

In a Mapping, the template configuration popup might appear out of the screen when the template has a lot of parameters

fixed

Mapping migration from Designer S16 -> S18: Reject Template might disappear in some cases

fixed

Missing "Enable Mapping" QuickTools on Datastore Fields

fixed

Missing Enable Reject/CDC QuickTools on Datastore

fixed

Process Diagram: "Show / Hide Parameters" button doesn't resize automatically the action box when it has a repetition query

fixed

The Console View should not be activated when the generation is performed on a Process / Mapping

fixed

The Statistic View is empty when the value of one of its variables is too large

fixed

XML Metadata: java.lang.ClassCastException may be thrown when reversing an xsd file

fixed

java.lang.ClassCastException might be thrown when disabling a mapped field which is in error

added

Build Package Command Line Application: new options to rebuild the cache before processing

added

Build Package Command Line Application: new option to import projects that are outside of the workspace before processing

added

Build Package Command Line Application: new options to rebuild the Mappings before processing

added

Build Package Command Line Application: models that are not built are automatically built and indexed in the Cache before processing

added

File Server Metadata: add the possibility to create a hierarchical directory structure in Metadata (sub-directories)

added

File technology: new property on file to specify default numeric format: 'Default Numeric Format'

added

File technology: new property on file to specify the default grouping separator: 'Default Grouping Separator'

added

Improve expression formatting when adding a column to a join

added

Improve Mapping Problems tooltips: a new 'ERROR_AMBIGOUS_SRC_REF_FULL_PATH' tooltip is displayed when multiple source columns have the same path

added

JDBC Reverse script: add support of bsf scripting language

added

Move Metadata Node in another Model: A new warning popup is displayed to inform the user about the consequences of the operation

added

Navigator: ability to display the delivery schedules with a jobName different than the delivery name

added

New Shortcut to open the Metadata of the current object

added

Navigator: Ability to specify a Job Name and Remote Runtime in the Schedule Window

added

RDBMS technology: Use the object mask to generate the name of: pk, fk, ak, ck, index

added

Sql File Export Action: new parameter to specify numeric format: "Sql Exp Numeric Format"

added

Stambia plugins now support having a mask of libraries to load as external classpath (Osgi hook enhancement)

added

The Auto-resize of Process Actions boxes when typing large values in Parameters is now limited in width

fixed

"Cache calcul" advanced menu on Processes and Mappings is renamed to "Re-index model in Cache"

fixed

A NullPointerException is raised when using the Outline Search on a Process containing an XSL Variable without code

fixed

A Metadata opened by a double click on a node from the Impact View or Project Explorer is not linked correctly

fixed

Double click on a MdNode in the Project explorer does not locate the node if the Editor is already opened

fixed

Execution error when XML actions include scripting expressions

fixed

ElasticSearch - datatypes are not reversed

fixed

Input and Output parameters are not generated in Deliveries and Packages when their default value is empty

fixed

Metadata Reverse Exceptions might be thrown in a non convenient window

fixed

Mappings are incorrectly initialized in ASCII instead of UTF-8 at creation

fixed

Mapping: build delivery fails when using the ${paramPath}$ syntax in a Parameter

fixed

Opening a Metadata already opened from Project Explorer might unexpectedly open multiple editor for the same Metadata

fixed

Package documentation: bad distinction between Process/Template in the generated documentation

fixed

Process links don't appear as conditionnal when they contain only line returns

fixed

Reverse XSD : wrong sequence order when extending existing datatype

fixed

Repositories are not available under a Runtime in the Navigator

fixed

RDBMS Wizard : A NullPointerException is thrown when performing a connection on a RDBMS Metadata containing a 'Property' node without a value

fixed

Selective Display View does not keep the datastore field order

fixed

Selective Display view: Check all / Uncheck All buttons should take into account the current filter

fixed

The order of columns is not respected when replacing a datastore by a stage

fixed

The position in the editor is reset at save when editing a Process Reference

fixed

The History View is broken at Designer's start

fixed

The first Show Impact performed after Designer startup displays an empty Impact View

fixed

The 'addObjectNameMask' function doesn't work with Oracle tables

fixed

Unable to load a JSON file when temporary table names are defined with [sessionTimestampName]

fixed

Unable to reverse an XML file that contains a local relative doctype

fixed

When coming from another editor, Metadata UI might not be refreshed correctly when changing the value of an attribute

fixed

When copy pasting a folder, the new Mappings diagrams might still reference the source Mappings instead of the new ones

fixed

Xml Metadata: unable to add an "element" node under an "all" node

added

Allow to build Mappings which contain unused Metadata nodes that don't exist anymore

added

Add a warning on the templates selected in a Mapping if they are not available in the current tpc rules

added

Double click on a Metadata Node in the Project explorer locates automatically the node in the opened Editor

added

Double click on a node in the Impact Analysis locates automatically the object in the opened Editor

added

Display Metadata attributes in the Impact View when necessary

added

New xpath expression on JSON Metadata to generate the JSON schema structure: toJsonSchema

added

New application to build package in command line

added

Outline Search: clicking on a search result updates the Designer's Views with the selected object

added

Package documentation: preserve the line breaks of descriptions in the generated Package documentation

added

Technologies: Ability to specify a list of reserved words that require the addition of delimiters when used in queries

added

WSDL Metadata: the UI is not refreshed when changing the Binding Type of a Part

fixed

Add "STRG", "SSTR" and "RSTR" datatypes to SAP technology

fixed

An error is thrown at execution when using an SAP Abap Program with a "/" in its name

fixed

Encoding used for Internal Resources might be incorrect during generation

fixed

Making a modification on a Mapping using an unavailable Template should not re-select automatically another Template

fixed

Metadata Variables are not evaluated when used in a xpath expression

fixed

Metadata: manually created Metadata Nodes or Nodes Configuration might not be visible in the editor

fixed

Object Selector Metadata: Moving a datastore referenced in the Selector puts it in error

fixed

Starting the Designer with -clean option unexpectedly uninstall installed plugins

fixed

The UI is not refreshed in Metadata when changing a value at attribute creation

fixed

The Metadata Node 'Move' dialog is not showing the Metadata that are in the global Project

fixed

Template Warnings are unexpectedly showing an error icon

fixed

Unable to copy paste a Schema Metadata Node

fixed

Unable to move a bind link from a Process action to another

fixed

Unexpected 'ERROR_JOIN_NON_STAGEABLE_FIELD' warning displayed on stage target filter using the same connection

added

New technology providing the ability to create views of Metadata: Object Selection

added

New Property Field on JSON and XML Metadata: sortKey

added

New Property Field on JSON and XML Metadata: nodeLocalPosition

added

New Property Field on JSON and XML Metadata: nodePath

added

Package documentation: add Package's build date in the generated documentation

fixed

The calculation of fields requiring an update key in a Mapping is not performed on fields added automatically because of Metadata update

fixed

Unable to launch Stambia under MacOS

fixed

Unable to install connectors plugins

added

Add 'hierarchyid' datatype to Microsoft SQL Server technology

added

Add "time" datatype to Microsoft SQL Server technology

added

Add the ability to detect Mappings in Code generation

added

File Metadata Wizard: New parameter "Ending Lines To Skip"

added

New Parameter on 'FTP Put' and 'FTP Get' Actions: IGNORE_TRUST_STORE

added

New properties on the Runtimes definition: User and Password

added

New Parameter on JSON and XML Metadata nodes to retrieve dynamically the nodes matching a specified pattern at read: Name Selection Pattern

added

New Property Fields on JSON and XML Metadata

added

New Parameter on FTP Server Metadata: FTP_SYSTEM_TYPE

added

New Parameter on FTP Actions: FTP_SYSTEM_TYPE

added

New Security tab on FTP Server Metadata

added

New Parameter on FTP Actions: TRUST_STORE_PASSWORD

added

New Parameter on FTP Actions: KEY_STORE_PASSWORD

added

New Parameter on FTP Actions: KEY_STORE_TYPE

added

New Parameter on FTP Actions: KEY_STORE

added

New Parameter on FTP Actions: TRUST_STORE_TYPE

added

New Parameter on FTP Actions: TRUST_STORE

added

New Parameter on 'FTP Put' and 'FTP Get' Actions: FTP_PROTECTION_BUFFER_SIZE

added

New Parameter on 'FTP Put' and 'FTP Get' Actions: FTP_DISABLE_LOGIN

added

Removing a value from a Multi-valuated attribute put it back in the add section

added

Sessions View: Improve session list gathering when using a poor network connection

added

new column in the Sessions View to visualize the number of restart of a session: Restart Count

added

new column in the Sessions View "Launch User"

fixed

"Decoration calculation : Invalid registry Object" avoid the installation of subclipse plugin

fixed

A collapsed datastore is not displayed correctly after re-openning a Mapping

fixed

An unexpected warning is shown on Mapping fields which are set on Target Location when they are only using a variable on their expression

fixed

A process cannot be re-opened after adding a Metadata Link with no name in it

fixed

A NullPointerException may occur when deleting a datastore from complex Data Sets

fixed

A NullPointerException may occur after deleting a Configuration in a Metadata

fixed

A double click on the datastore's 'Enable rejects' or 'Use CDC' buttons should not activate compact mode

fixed

A Process Link which starts from another Link is not displayed correctly when the Process diagram is reinitialized

fixed

An error about conflicting CommandHandler might be thrown in the Error Log View

fixed

Consulting data on multiple source joins in a Mapping should be possible

fixed

Changing the target of a Bind Link to another Action that is already the target of a Bind Link should not be possible

fixed

Copy / Pasting a Process Action that is the source of a Bind Link should not duplicate the Bind Link

fixed

Data Lineage in Mappings does not show the links between Metadata Variables and Computed Fields

fixed

Deleting a Datastore that is used as Left/Right within in a Join does not split the Dataset

fixed

Drag and dropping multiple fields on a stage that contains multiple sets doesn't work

fixed

Error in the cache when a Metadata contains a reference on an Object which is used by another model

fixed

Ftp Put Action: The Local Path parameter should be set automatically by a Folder Metadata

fixed

In a Mapping, the Data lineage links representing field's usage may be misplaced in some cases

fixed

In a Mapping the field's QuickTools location is wrong when collapsing / expanding fields on a hierarchical datastore

fixed

Multiline Metadata attributes cannot be scrolled with the mouse wheel

fixed

Make Directory Action: The File Dir parameter should be set automatically by a Folder Metadata

fixed

NullPointerException is raised when executing a delivery from the Navigator

fixed

Package documentation: objects with long names overflow on the documentation diagram

fixed

Process Actions Properties: The tooltip showing the Metadata Links that can be used to fill the Action's Parameters may show incorrect possibilities

fixed

RDBMS Wizard : RDBMS Metadata's root node contains '%20' in its name instead of a space character when a space char is entered in the creation wizard

fixed

The 'use CDC' option is not applied on the Integration when there is a Load step

fixed

Teradata: the xpath expression converting the timestamp format does not support formats with 6 digits

fixed

The hint showing the parameters set by a Metadata Link on Process Actions is wrong when multiple applicable Metadata Link are on the Action

fixed

The icon displayed in the Properties View of Process Parameters doesn't reflect their type

fixed

The native parameters of Process Actions always have the 'String' type when being overridden by the user, whatever is set in its definition

fixed

Typo on Email technology and Process Actions: "Mail" should be "Email"

fixed

The Outline Search in Mappings doesn't return all the expected values in 'Search by Expression' mode

fixed

The special characters contained in the name of a Metadata Variable should be replaced when it is dragged and dropped in a Mapping or Process

fixed

The 'Mail Port' parameter of the Read Email action should be initialized automatically by Incoming Account Metadata nodes

fixed

Unable to open a Process having a step with the "?" character in its name

fixed

Unable to open a Process when a sub-Process with a '&' in its name is used as a target of a Link inside

fixed

Undo (Ctrl+Z) is unavailable in SQL Explorer

fixed

When a table is used several times in a Mapping, the 'hasIntegrationReject' xpath function always returns true if one of them has Rejects enabled

fixed

java.lang.ClassCastException might occur when selecting a datastore

fixed

Mappings: The color of the fields is not refreshed correctly when setting the value from expression editor

fixed

Metadata view: icons are not refreshed correctly

fixed

The fields of Metadata with hierarchical datastores might not appear correctly in Mappings

fixed

The meta-inf values set on a Process Parameter are ignored when the Parameter is of type Integer

fixed

Renaming a resource from outside of the Designer makes it appear as DUPLICATE

fixed

The project configuration file (.project) is not updated correctly: indy.build's linked resource type becomes 1 instead of 2

fixed

The expression editor might be unselectable when clicking on a Metadata Node in the Project Explorer

fixed

WSDL Metadata: The name of Input and Output nodes should not be editable

added

"Replace in usages by" can be used for any type of node

added

ActionCode and Action Parameter can now be encrypted

added

A warning is displayed on joins which do not use the left and/or right datastore in their expression

added

Add Google Sheet driver in SQL Explorer preferences

added

Ability to undo changes (Ctrl+Z) inside a SQL Editor

added

Adding a Query as a Metadata Link on a SQL Operation automatically sets the Connection

added

Base64Binary are converted to LONGBLOB on MySQL technology

added

Built files are now stored at the root of the workspace

added

Bigger stack trace popup

added

Clicking again on a selected Datastore or Action does not enable name edition anymore

added

Create a Menu Entry on Duplicated Resource to reveal the active Resource

added

Datastore Tags are displayed on the Diagram

added

Drag and drop a schema onto a target Datastore will replace it by a stage

added

Drag and dropping a Metadata on a Process displays all the possible usages of this kind of Metadata

added

Display error when the error is on a link's execution condition

added

Elastic Search: Indexes can be reversed from their aliases

added

Elastic search: Add support for selective reverses

added

Excel metadata: set JDBC.BIND.MANAGE_SET_NSTRING_AS_STRING by default

added

File Wizard: Physical Name of Fields is checked for uniqueness

added

HDFS: add support for Command line over SSH

added

HDFS: both WebHdfs URL and Httpfs URL can be specified

added

Hive: Add precision and scale to DECIMAL creation mask

added

Initialize Aggregation flag and useDistinct option from target when initializing an intermediate Stage

added

Improve loop detection in Computed Fields expressions

added

Improve the Stambia tools to make easier the development of new Java based technologies

added

Improve the Replace Metadata popup

added

MacOS: add the integrated property editor to metadata editor

added

MacOS: embedded Runtime is generated inside the application package

added

Mapping: double click on a Datastore allows to switch from Compact/Full mode

added

New shortcut to rename Process Actions: F2

added

New node under each Template in the Project Explorer to access its documentation

added

New shortcut to access templates documentation: F1

added

New button in the toolbar to perform impact analysis on the selected object

added

New technology: Oracle BI

added

New shortcut to perform impact analysis on the selected object: CTRL+SHIFT+I

added

New shortcut to rename Process Parameters, Variables and Metadata Links: F2

added

New technology: Progress Open Edge

added

New shortcut to rename datastores and stages in a Mapping: F2

added

New action: AMQP Send Message

added

New action: AMQP Receive Message

added

New action: AMQP Receive File

added

New action: AMQP Operation

added

New technology: BSON

added

New SQL property on RDBMS technologies to define the syntax to use for Drop View If Exists statements

added

New XPath expression on tables: ref:ak()

added

New technology: Sqoop

added

New button in Join properties to switch between Left and Right datastores

added

New checkbox StopBindOnError in the Advanced tab of Actions

added

New action: AMQP Send File

added

Performance improvements for rebuild cache

added

Properties view: new icon identifies Parameters which can be specified with Metadata Links

added

Process: the size of the error message popup window is saved

added

Performance improvement of Oracle reverses

added

Runtime view: remember the last connected Runtime when the Designer was closed

added

Show The ActionCode non-mandatory parameters initialized by MetaDataLink

added

Salesforce add possibility to filter during select

added

Sybase IQ supports Full and cross joins

added

Standardization of Severity Levels on Rdbms constraints

added

Send Mail action handles Mailing List metadata links

added

The position of the mouse cursor in Expression Editor is kept in memory, allowing to focus directly on the last position when coming back to the selection

added

The toolbar execute button now remains even if the focus is not directly on the Mapping/Process editor

added

The Configuration selection box in the toolbar can be resized in the preferences

added

Templates documentation is exported to the Help Contents of the Designer

added

The MetaInf defined on a Template Parameter should be preserved on the generated Parameter

added

The tag icon in a Mapping is displayed for columns having a tag in the metadata

added

Tag icon is displayed on source Fields

added

Vertica: add missing datatypes

added

XslVariable have now a visibility attribute

fixed

$context variable is not resolved when using a computed field with user function combined with a LOAD template

fixed

Add JdbcOdbcDriverWrapper to the technologies having an ODBC driver

fixed

A Process cannot be prepared when the Publication Options of a Sub-Process Parameter has been unchecked

fixed

Building a mapping delivery fails when the tech:fullName() xpath expression is used in a template

fixed

Bad ToolTip when adding a Mapping Ref within a Process

fixed

Copy/pasting multiple Metadata nodes might fail

fixed

Copy/Paste a parameter modifies a Process in readOnly mode

fixed

ConcurrentModificationException may be raised when selecting a Metadata Node

fixed

Datatype syntax does not take Oracle version into account when execution location is set to staging area

fixed

Deleting (or closing its project) a Resource might result in a very long indexation

fixed

Duplicating an Action with CTRL+Drag and Drop does not rename it correctly

fixed

ExpressionEditor loose its content when we change the selected control in the PropertyView

fixed

Error Popup after closing and restoring Properties View

fixed

Edition of a sub-Process Action Code from expression editor may not be taken into account

fixed

Generated documentation is missing the physical name of tables

fixed

Hive: VARCHAR creation mask is missing a parenthesis

fixed

Help crash with Java 8u91+

fixed

Impact View: Source/Target icon is no longer displayed

fixed

Improve CrossRef Errors when eltID does not match its fileID

fixed

Incorrect alias word generated for Multi Connection Integration step

fixed

Metadata editor is not closed when the corresponding Metadata is deleted from the Project Explorer

fixed

MacOS: clicking on a property fills it with the first value of the list

fixed

MacOS: issues with the application's icon

fixed

Memory leak when deleting an object from an Editor

fixed

Missing Filter MdNode on Integration when Filter on WRK and using Conditional Joins

fixed

Mapping appearing in error after deleting the map.tech file from technology project

fixed

MacOS: Drag and Drop on a Locked Expression Editor does not work

fixed

Mapping internal ids might be updated incorrectly when copy/pasting a folder in another Project

fixed

MacOS: Selecting a Parameter of a Process may lead to a JVM crash

fixed

Mapping images generated through documentation are truncated when diagram has objects with negative coordinates

fixed

Mysql technology: LONGTEXT datatype columns are not generated in DDL statements

fixed

Mapping: Integration Order property field is written from right to left

fixed

Oracle reverse: Check constraints are not reversed

fixed

Postgresql: add Array datatype variant

fixed

Reverse Datastore from SubMetaData does not work when the Submetadata parent contains the same Datastore

fixed

Renaming an opened Process or Mapping might cause a diagram loss

fixed

Reverse mssql: varchar(max) are reversed as varchar(2147483647)

fixed

Selected configuration is not applied when the metadata's file is located outside the workspace

fixed

Session view: LaunchMode column displays ExecutionMode and vice-versa

fixed

StackTrace popup window cannot be opened when a step has an empty StackTrace

fixed

Status Line error message is not refreshed on Field selection

fixed

Stage Field expression cannot be edited until the Stage is mapped with at least one Source Field

fixed

Selection box does not appear in the Properties view of Process Actions parameters that have multiple possible values

fixed

Target Filter expression is not updated when renaming the alias of the filtered datastore

fixed

The Configuration selection box is not refreshed with the newly created Configurations in already opened Metadata

fixed

Unable to open InternalResource from Impact Analysis View

fixed

Unable to delete a Metadata Link on a sub-Process from the parent Process editor

fixed

Unable to delete more than one Parameter in a sub-Process

fixed

Wrong code generation when columns/fields have special characters

fixed

Wrong MetaData Generation with Inherited Dataset when a target needs a Load and not the other one

fixed

With an Xml source filter on staging area doesn't work

fixed

XML Datastore does not support having an Attribute and an Element with the same name at the same level

fixed

Xml to jdbc using a MultiSet Stage between them doesn't work correctly

fixed

tech:onWrk() always returns false

fixed

Upgrading a mapping to 18.1.0 might adds an unexpected update key that was not present before

added

A Warning is added on a Join if it does not use its right and/or left Datastore in its expression

added

A new property "label" can be added to the Meta-inf of a Process Parameter to display a user friendly label when selecting in the dropdown list

added

Automatic Mapping can be performed manually using a context menu on a source Datastore

added

A Breadcrumb Trail is used to display and navigate in the sub-processes of a Process

added

Computed fields can be defined on a Datastore

added

Expression Editor auto-completion improvements

added

Improve Problems Tooltips messages

added

Multiple Objects with the same ID (i.e. duplicates) can exist in a same Workspace

added

Metadata editor: ability to filter Metadata by name

added

Outline view allows to search Datastores of Mappings

added

Oracle: NUMBER columns reversed as NUMBER(22,0) are generated as NUMBER instead of NUMBER(22)

added

Outline view allows to search an Action of a Process by name or expression

added

Performance enhancement when analyzing mappings created in S17 and not migrated to S18

added

Target Datastores of a same Source Set can be on different connections

fixed

Action icon is displayed twice when unsetting the "Is Begin Action" Property

fixed

ClassCastException may be raised when moving a Metadata node to another Metadata file

fixed

Enter key removes the focus when defining a new Runtime

fixed

Hierarchical Fields are not correctly restored in the Mapping's diagram when the corresponding Metadata file is restored

fixed

Incorrect code generation when a JSon Source column has specific characters

fixed

JMS Send Message can be used as a Source of a bind link

fixed

Mappings build correctly may still have the error icon displayed in the Project Explorer

fixed

Migration S17 -> S18: Mappings with an XML target contain 2 root nodes

fixed

Missing error icon on a Variable used in a Mapping when the referenced Variable cannot be resolved

fixed

NullPointerException is raised when deleting a source Datastore used in a stage with multiple Sets

fixed

NullPointerException on Export Model and Dependencies

fixed

On complex mappings the stage sub-processes may be generated after their corresponding integration sub-process

fixed

Rdbms wizard: temporary object masks are saved when the wizard is canceled

fixed

StackOverflow exception is raised when exporting Models with dependencies if a circular reference exists in the objects exported

fixed

Save and execute a Mapping or Process may freeze the Designer

fixed

TargetFilter expression is not updated when a stage is inserted in an existing Mapping

fixed

Unable to execute a Mapping when then Source or Target Metadata files are physically located in another drive

fixed

Unable to create a Metadata Link from a FTP Folder

fixed

Unable to open the Mapping built Process from another Process after moving the Mapping

fixed

When Copy-Pasting a Mapping in the Workspace the copy may be marked as invalid

fixed

When moving a folder, the mappings are flagged as if they had been created prior to S18

fixed

When a technology file is overridden the decoration is present on the folders but not on concerned file

fixed

When displaying internal resources as a tree, the name of the Resource is the full path instead of the resource name

fixed

Xml: data type NCName is defined twice

fixed

tech:port() returns en empty string when invoked on an incomingAccount of a Mail Server

added

Xml Editor displays an error window when the validation of the XML file is failing

fixed

Mapping diagram is corrupted when undoing the deletion of the mapping expressions on the target

fixed

Missing table name in the generated from clause when joining a table and a stage which are mapped to a table on a different connection

added

An error is displayed when a Field on a Stage does not have any expression defined which would make the generation fail

added

Add support for ElasticSearch

added

Automapping on hierarchical datastores maps only Fields in the current level

added

Cassandra: new property "Nodes" on a Dataserver to specify the connection with the Datastax driver

added

Export Model and Dependencies now asks confirmation before overriding existing export file

added

File: new Property "groupingSeparator" on a Field to specify a thousands separator character

added

Improved data lineage display in mappings when Field is hidden (collapsed or scrolled out)

added

Impact View: automatically expand the first level

added

Json: File Path property is externalized by default

added

Mapping: joins between Stage and Table from different connections are marked with error ERROR_CLAUSE_NON_STAGEABLE_FIELD

added

Memory enhancement when building Workspaces with large Metadata files and Mappings

added

Step Detail View: automatically select the first iteration in error if any

added

The size of Template properties' popup auto-adjusts when changing the selected template

fixed

Auto-build conflicts with renaming of an opened Mapping

fixed

Auto-mapping is re-applied when mapping a field to an already mapped target

fixed

Available configurations are not automatically updated when deleting / restoring the conf.cfc file

fixed

A Process using a Mapping is closed when the Mapping is rebuilt

fixed

A same Action can have multiple input binding links

fixed

A Stage may contain multiple Fields with the same Alias

fixed

Build produces wrong generated code when using linked folders

fixed

Build documentation produces several icons for Execution Location

fixed

Build Mapping ProgressBar fills up before the build really ends

fixed

Code generation error when preparing a Mapping using a Metadata Variable in the Template parameters

fixed

ConcurrentModificationException sometimes occurs on startup

fixed

Cannot delete target table from a mapping

fixed

Cannot Dnd fields after alt+tab from another application

fixed

Deletion of a Stage may be silently ignored

fixed

Drag and Drop of a datastore on a Mapping may not work without closing and reopening the Mapping

fixed

Export Model and dependencies: popup does not close when clicking OK

fixed

Error "Widget is disposed" sometimes occurs when opening SQLExplorer

fixed

ExpressionEditor: modifications sometimes lost when using lock + Dnd

fixed

Export Model with dependencies: NullPointerException if a resource is having a wrong cross-reference

fixed

ExecutionException when deleting fields from a Metadata file and from the target Datastore of a Mapping

fixed

Export Model and Dependencies: the tpc files are missing

fixed

IllegalArgumentException when opening the Stack Trace popup on a step that has multiple iterations

fixed

Impact View : need to click two times

fixed

Json Datatype Number are created as Varchar in database

fixed

Json Reverse With URL doesn't work with https

fixed

MacOS: missing symbolic link on stambiaRuntime

fixed

Mapping expression may be unset after moving the field's metadata node

fixed

Missing context menu entries the first time a right click is performed on a metadata node in the ProjectExplorer

fixed

New configurations created with Copy/Paste are not available in Project Explorer

fixed

New error displayed on mappings when trying to use disjointed Query and Table from different datasets as a source

fixed

NullPointerException when deleting / saving Metadata used by opened Editor

fixed

No Exception raised when performing a concurrent modification on a Mapping and on its built Process

fixed

Open Process from mapping may not work since S18.0.3

fixed

Process: missing error icon on an invalid Mapping reference

fixed

Query on some technology, needs an "as" instruction

fixed

Query generation might embed too many tables when loading XML Files

fixed

QuickTool icons are not removed after deletion of a Field in a Stage

fixed

Reverse Query doesn't take aliases correctly into account on some technologies

fixed

Replicator RDBMS drop constraint generates invalid syntax on Mysql

fixed

SQL File Export: only SQL_CONNECTION parameter should be proposed to define the JDBC Connection

fixed

Steps with a repetition query and tolerating errors are colored in blue if a warning occurs

fixed

Stack trace pop-up window may not open

fixed

The join expression between a table and a stage is not generated properly when mapped to a table on a different connection

fixed

Template Property Popup does not handle some changes when closed directly after a modification

fixed

The Navigator view is not present in the list of the views

fixed

Undoing/Redoing changes in the expression of a Join may lead to broken Mapping

fixed

Using a Variable in an expression adds the WARNING_FIELDS_NOT_FOUND

fixed

Upgrading a mapping from S17 to S18 may lock when mapping has a hierarchical Target

fixed

Update Keys of XML Files are not automatically recomputed when replacing a target datastore

fixed

Wrong tooltip on the creation of a Metadata Link in a Process

fixed

When moving a Metadata node to another file white space characters and formatting are lost

fixed

When moving a Metadata node with children to another Metadata file it is no longer possible to create a Metadata Link by drag and drop

fixed

When moving a Metadata node to another Metadata file the OK button is never enabled

fixed

Warning icon is displayed when Designer is connected to a Runtime which version does not match exactly the designer's one even though it is compatible

fixed

Xml to Rdbms: base64Binary doesn't have a matching datatype

added

An Error icon is generated on Joins executed on Staging Area when the Integration Template does not support Load

added

A JDBC-ODBC Wrapper driver allows to replace JDBC-ODBC bridge on jvm 1.8 or higher

added

Cassandra support (through ODBC)

added

Conditional filters can be specified when integrating into specific targets

added

Error icon is added to target fields mapped on source and involving fields from 2 datastores joined in Staging Area

added

Hive support

added

HDFS support

added

Json Files and Rdbms Tables can be used as input or output of Processes

added

Meta-inf process-parameter-support allows to force an Action Parameter to be instantiated

added

New object added to Rdbms Metadata: Query

added

New button in the toolbar to expand/collapse all Datastores in a Mapping

added

New datatypes supported in XML Technology

added

Paradox support

added

Parstream support

added

The NO_LOAD setting can be specified from a Process Parameter using the Meta-inf tab

added

Tooltip is added to a Field when its name does not match the underlying column name

added

XSS parameter is increased in stambia.ini

fixed

An error is detected when setting an expression with an XML source containing a trailing space character

fixed

Defining a conditional join from the Properties View is not always effective

fixed

DataLineage: fields are not showed if they are not defined as visible in the Mapping diagram

fixed

Foreign key with no name is reversed twice

fixed

If an error is detected on a disabled Join or Filter the Mapping cannot be built

fixed

Link to non-alphabeticly named fields are not computed correctly for MSSQL sources when parsing an expression

fixed

Multiple editors can be opened on the same Process

fixed

NullPointerException when accessing the Advanced tab of a Join's Properties

fixed

NullPointerException raised when building packages with accentuated characters

fixed

Opening a Mapping while the Runtime is disconnected from the Designer may be slow

fixed

The error message of an inconsistent join location may disappear even though the problem is not really fixed

fixed

The expressions of Conditional Joins is not updated when changing a Datastore alias

fixed

Template Properties Popup is closed when selecting any element in a combo box

fixed

UnsupportedOperationException when closing a Mapping after having modified some Advanced Properties of Joins

fixed

Wrong DataSets computed after deleting a Join involving more than 2 Datastores

added

Process: Arrange All improvements

added

Performance improvements when using large Metadata files in a Mapping

fixed

Closing the properties popup of a Template may not work

fixed

Execute/Prepare a mapping ignores Open Automatically when the mapping has not been saved

fixed

NullPointerException when creating a metadata link from a node with no name defined

fixed

Oracle: Reject tables are not in the Reject Schema since S18.0.1

fixed

Opening a Mapping from a Process opens a new editor regardless if the Mapping is already being edited

fixed

Potential conflict when editing an Action parameter using both Expression Editor and Properties view

fixed

Sources Fields colored in light blue due to lineage are not uncolored when another field is selected

fixed

Selective Display is very slow to open on datastore with a lot of columns

fixed

Unable to create two instances of a VariableManager

fixed

Unable to undo the deletion of a Metadata Link from an action

added

Connection to the license server can be made through a proxy

added

Designer supports proxy based network connections

added

Oracle tables can be reversed and queried through a DB Link

fixed

Diagram layout is lost when copy-pasting a process from one project to another one

fixed

Errors in cache management prevents building mappings

fixed

NullPointerException when deleting an Action Parameter

fixed

NullPointerException when undoing the creation of a DataSchemaConfiguration

fixed

Runtime view may not list all the Runtimes

added

An extra-icon is added on overriden objects in the workspace

added

Designer's Views have tooltips

added

Datastore can be used as both source and target in Mappings

added

Datasets and Sourcesets are surrounded by a blue area to improve Mapping's diagram readability

added

Data lineage is displayed in a Mapping when selecting columns

added

Drag-and-drop of columns directly on a Mapping creates a Datastore with predefined Field Selector

added

Double-click on Sessions opens the Process if available in the workspace

added

Deleting a Stage pushes transformations to the Target

added

Field selector allows to reduce the number of Fields displayed in a Datastore

added

Loads are automatically mutualized when possible

added

Mappings are built incrementally

added

Mapping: drag-and-drop of a Schema on an orange arrow creates a Stage by reusing transformations

added

Mappings: orange arrows show data flows

added

Multi-target Mappings

added

Mappings support set-based operations (Union, Minus, etc.)

added

New objects in Mappings: Stage

added

New Join type: conditional joins allow reusing Datasets in Mappings

added

New button on a datastore to highlight its source datastores

added

New template type: STAGE

added

New view: Internal Resources

added

New context menu entry on Mappings: Export Models and Dependencies

added

Objects built out of a Mapping are visible as a child of the Mapping in the Project Explorer

added

Process or Mapping can be exported with all its required elements

added

Runtime view: labels "Connect" and "Refresh diagram" are clickable

added

StepDetail View displays line numbers

added

Selecting a Template selects all its instances in case of mutualized Loads

added

Templates are now displayed as boxes attached to their target Datastores

added

Technologies can be customized

added

Warning is displayed when a mapping with non-rdbms target is not executable

fixed

Scrolling and selection issues in the StackTrace window

fixed

Tooltip for Editors is too long

added

Json metadata can be reversed from Clipboard

fixed

md:paramValue($this, 'param') never returns an empty String

added

Add support for SAP Tables

added

Automatically select the Session when Executing/Preparing a Mapping or a Process

added

Double clicking on a Session opens the corresponding Process if available in the current workspace

added

JSON Metadata support Reverse

added

New template LOAD Sap OpenSql To Rdbms Oracle (With Sql Loader)

added

New JSON Technology

added

The Build context menu is available on Folders and Projects

added

The metaInf tag on a process parameter allows to create an XSL Variable corresponding to the parameter

added

The Cancel button is enabled when reversing RDBMS Datastores

fixed

A node has to be selected twice after renaming another node in the Metadata Editor

fixed

MSSQL: Size may exceed 53 when reversing FLOAT columns

fixed

The size of BOOLEAN after should be 1 when reversing HSQL databases

fixed

Views' columns are not reversed on Teradata

fixed

Wrong URL sample for the DB2 UDB driver

added

New popup message when trying to open an Xml file which does not exist

fixed

Column with name starting with a dollar sign is incorrectly generated

fixed

Displayed "Elapsed time" is not correct sometimes according to current time zone

fixed

The SUPPR key has no effect on metadata JDBC properties : Driver and URL

added

Add a Find/Replace utility to the Expression Editor

added

Expression Editor can be used to edit the text of the Notes

added

Expand automatically the node when Mapping an XML element or a WSDL element

added

File driver supports accentuated characters in column names

added

Keep track of previous selection when selecting datastores to reverse

added

Limit the height of Transformation and Transformation line when computing the default size of the File Properties Window

added

Metadata creation wizard is redesigned

added

Memory optimizations when opening a Process containing references to other Processes

added

Mssql: Datastores available through a Linked Server can be reversed

added

New statistic: SQL_STAT_MERGE

added

Place the cursor at the beginning of the Expression Editor when displaying the details of an element

added

Rdbms: Actions > Properties opens the Reverse category by default

added

StackTrace popup has a minimum size on opening

added

S3 technology: New property Physical Name on Buckets

added

Schema Wizard: better usability when removing a Work/Reject schema

added

Wizards creating child objects are in the New sub-menu instead of the Actions sub-menu

fixed

Arrange all works correctly only after arranging twice

fixed

Automatic Mapping does not work when the target is a File

fixed

Build a mapping fails when DROP_TABLE_IF_EXISTS is used

fixed

Copy/Paste Actions: relative locations are lost

fixed

Deprecated technology SCPOld is no longer displayed by default when creating new Metadata

fixed

Explicit Joins do not support circular references

fixed

Hide unused on a hierarchical source hides the root node

fixed

License check fails with "Error during contacting server" on some VPN on Mac OS X

fixed

Menu entry "Custom XPath" is missing when the context menu is displayed in the Metadata Editor

fixed

Mysql Bit datatype is not defined as default Bit datatype

fixed

NullPointerException may be raised when creating a new Parameter in a Process

fixed

New Parameter FTP_ENCRYPT_CHANNEL_DATA to FtpPut and FtpGet

fixed

Outer Column with Not In instruction doesn't work for filter or Join with implicit mode

fixed

Oracle technology: VARCHAR2 creation Mask generates columns with size 4000

fixed

ProjectExplorer: icons and labels of some Metadata may be missing

fixed

PostgreSql BIT Datatype does not have the correct superType (Char instead of Bit)

fixed

Typo : MaxOccurs value "unbouded" should be "unbounded"

fixed

Wrong outer expression generated when the expression contains SQL functions in an implicit Join

fixed

Links are broken in Welcome Page

added

Add support for drag and drop and a Metadata node from the Editor into another Editor (without dragging from the Project Explorer)

fixed

After renaming a Field by adding or removing space characters the Filter and Join expressions are not updated correctly

fixed

Mapping may be broken when moving Metadata

fixed

NullPointerException may be thrown when changing the Template used in a Mapping

fixed

NullPointerException when editing 2 parameters at the same time in 2 different editors

fixed

Postgresql: reverse NUMERIC columns generates NUMERIC(131089) metadata

fixed

Runtime Classpath may be too long on windows depending on the size of the current runtime path

fixed

Sometimes property fields need to be clicked twice before being enabled for typing

fixed

Sessions View: vertical scrollbar may disappear

fixed

Unable to locate shared library when starting Designer on Ubuntu 12.04

added

SAP Technology: some Properties are externalized by default

added

Web Services: reverse MIME content-type

fixed

A Metadata Link may have null label and error icon on creation

fixed

Designer hangs after deletion of the origin node of a sub Metadata File

fixed

Server Wizard : doesn't save information if closed before reverse

fixed

The Properties of a Configuration node are not displayed correctly

fixed

Unable to generate a WebService with xml metadata

added

Add support for data integration into Salesforce.com

added

Add support for data extraction from Salesforce.com

added

Add support for reverse in technology Salesforce.com

added

Bean Scripting Framework: Use dropdown list to specify language

added

Java Native Scripting: Use dropdown list to specify language

added

Line numbers are displayed in the Expression editor

added

LoadMask, IntegrationMask and RejectMask can be specified at Datastore level

added

Meaningful error message when a template with a wrong file ID is used in a Mapping

added

New technology: Salesforce.com

added

Sap Idoc Generation: add support for SEGMENT and BEGIN attributes

added

Variables defined at the root level of a Metadata are available on any node of this Metadata

fixed

An action or a sub-process may not be displayed correctly when a repetition query is defined

fixed

A binding with Teradata as the target does not support NULL values

fixed

Cache loading takes a very long time (designer seems to hang on startup)

fixed

Documentation error may be raised if the process is too complex

fixed

Default inner join mode is ignored and Implicit mode is always used

fixed

NullPointerException may occur when moving Actions

fixed

Process: the properties of metadata links are not correctly saved after edition in the Properties view

fixed

Runtime Session may not be updated in Designer

fixed

Reversing multiple times a File without any header may mix Fields in Mappings

fixed

Scrollbars are not displayed on Source or Target datastores or on Templates in a Mapping

fixed

Unable to create a second sub-process without renaming the first one

fixed

Wrong tooltips on Restart Point types

fixed

null keyword may be displayed in the StackTrace Popup window

fixed

tech:creationDdl() does not support the BIT datatype on Mysql

added

Add "gYearMonth" datatype to XML technology

added

Add "gYear" datatype to XML technology

added

Add "gMonthDay" datatype to XML technology

added

Add "gMonth" datatype to XML technology

added

Add "gDay" datatype to XML technology

added

Add "ENTITY" datatype to XML technology

added

Add "token" datatype to XML technology

added

Add "anyURI" datatype to XML technology

added

Add "NCName" datatype to XML technology

added

Add "unsignedShort" datatype to XML technology

added

Add "unsignedInt" datatype to XML technology

added

Add "nonPositiveInteger" datatype to XML technology

added

Add "nonNegativeInteger" datatype to XML technology

added

Add "negativeInteger" datatype to XML technology

added

Allow reverse engineering to run in background

added

Allow compilation to run in Background

added

Designer memory improvements

added

File: new property "Enable Left Trim on String Field" to specify if File driver removes leading spaces on Strings fields

added

File: new property "Disable Right Trim on String Field" to specify if File driver removes trailing spaces on Strings fields

added

File: new property "Default String Value" to specify a value to return by the File driver when an empty String field is detected

added

File: new property "Default Numeric Value" to specify a value to return by the File driver when an empty Numeric field is detected

added

File: new property "Default Timestamp Value" to specify a value to return by the File driver when an empty Timestamp field is detected

added

File: new property "Default Date Value" to specify a value to return by the File driver when an empty Date field is detected

added

File: new property "Trace Error To Bad File" to specify whether the File driver must log errors to the .bad files

added

File: new property "Return Null for empty String" to specify if File driver converts empty Strings to SQL NULL values

added

File: new property "Missing Fields" to specify the behavior of the File driver when some fields are missing on a record

added

File: new property "Trailing Fields" to specify the behavior of the File driver when extra fields are detected on a record

added

File: new property "Field Format" to specify the behavior of the File driver when a field is not formatted correctly

added

File: new property "Default Timestamp Format" to specify the format to apply on a Timestamp field no format is specified

added

File: new property "Default Date Format" to specify the format to apply on a Date field no format is specified

added

File: new property "Check Fields Size" to specify whether the File driver must consider length exceeding Fields as format errors

added

In a Mapping, a disabled constraint is displayed with a grey font

added

Mapping Editor: the properties of a Template can be displayed in a popup frame in the Mapping Editor

added

Multi-selection is supported when adding Datastores to a Mapping

added

Mapping and Process names are optional

added

New property databaseMajorVersion for RDBMS Servers

added

New function ref:container() returns a reference to a schema based on its name

added

New log file com.indy.reverse.log

added

New button to select existing tables when executing a reverse engineering

added

Normalize colors of selection and cross-reference of Source elements (fields, filters and joins)

added

New icon in the Project Explorer to identify unbuilt Mappings

added

New context menu entry: Build/Execute > Open Save and Close Mappings

added

New context menu entry "Replace usages by..." allows to replace a metadata by another in the workspace

added

Oracle technology reverses check constraints

added

Process editor displays a warning when multiple actions have the same name

added

Sort options alphabetically when using Arrange all

added

SqlToParameters: add SQL_TRANSACTION_NAME and SQL_TRANSACTION_TYPE to the Properties view

added

The name of a metadata can no longer end with white space characters

added

Update Tutorial to comply with Designer's layout

added

When comparing two files new buttons allow changes to be copied to the other file

added

When editing a Target Field directly in the diagram the "TargetFieldName -> " is no longer needed and only the expression has to be set

added

XSD annotations are reversed (documentation and appinfo)

added

databaseMajorVersion set to 8 or less disables automatically CHAR or BYTE keywords on Oracle servers

fixed

A Datastore cannot be deleted from a Mapping if it has first been deleted from the Metadata

fixed

Consult Data does not always connect to the database

fixed

Context menu Build > Documentation shouldn't be displayed for Mappings

fixed

Concat Files : option FILE_SEPARATOR not available in Properties view

fixed

Core Stack Trace Popup window does not format correctly the Exception

fixed

Consult Data (console) doesn't close the JDBC connection properly

fixed

Designer may hang when on startup when using SVN

fixed

Expression Editor is not refreshed when typing a mapping expression directly onto the target field

fixed

Executing a Process or a Mapping with the toolbar button may not work correctly

fixed

Filters and Joins do not use the same color as Source fields when selected

fixed

Multiple selection of Fields in a Mapping does not use the correct color

fixed

NullPointerException when opening Mapping if the template cannot be found automatically

fixed

Process Editor: StackTrace popup window is misplaced

fixed

Performance issue when executing a reverse on pureData Technology

fixed

Source fields may appear as not selected when they are selected

fixed

The Contents tab of the Customize View window contains twice the same entry for metadata

fixed

When viewing Step details for a for a prepared Session the Executed tab displays wrong information

fixed

When multiple elements are selected the Properties view shows some properties that cannot be changed massively

fixed

When switching back to the Expression editor does not always show the already selected Expression

fixed

Wrong icon used for Metadata in the Contents tab of the Customize View window

fixed

When opening a Mapping with a Hierarchical Target Datastore the color of a Target Field is incorrect until one of the fields is expanded/collapsed

fixed

Wrong font color after editing directly a Target Mapping

fixed

XML driver fails to load shouldn't expose XML integers as standard SQL integer because its size is too small

added

"Click on the area to display" is replaced by "Click here to display the step detail"

added

Improved Mapping rendering

added

Renaming "Execution" menu to "Build/Execute"

fixed

A Process generated out of a Mapping is displayed as modified when opened for the first time

fixed

ClassNotFoundException when executing Actions > Consult data (console) on a flat file

fixed

Hide the tooltip on a target field when no mapping expression is defined

fixed

NullPointerException may occur when displaying the stack trace of an Action

fixed

Popup tool error icon action remains in process editor after step deletion

fixed

When F1 key is hit on certain Actions, the contextual help displayed is not corresponding to the selected action

added

"Md Model" is renamed "Metadata Model" in the Metadata creation window

added

"Create a new Md model" is renamed "Create a new Metadata Model" in the Metadata creation window

added

+/- icons to expand/collapse the Parameters and Metadata Links on Actions are replaced by buttons on the top of the selected Action

added

Ability to select a configuration when executing from the Navigator a multi-configuration delivery built with Analytics 2.1.0

added

An icon on the top of Actions replaces the dotted lines around the Action if a Generation condition is specified

added

Add BIT and LOGTEXT datatypes on MySQL technology

added

An Action is displayed as a stacked shape if a repetition query is specified

added

A Mapping must be saved prior to be executed

added

Automatically expand the root node of a hierarchical Datastore when adding it to a Mapping

added

Ability to select a configuration when scheduling a multi-configuration delivery built with Analytics 2.1.0

added

Add a border around the list of Tags

added

Add a border around the Expression in the Expression Editor

added

A ',' is used as the default file separator on non-French environment instead of a ';'

added

A parent XML field is displayed in blue to inform that at least one child (or grand child) node is mapped

added

Add an icon on the table to show if a display filter is activated on columns

added

By default the content of the *.map and *.proc are not displayed in the Project Explorer (this can be overridden from the "Customize View..." menu)

added

Bind links can be designed only between actions for which the Bind is supported by the Runtime

added

Back quote is used as the object delimiter on Mysql instead of double quote

added

Copy-paste of an action creates the new action at the location of the mouse

added

Configuration editor has an embedded editor for the Properties of a node

added

Display the short name of a Parameter in the Project Explorer instead of the full path

added

Directory Wizard is automatically launched when creating a new File Server

added

Do not look for Column names when checking an Expression executed on Target

added

Dynamic Name and Is Begin Action properties are moved to the "Advanced" tab

added

Display the Runtime view by default in the Stambia's perspective

added

Designer's memory management is enhanced

added

Drag and dropping a parameter of an Action moves the Action

added

Elements of the Generic technology can now be typed

added

Files extensions are hidden by default (this can be changed from the Project Explorer's view menu)

added

Getting Started is replaced by a new Tutorial: Stambia Fundamentals

added

Hide the links in the Project Explorer when expanding the nodes of a Process

added

Hierarchical source or target Datastores can be filtered to display only Mapped/Unmapped columns

added

Input, Output and Fault checkboxes are grouped into a "Publication" tab

added

List of schema is sorted in the Rdbms reverse Wizard

added

Metadata editor has an embedded editor for the Properties of a node

added

New layout and colors in an executed Process

added

New context menu "Move" on a Metadata Node (eg. on a Datastore) in the Project Explorer to move the node to a new Metadata

added

New button on the top of an Action executed with errors to display the Stack Trace

added

New button on the top Actions with Parameters specified allows to show/hide the Parameters

added

New button on the right side of the selected Action to enable/disable the Action

added

New button on the right side of the selected Action to edit the Restart Point Type property

added

New button on the right side of the selected Action to edit the Error Tolerated property

added

New button on the right side of the selected Action to edit the is Begin Action property

added

New button on the top of the selected Action to specify the Generation condition

added

New button on the left side of the selected Action to edit the Parameters of the Action

added

New button on the bottom of the selected Action to draw links starting from this Action

added

New graphical design of Actions

added

New toolbar button to hide all parameters and metadata links

added

New Rdbms Technology: Oracle RDB

added

New context menu: Advanced > Reinit Process diagram

added

New column "Configuration" in session list

added

New property "Use Json Format" on XML root elements

added

New Tutorial: Working with XML Files

added

New Tutorial: Invoking WebServices

added

New preference "Diagram refresh enabled by default" to manage the default value of the "Refresh Diagram" checkbox

added

New button on the left side of the selected Action to add new Parameters to the Action

added

Object delimiter is systematically added MySQL object names

added

Open With > Other... Editor list is updated

added

Process Parameters can have a Label different from their technical name

added

Process editor: Arrange all will stack all the Metadata links on a same column

added

Place the cursor after the prompt when a runtime command is executed

added

Runtime editor has an embedded editor for the Properties of a node

added

The button Open mapping on an Action is replaced by an iconic button on the left side of the Action

added

The tab Appearance is removed from the Property View when an Action is selected

added

The dotted line on a Link is replaced by an icon at the beginning of the Link if a Generation Condition is specified

added

The resize of an Action is made from the corner of the optional border displayed when the Action is selected

added

The round at the beginning of a Link is removed

added

The pop-up icons are no longer displayed when the mouse is left over an Action

added

The target shape of a Link depends on its Triggering Behavior

added

The replacement of a target XML datastore ignores the root element name when remaping the columns

added

The "..." buttons are renamed into "Browse" buttons in the XSD Editor

added

The build and execution menus items are refactored to be consistent between the Project Explorer and the diagram editor

added

The type of a child node of a process is no longer displayed in the Project Explorer

added

The list of configurations is sorted

added

Using the "Open with" menu to open an object with a specific editor no longer sets it as the default editor for this object

added

When reversing a File the date format is automatically reversed

added

When reversing a File the timestamp datatypes and their formats are automatically reversed

added

When a datastore is deleted from a Metadata, only the datastore is listed in the Problems for the Mappings using it and not each field

fixed

Add a border around the "Verb" attribute of a WSDL Port

fixed

ArrayOutOfBoundException when reversing a Positional File containing lines below the expected length

fixed

Adding a missing source Datastore does not update the errors/warnings of the Mapping

fixed

An error occurs when canceling Documentation generation

fixed

CTRL+X in the Properties view deletes the selected node being edited instead of cutting the currently selected text in the Properties view

fixed

Collapsing a parent node of a hierarchical datastore only hides the direct children

fixed

Compilation fails when Numeric datatypes from Oracle and SQL Server are used in the same Mapping

fixed

Changing the alias of a Source datastore does not refresh the warnings/errors

fixed

Cut and Pasts Actions with parameters creates Parameters on the Process

fixed

Cut and Paste of an Action reverts the Parameters to their default values

fixed

Copy Paste of Actions and Metadata Links does not paste the Metadata Link

fixed

Copy paste an Action with a Metadata Link may move the Metadata Link from the Action to the Process

fixed

Copy-Paste of a Note does not work in the Process editor

fixed

Diagram layout is lost after undoing the deletion of a Process or a Mapping

fixed

Designer user's guide does not use the same layout defined as the rest of the product documentation

fixed

Diagram is in error after a copy-paste of a Mapping within the Project Explorer

fixed

Del key is ineffective when a link is selected

fixed

Deleting a Variable in a Mapping does not refresh the errors/warnings

fixed

Extra character in Designer's reference: extract@

fixed

Error occurs when using the context menu Transform Last Delivery To File

fixed

Error occurs when closing the Properties view and re-open it from the "Show Properties View" context menu

fixed

Execute opens the Process of the Mapping: only Open and Execute should open the Process

fixed

Foreign keys with multiple columns are not reversed correctly

fixed

Foreign keys are not reversed correctly on DB2 UDB

fixed

FtpCommand: Proxy parameters are repeated twice

fixed

Field positions are lost when replacing the target Datastore in a Mapping

fixed

Inconsistency on child nodes between All, Sequence and Choice nodes in a WSDL metadata

fixed

Inconsistent behavior when renaming an object currently being edited

fixed

Links are not copied during a copy-paste operations on the Actions

fixed

Node name is not updated dynamically when renaming a node in the Metadata editor if the Name and Schema Name differ

fixed

NullPointerException when opening a Process from the Search view

fixed

Parameters set by a MetaDataLink are not highlighted until the Action is moved in the diagram

fixed

Package generation error when number of Parameters is greater than 127

fixed

Passwords are not hidden in the Configuration edition

fixed

Read Mail Action doesn't propose the correct default value for some of its parameters

fixed

Rhino samples provided in the documentation use a reserved word

fixed

Renaming or deleting a Metadata used by a Mapping under edition closes the Mapping editor

fixed

Right mouse click does not display the context menu if another object is selected

fixed

Reverse Positional File: Changing positions automatically reloads the File

fixed

Source and/or Target columns can be dragged and dropped from one datastore to another datastore

fixed

SubProcess Actions are missing the "Core" tab in the Properties view

fixed

SqlToParameters: support for Long is not documented

fixed

Schema wizard and Server Wizard do not use the same Window size

fixed

Switching from the Expression Editor to another view and switching back to the Expression editor forces to select the Action again to see its content

fixed

Switching from the Property view to another view and switching back to the Property view forces to select the Action again to see its properties

fixed

The Del key does not produce the same result as CTRL+X: deletion cannot be undone without errors

fixed

Typo in the XML Wizard: "Revere" should be "Reverse"

fixed

Typo in Designer user's guide: p(..

fixed

The Reverse helper of a File does not support the timestamp datatype

fixed

Typo in the name of the "Miscellaneous" accordion

fixed

The first time the properties of an Action are scrolled down in the Properties View they disappear shortly

fixed

The Documentation is not displayed correctly in Internet Explorer 8

fixed

The position is mandatory in the Reverse Helper of a Delimited file

fixed

Unable to Execute a Process on an existing Workspace on Linux

fixed

Unable to expand the node of an object in error in the Project Explorer

fixed

Unable to delete a link having another link as a source

fixed

Unable to move the anchor of a link on the Parameters of an Action

fixed

Unable to execute a Mapping from the Project Explorer

fixed

Undoing the deletion of a target Datastore does not restore the Templates that were selected

fixed

Updating a Metadata does not automatically update the Mappings under edition

fixed

Wrong type of node restored after undoing a "Change to"

fixed

When adding a missing Variable to a Mapping the errors/warnings are not updated

fixed

Wrong column order used in Target columns for XML Datastores

fixed

When creating a WSDL Metadata the Finish button is not always enabled

fixed

When replacing the target Datastore the fields that cannot be found in the new Datastore are not in error

fixed

When renaming a field in a metadata, the children fields are not updated accordingly in the Mappings

fixed

When multiple Metadata editors are opened the properties view is not refreshed correctly

fixed

tech:rejectMessage() doesn't handle simple quotes

added

Generate XSD dialog looks for an xsd file instead of an xml file

added

Increase the default size of Directory and File wizards to see at least 4 lines in the Preview panel

added

In the Process editor, display the Parameters of the Templates and Actions in the Standard tab of the Properties view

added

New Generic technology

added

Support reverse of Foreign Keys across different logical schemas based on the same physical schema

added

The name of a Connection no longer requires to end with .rdbms, .file, etc.

added

The description of a Process is moved to a dedicated tab in the Properties view

added

When creating a new Metadata the user is prompted for a metadata name instead of the file name

added

XSD generation allows to select another encoding when the default encoding does not comply with XML file's encoding

added

XML File Wizard : launch automatically when creating a new XML Metadata

fixed

Charset Name is ignored in the File editors

fixed

Deletion of an Action Parameter with "Del" key cannot be undone

fixed

Foreign key is reversed twice when the parent table is not reversed

fixed

HSTORE datatype is missing on Postgresql

fixed

New option "Hide Files Extension" in the Project Explorer's menu

fixed

NullPointerException when reversing an XML file without refreshing the root elements first

fixed

NullPointerException when reversing a WSDL with a namespace

fixed

Performance issue when saving a Mapping with a very complex expression

fixed

Runtime connection Retry time does not wait the specified number of seconds

fixed

Rejects detection code for Foreign Keys is sometimes not generated

fixed

The file wizard of the XSD Generator looks for an xml file instead of an xsd file

fixed

XML Path is deleted when reversing a root element twice

added

All SSH Servers' properties are externalized by default

added

New property SSH_TIMEOUT on SSH Servers (expressed in milliseconds)

added

New property SSH_PASSWORD_PHRASE on SSH Servers (password to decrypt the private key file)

added

New property SSH_PRIVATE_KEY_FILE on SSH Servers (path to the private key file)

added

When editing the foreign keys, add new properties in order to select the parent table of a foreign key and filter the available columns

fixed

Oracle Materialized View Columns are reversed twice

fixed

When setting a property for the first time, the label of the object's node didn’t refresh properly

added

Add README.txt File

added

Add "datetime2" datatype to MSSQL technology

added

New Rdbms Technology: Vertica

fixed

"All" nodes in a WSDL definition cannot have "element" as a child

fixed

Metadata is deleted from workspace when saving a mapping with same name in the same folder

fixed

On an implicit outer Join on Oracle, the keyword "(+)" is not automatically added within "is null" or "is not null" expression

fixed

Schema cannot have "no" in the physical name, "no" disappears with code generation