Welcome to Semarchy Convergence for Data Integration.
This document provides the latest information about this Semarchy Convergence for Data Integration Release, including new features and bug fixes.

New in version 3.3.0

Usability and productivity

This version improves the usability of Processes by adding new visual indications on Process Actions for metadata links. The user is now informed:

  • When a parameter is set by a Metadata Link and which one.

  • For each parameter, which type of Metadata Link can be used to fill its value.

Metadata Possible Actions

A dialog box showing all the applicable Actions is shown when drag and dropping a Metadata in a Process. This allows for creating automatically the correct Action:

Switch Left/Right Parts of a Join in a Mapping

It is now possible to switch the left and right part of a join with a simple click in the join property inspector.

Replace Target by a Stage

Drag and dropping a schema on a target datastore replaces it by a stage.

Compact Mode on Double-Click

In a Mapping, a double click on a datastore switches it from compact/full mode:

Configuration Icon

Configurations in Metadata are better identified with the addition of a new icon decorator.

File Driver

Property fields

This version introduces a new specific field in File Metadata, called Property Fields.
The Property fields are used to retrieve information about the file such as the file size, path or parent path. It allows also to retrieve or write directly the binary/string content of a file.

Multi-file

The File Driver has been updated to support reading data from multiple files at the same time with using file masks.

Templates documentation

The documentation available in the installed templates is now automatically exported to the Help Contents of the Designer. It is generated on the fly from the Templates descriptions and can be accessed from Help Browser and from the Project Explorer under each template.

In mappings and processes, selecting a template and pressing F1 opens its help. You can also access the documentation directly from mappings and processes by moving the mouse cursor over the template’s parameters

Publishing JSON Web Services

The new Runtime version (S17.3.0) shipped with this version introduces a new HTTP REST endpoint allowing to publish deliveries as REST Services using JSON inputs/outputs. This endpoint is available from http://<hostname>:<port>/rest/StambiaDeliveryService/2/<deliveryName>;.

Other improvements

Stop bind on error

When one of the iterations of a bind fails, the bind stops and throws an error. To let all the iterations run even when an error occurs in one of them, uncheck the Stop Bind On Error parameter in the Advanced tab of the target Action.

Built files location

The .indy.build folder, used to store the Mappings and Processes built files, was previously created and stored in each Project.

This version introduces a new location to simplify and optimize its management: All the built files for a workspace are now centralized under a .indy.build folder at the root of the workspace. However, users still see and manage the built files inside each project in the Designer.

New in version 3.2.0

Mapping Capabilities

Multi-target Mappings

Mappings can now have multiple targets, for example to load multiple tables from a hierarchical datastore such as an XML File in a single mapping. This feature can also be used to load a parent-child set of tables from a single source.

Datastore as Source and Target

A same datastore can now be used as a source and as a target in the same mapping. This allow designers for example to invoke a web service and integrate its response in the same mapping.

Set Based Operations Support

Convergence for Data Integration now supports the use of set operators such as UNION, MINUS, etc.

Stages

A new object is added to the mappings: the Stage. This object extends the capabilities of Convergence for Data Integration by allowing the execution of transformations on any schema before integration in the target datastore.
This feature has various usages. Stages simplify mappings by splitting complex transformations into more manageable pieces or by mutualizing an expression reused in multiple transformations.

Stages allow for easy creation of file to file mappings. They are also used to create temporary tables on the fly without having to reverse-engineer them. You can use stages to process data in the source systems before aggregation in order to reduce the volume of data transferred on the network.

Optimizations

Mutualized Loads

When Convergence for Data Integration detects that Load phases can be mutualized in a mapping, it loads once and reuses the same data for several targets. This provides dramatic optimization for loading XML file into multiple targets.

Conditional Joins

A conditional join allows you to split a dataset into several parts and allows use each of them for a different dataset. This will simplifies the most complex mappings, also allows for loading a subset of a dataset only once and reuse this result to integrate multiple tables.

Usability and Productivity

Datasets and Sourcesets

Convergence for Data Integration introduces the notions of Sourcesets and Datasets which appear as blue areas in the mappings. They group tables that participate to the integration for a same target. Orange links between these zones and their target datastores provide better readability for the mapping diagram.

Easy Creation of Stages

The creation of a stage in an existing mapping can automatically take over existing transformations and push them to the stage. This simplifies adding set-based operations on an existing mappings.
This features prevents duplicating complex expressions in a mapping. When deleting a stage, expressions are automatically pushed to the target datastore to avoid losing them.

Data Lineage

When selecting a column in a mapping, dotted lines show the data lineage from and to this column. It becomes very easy to perform impact analysis even in a complex mapping.

Source Tables Highlights

It is possible to highlight the possible sources and the current sources of a table and focus only on what is relevant when designing complex mappings.

Field Selector

When working with large datastores you have the ability to hide some of the fields to keep the focus on the relevant ones. To improve even more your productivity, you can drag and drop to the mapping the interesting fields. This automatically adds the datastore with a predefined field Selector set to these fields.

Templates Location

Templates in a mapping are now attached to their target datastore. Each template appears with an icon on the upper right corner of the datastore. In addition when you select the load template for a mutualized load, it is highlighted for each load that participate in this mutualization.

Other Improvements

Double-click on Sessions

To open the process corresponding to a session, you can double click the session itself. If the corresponding process (or mapping) exists in your workspace it will automatically open.

New Staging Template

New STAGING templates are added to support stages.

Internal Resource

The ".tech" project has been replaced by a new "Internal resource" view. This view allows to navigate the different technologies and import them into the workspace for customization.

Incremental Build

Mappings can be built automatically as a background process and not only at startup.

Easy Mapping Export

When exporting a mapping all the required objects can now be automatically exported to facilitate the exchange with your colleagues and our support.

Convergence for MDM Template Updates

Submit Load process template now supports synchronous mode to wait for the MDM Job to complete. GetLoadID, Submit Load and Cancel Load process templates now support variables used in their parameters. Convergence for MDM Integration Template now supports "Skip Unchanged Record" option to enable the comparison between the incoming flow and the existing master records and avoid integrating records that have not been changed.

Change Log

Version 3.3.0 (3.3.0-GA_Build18.2.0)

New Features

Designer
  • 18.2.0.1784 - Ability to undo changes (Ctrl+Z) inside a SQL Editor

  • 18.2.0.1465 - Add Google Sheet driver in SQL Explorer preferences

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

  • 18.2.0.2125 - Base64Binary are converted to LONGBLOB on MySQL technology

  • 18.2.0.2236 - New technology: BSON

  • 18.2.0.2258 - Elastic Search: Indexes can be reversed from their aliases

  • 18.2.0.2265 - Improve the tools to make easier the development of new Java based technologies

  • 18.2.0.2283 - XslVariable have now a visibility attribute

  • 18.2.0.2352 - Salesforce add possibility to filter during select

  • 18.2.0.2394 - New technology: Oracle BI

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

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

  • 18.2.0.2117 - New checkbox StopBindOnError in the Advanced tab of Actions

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

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

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

  • 18.2.0.2146 - Elastic search: Add support for selective reverses

  • 18.2.0.2162 - Built files are now stored at the root of the workspace

  • 18.2.0.2179 - Improve loop detection in Computed Fields expressions

  • 18.2.0.2243 - Datastore Tags are displayed on the Diagram

  • 18.2.0.2244 - Tag icon is displayed on source Fields

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

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

  • 18.2.0.2271 - ActionCode and Action Parameter can now be encrypted

  • 18.2.0.2289 - Templates documentation is exported to the Help Contents of the Designer

  • 18.2.0.2324 - Performance improvements for rebuild cache

  • 18.2.0.2353 - Show The ActionCode non-mandatory parameters initialized by MetaDataLink

  • 18.2.0.2359 - The Configuration selection box in the toolbar can be resized in the preferences

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

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

  • 18.2.0.2363 - 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

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

  • 18.2.0.2365 - Process: the size of the error message popup window is saved

  • 18.2.0.2392 - Performance improvement of Oracle reverses

  • 18.2.0.2402 - Create a Menu Entry on Duplicated Resource to reveal the active Resource

  • 18.2.0.2404 - Improve the Replace Metadata popup

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

  • 18.2.0.1140 - Sybase IQ supports Full and cross joins

  • 18.2.0.2133 - Standardization of Severity Levels on Rdbms constraints

  • 18.2.0.2134 - HDFS: add support for Command line over SSH

  • 18.2.0.2135 - New technology: Sqoop

  • 18.2.0.2136 - HDFS: both WebHdfs URL and Httpfs URL can be specified

  • 18.2.0.2137 - Hive: Add precision and scale to DECIMAL creation mask

  • 18.2.0.2139 - Vertica: add missing datatypes

  • 18.2.0.2156 - New XPath expression on tables: ref:ak()

  • 18.2.0.2291 - New technology: Progress Open Edge

  • 18.2.0.630 - New shortcut to rename Process Actions: F2

  • 18.2.0.1224 - MacOS: embedded Runtime is generated inside the application package

  • 18.2.0.1315 - MacOS: add the integrated property editor to metadata editor

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

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

  • 18.2.0.1926 - Runtime view: remember the last connected Runtime when the Designer was closed

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

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

  • 18.2.0.2114 - File Wizard: Physical Name of Fields is checked for uniqueness

  • 18.2.0.2144 - Excel metadata: set JDBC.BIND.MANAGE_SET_NSTRING_AS_STRING by default

  • 18.2.0.2167 - Display error when the error is on a link’s execution condition

  • 18.2.0.2195 - Send Mail action handles Mailing List metadata links

  • 18.2.0.2246 - New action: AMQP Operation

  • 18.2.0.2247 - New action: AMQP Receive File

  • 18.2.0.2248 - New action: AMQP Receive Message

  • 18.2.0.2249 - New action: AMQP Send File

  • 18.2.0.2250 - New action: AMQP Send Message

  • 18.2.0.2366 - Bigger stack trace popup

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

  • 18.2.0.2399 - New shortcut to access templates documentation: F1

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

Runtime
  • 17.3.0.2382 - Embedded HSQL engine is upgraded to 2.3.4

  • 17.3.0.2380 - REST Web Services can now be customized with the use of a new META-INF property: httpRestWebServiceProperties

  • 17.3.0.2371 - REST web services endpoint: get parameter values from URL path

  • 17.3.0.2344 - "get trigger" commands are renamed to "get schedule" commands

  • 17.3.0.2335 - Xml To Jdbc a "choice" with "macOccurs=-1" doesn’t fill all records

  • 17.3.0.2332 - Scheduler: Allow to specify a custom name for a Schedule

  • 17.3.0.2317 - XmlToJdbc: new SPLIT_PATH and SPLIT_NB_ELEMENT properties to split the input XML file

  • 17.3.0.2316 - XmlToJdbc: new NB_WRITER property to launch multi thread writing

  • 17.3.0.2288 - Load Xml To Jdbc Improve performance

  • 17.3.0.2287 - HTTP Rest web service invocation: http headers can be specified as Parts with the new http:header binding type

  • 17.3.0.2285 - XmlToJdbc Action: add FILE_EXPORT_PROPERTIES to write files instead of datastores

  • 17.3.0.2276 - Web Services: New REST endpoint #2 supports JSON input/output

  • 17.3.0.2274 - Add the possibility to encrypt action code

  • 17.3.0.2227 - Add support for BSON technology

  • 17.3.0.2171 - ctx has a new method getJsonUtils() helping reading and writing of JSon data in scripting

  • 17.3.0.2108 - purgeLog.sql: add DELETE statements for new tables in this sample script

  • 17.3.0.2107 - File Driver: add support for reading and writing string or binary content (raw mode)

  • 17.3.0.2106 - File Driver supports reading multiple Files using a mask in the file name

  • 17.3.0.2086 - Add support for AMQP technology

  • 17.3.0.2074 - Rest Web Service invocation supports non structured data (binary, textual, etc…​)

  • 17.3.0.2061 - File: new property "Physical Size" on Fields to specify the size in bytes

  • 17.3.0.1978 - Runtime as Windows service: service log files are now rotated

  • 17.3.0.1974 - Add Directory Scan for File Repository and web service

  • 17.3.0.1973 - Exposed Web Services support HTTP repository to retrieve the delivery information

  • 17.3.0.1491 - SAP Connector: new action SapAbapExecute

Bug Fixes

Designer
  • 18.2.0.2212 - Mapping appearing in error after deleting the map.tech file from technology project

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

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

  • 18.2.0.2210 - Error Popup after closing and restoring Properties View

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

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

  • 18.2.0.2349 - Missing Filter MdNode on Integration when Filter on WRK and using Conditional Joins

  • 18.2.0.2338 - Xml to jdbc using a MultiSet Stage between them doesn’t work correctly

  • 18.2.0.2369 - Incorrect alias word generated for Multi Connection Integration step

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

  • 18.2.0.2395 - Oracle reverse: Check constraints are not reversed

  • 18.2.0.2396 - With an Xml source filter on staging area doesn’t work

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

  • 18.2.0.2095 - Renaming an opened Process or Mapping might cause a diagram loss

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

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

  • 18.2.0.2119 - Status Line error message is not refreshed on Field selection

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

  • 18.2.0.2132 - Copy/Paste a parameter modifies a Process in readOnly mode

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

  • 18.2.0.2142 - Impact View: Source/Target icon is no longer displayed

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

  • 18.2.0.2145 - ConcurrentModificationException may be raised when selecting a Metadata Node

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

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

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

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

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

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

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

  • 18.2.0.2325 - Copy/pasting multiple Metadata nodes might fail

  • 18.2.0.2341 - Improve CrossRef Errors when eltID does not match its fileID

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

  • 18.2.0.2407 - Memory leak when deleting an object from an Editor

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

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

  • 18.2.0.2423 - Unable to open InternalResource from Impact Analysis View

  • 18.2.0.2431 - Bad ToolTip when adding a Mapping Ref within a Process

  • 18.2.0.1219 - tech:onWrk() always returns false

  • 18.2.0.1976 - Selected configuration is not applied when the metadata’s file is located outside the workspace

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

  • 18.2.0.2100 - Session view: LaunchMode column displays ExecutionMode and vice-versa

  • 18.2.0.2131 - Wrong code generation when columns/fields have special characters

  • 18.2.0.2138 - Hive: VARCHAR creation mask is missing a parenthesis

  • 18.2.0.1247 - MacOS: issues with the application’s icon

  • 18.2.0.1830 - Reverse mssql: varchar(max) are reversed as varchar(2147483647)

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

  • 18.2.0.2112 - Generated documentation is missing the physical name of tables

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

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

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

  • 18.2.0.2345 - Help crash with Java 8u91+

  • 18.2.0.2381 - Postgresql: add Array datatype variant

  • 18.2.0.2237 - Add JdbcOdbcDriverWrapper to the technologies having an ODBC driver<br><div class="changelog-download-button-area">

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

Runtime
  • 17.3.0.462 - Missing parameters in the Help Command

  • 17.3.0.1998 - Schedule Cron expression starting with a space raises an exception when trying to edit from the navigator

  • 17.3.0.2000 - Typo in the get triggers command: prugeunit should be purgeunit

  • 17.3.0.2113 - Action Bind: it is now possible to continue execution if an iteration fails - see #2117

  • 17.3.0.2124 - Performance issue when reading base64Binary XML data

  • 17.3.0.2147 - Performance issue on File Move when using Includes/Excludes on a directory containing a large number of sub-directories

  • 17.3.0.2149 - Performance issue on File Copy when using Includes/Excludes on a directory containing a large number of sub-directories

  • 17.3.0.2150 - Performance issue on File Delete when using Includes/Excludes on a directory containing a large number of sub-directories

  • 17.3.0.2151 - Performance issue on SCP Send when using Includes/Excludes on a directory containing a large number of sub-directories

  • 17.3.0.2152 - Performance issue on SCP Get when using Includes/Excludes on a directory containing a large number of sub-directories

  • 17.3.0.2153 - Performance issue on File Wait when using Includes/Excludes on a directory containing a large number of sub-directories

  • 17.3.0.2154 - Performance issue on Untar when using Includes/Excludes on a directory containing a large number of sub-directories

  • 17.3.0.2155 - Performance issue on Unzip when using Includes/Excludes on a directory containing a large number of sub-directories

  • 17.3.0.2220 - Missing method when Calling a web service with JSON on AIX

  • 17.3.0.2222 - When using publishVariable with realTimeReport=true the variable does not appear in Analytics

  • 17.3.0.2238 - Creating a schedule raises an error when a previous schedule was deleted on the same delivery

  • 17.3.0.2328 - The WSDL descriptor file of the Soap Web services should not contain JSON Web services

  • 17.3.0.2329 - The responses of the REST Web services do not contain the content-type header

  • 17.3.0.2334 - File driver: StackOverflow when big number of rejects

  • 17.3.0.2340 - java.sql.SQLException: No suitable driver when using the JDBC-ODBC Bridge Wrapper

  • 17.3.0.2351 - Jython script fails when using "import" command

  • 17.3.0.2372 - REST web services endpoint: fixed error message when number of input metadata is > 1

  • 17.3.0.2383 - Soap web service call: error raised when response contains xsi:type and type attributes

  • 17.3.0.2387 - Bind with FileWait as a source: target action is sometimes not executed

  • 17.3.0.2393 - Sessions suddenly appear as prepared but cannot be executed, forcing to restart the Runtime

  • 17.3.0.2405 - Blob Datatype to Base64Binary conversion, one byte is missing

  • 17.3.0.2425 - SSH action: errors when used as bind target

  • 17.3.0.2426 - Jython script fails when using import command on Java class

Analytics
  • 2.1.2.2130 - No statistics is displayed on a new installation

Version 3.2.0 (3.2.0-GA_Build18.1.0)

New Features

Designer & Runtime
  • DI-64 - Submit Load process template now supports synchronous mode to wait for the MDM Job to complete.

  • DI-63 - GetLoadID, Submit Load and Cancel Load process templates now support variables used in their parameters.

  • DI-58 - Convergence for MDM Integration Template now supports "Skip Unchanged Record" option to enable the comparison between the incoming flow and the existing master records and avoid integrating records that have not been changed.

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

  • 18.1.0.1695 - Improve Problems Tooltips messages

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

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

  • 18.1.0.1822 - Expression Editor auto-completion improvements

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

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

  • 18.1.0.2065 - 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

  • 18.1.0.1939 - Outline view allows to search Datastores of Mappings

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

  • 18.1.0.1941 - Computed fields can be defined on a Datastore

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

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

  • 18.1.0.1985 - Metadata editor: ability to filter Metadata by name

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

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

  • 18.0.5.1994 - 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

  • 18.0.4.1852 - Memory enhancement when building Workspaces with large Metadata files and Mappings

  • 18.0.4.1471 - Impact View: automatically expand the first level

  • 18.0.4.1745 - Json: File Path property is externalized by default

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

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

  • 18.0.4.1701 - Automapping on hierarchical datastores maps only Fields in the current level

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

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

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

  • 18.0.4.1806 - Add support for ElasticSearch

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

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

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

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

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

  • 18.0.3.1624 - New object added to Rdbms Metadata: Query

  • 18.0.3.1632 - Hive support

  • 18.0.3.1633 - HDFS support

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

  • 18.0.3.1656 - Cassandra support (through ODBC)

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

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

  • 18.0.3.1662 - Conditional filters can be specified when integrating into specific targets

  • 18.0.3.1669 - XSS parameter is increased in stambia.ini

  • 18.0.3.1676 - Paradox support

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

  • 18.0.3.1680 - Parstream support

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

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

  • 18.0.3.1672 - New datatypes supported in XML Technology

  • 18.0.2.1603 - Process: Arrange All improvements

  • 18.0.2.1611 - Performance improvements when using large Metadata files in a Mapping

  • 18.0.1.1448 - Connection to the license server can be made through a proxy

  • 18.0.1.1588 - Oracle tables can be reversed and queried through a DB Link

  • 18.0.1.1527 - Designer supports proxy based network connections

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

  • 18.0.0.1267 - StepDetail View displays line numbers

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

  • 18.0.0.1556 - New view: Internal Resources

  • 18.0.0.1557 - Technologies can be customized

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

  • 18.0.0.1314 - Process or Mapping can be exported with all its required elements

  • 18.0.0.1338 - Runtime view: labels "Connect" and "Refresh diagram" are clickable

  • 18.0.0.1384 - Designer’s Views have tooltips

  • 18.0.0.1539 - Multi-target Mappings

  • 18.0.0.1540 - Datastore can be used as both source and target in Mappings

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

  • 18.0.0.1542 - New objects in Mappings: Stage

  • 18.0.0.1543 - Loads are automatically mutualized when possible

  • 18.0.0.1544 - New Join type: conditional joins allow reusing Datasets in Mappings

  • 18.0.0.1545 - Datasets and Sourcesets are surrounded by a blue area to improve Mapping’s diagram readability

  • 18.0.0.1546 - Mappings: orange arrows show data flows

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

  • 18.0.0.1548 - Data lineage is displayed in a Mapping when selecting columns

  • 18.0.0.1549 - New button on a datastore to highlight its source datastores

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

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

  • 18.0.0.1552 - Templates are now displayed as boxes attached to their target Datastores

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

  • 18.0.0.1555 - New template type: STAGE

  • 18.0.0.1558 - New context menu entry on Mappings: Export Models and Dependencies

  • 18.0.0.1560 - Mappings are built incrementally

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

  • 18.0.0.1563 - Deleting a Stage pushes transformations to the Target

  • 17.2.14.1647 - New REST URL supports publication of Web Services with unwrapped endpoints

  • 17.2.14.1683 - Google Spreadsheet: new command line utility to get Oauth2 access_token and refresh_token

  • 17.2.13.1589 - SqlOperation: when BatchSize is set to 0 runtime does not use the addBatch() JDBC method

  • 17.2.12.1517 - Json metadata can be reversed from Clipboard

  • 17.2.12.1456 - Google Sheet driver: add support for latest GoogleSheet format

  • 17.2.12.1504 - Oauth is supported

  • 17.2.12.1518 - Google Spreadsheet driver supports Oauth2

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

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

  • 17.2.11.1488 - The metaInf tag <xslVariableName> on a process parameter allows to create an XSL Variable corresponding to the parameter

  • 17.2.11.1489 - The Cancel button is enabled when reversing RDBMS Datastores

  • 17.2.11.1390 - The Build context menu is available on Folders and Projects

  • 17.2.11.1496 - Add support for SAP Tables

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

  • 17.2.11.1498 - New JSON Technology

  • 17.2.11.1500 - JSON Metadata support Reverse

  • 17.2.11.1411 - File driver supports data containing the String Delimiter

  • 17.2.11.1445 - Web services can be invoked through HTTP/Rest

  • 17.2.11.1475 - New property Numeric Padding Char on a file specifies the character to append to the left of a numeric value

  • 17.2.11.616 - Sql File Export supports data containing the String Delimiter

  • 17.2.11.1443 - Reduce STAMBIA_STACK_SIZE to 256k by default in initvariables.sh

  • 17.2.11.1461 - Embedded log4j is upgraded to 1.2.17 and now supports smtpAppender

  • 17.2.11.1499 - WebServices invocation support JSON

Analytics
  • 2.1.1.999: New statistic: Merge

  • 2.1.1.1892: Pop-up window is displayed when creating a new Deployment Manager (Repository) to explain how to import a first Package

  • 2.1.1.997: Deletion of a Deployment Manager (Repository) asks for confirmation

  • 2.1.1.1736: When refreshing the Session Reports a progress bar is displayed

  • 2.1.1.1972: An error is displayed when no Profile is selected

  • 2.1.1.1861: A new tab in the Session Reports displays Sessions in a Timeline

  • 2.1.1.1862: New look and feel for Session Charts

  • 2.1.1.1863: The color of the icon of the Executed status corresponds to the Executed color of an Action in a Process

  • 2.1.1.1864: Tooltips are added on Session Pie Charts to provide information on the corresponding Statistics

  • 2.1.1.1865: Metadata and Configuration edition is disabled when the selected node is a Delivery

  • 2.1.1.1866: Checkbox "Selected" is renamed to "Current Package" or "Current Build"

  • 2.1.1.1867: Advanced Properties are grouped in a category collapsed by default

  • 2.1.1.1868: Configurations: The field "Code" is renamed to "Name"

  • 2.1.1.1869: "Conf" is renamed to "Configuration"

  • 2.1.1.1870: The default name of a Package is the Import date

  • 2.1.1.1871: The column Date is hidden by default

  • 2.1.1.1872: Metadata and Configurations are no longer displayed when a Process is selected

  • 2.1.1.1873: The button "Import" is now displayed as an icon located on the top left corner

  • 2.1.1.1874: The "Build" tab is renamed to "Deployments"

  • 2.1.1.1875: The type of object is no longer displayed in the Object tree in a Deployment Manager (Repository)

  • 2.1.1.1876: The checkbox "Todo" is replaced by a toggle button with an icon

  • 2.1.1.1877: The checkbox "Last only" is replaced by a toggle button with an icon

  • 2.1.1.1878: A toggle button allows to display only the Metadata which have not been configured yet

  • 2.1.1.1879: New context menu "Build Deliveries" to build all the Deliveries of a selected node (Folder, Process, etc.)

  • 2.1.1.1880: New button to build all the Deliveries of a Deployment Manager (Repository)

  • 2.1.1.1881: New context menu "Analyze Runtimes" to analyze all the Runtimes associated to a selected node (Folder, Process, etc.)

  • 2.1.1.1882: New button to analyze all the Runtimes associated to a Deployment Manager (Repository)

  • 2.1.1.1883: New context menu "Publish Deliveries" to publish all the Deliveries of a selected node (Folder, Process, etc.)

  • 2.1.1.1884: New button to publish all the Deliveries of a Deployment Manager (Repository)

  • 2.1.1.1885: Repositories are renamed into Deployment Managers

  • 2.1.1.1886: Deliverables are renamed into Deployment Specifications

  • 2.1.1.1887: Remote name defaults to the name of the Deployment Specification (Deliverable)

  • 2.1.1.1888: More session can be displayed in the Session Reports

  • 2.1.1.1889: Refresh button: the label "Refresh" is replaced by an icon

  • 2.1.1.1890: The "Download" hyperlink of a Delivery is replaced by a context menu "Download Delivery"

  • 2.1.1.1891: The button "Publish" of a Delivery is replaced by a context menu "Publish Delivery"

  • 2.1.0.611: When a text based search is cleared the object tree is expanded and contains all the objects

  • 2.1.0.612: Text based filters search on all columns and not only on the Name

  • 2.1.0.615: Support for concurrent modifications of the same object

  • 2.1.0.1520: Connection to log databases can be made through J2EE datasources

  • 2.1.0.719: Ability to select a configuration when scheduling a multi-configuration delivery

  • 2.1.0.720: Ability to select a configuration when executing a multi-configuration delivery

  • 2.1.0.721: Deliveries can be built for multiple configurations

  • 2.1.0.814: Deliveries are available to be pulled by a Runtime from a repository using HTTP

Bug Fixes

Designer & Runtime
  • DI-65 - Convergence for MDM Integration Template never executes the INTEGRATION task due to a wrong NbCycle core parameter value (0, should be -1).

  • 18.1.0.1634 - Xml: data type NCName is defined twice

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

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

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

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

  • 18.1.0.1984 - Unable to open the Mapping built Process from another Process after moving the Mapping

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

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

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

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

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

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

  • 18.1.0.2043 - Hierarchical Fields are not correctly restored in the Mapping’s diagram when the corresponding Metadata file is restored

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

  • 18.1.0.2051 - NullPointerException on Export Model and Dependencies

  • 18.1.0.2055 - Save and execute a Mapping or Process may freeze the Designer

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

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

  • 18.1.0.2098 - Unable to create a Metadata Link from a FTP Folder

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

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

  • 18.1.0.1442 - Enter key removes the focus when defining a new Runtime

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

  • 18.1.0.2076 - Incorrect code generation when a JSon Source column has specific characters

  • 18.1.0.2013 - StackOverflow exception is raised when exporting Models with dependencies if a circular reference exists in the objects exported<br><div class="changelog-download-button-area">

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

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

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

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

  • 18.0.5.1244 - The Navigator view is not present in the list of the views

  • 18.0.5.1470 - Impact View : need to click two times

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

  • 18.0.5.1230 - Wrong tooltip on the creation of a Metadata Link in a Process

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

  • 18.0.5.1599 - A Process using a Mapping is closed when the Mapping is rebuilt

  • 18.0.5.1654 - A same Action can have multiple input binding links

  • 18.0.5.1666 - A Stage may contain multiple Fields with the same Alias

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

  • 18.0.5.1679 - Build documentation produces several icons for Execution Location

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

  • 18.0.5.1693 - 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

  • 18.0.5.1698 - Stack trace pop-up window may not open

  • 18.0.5.1716 - Deletion of a Stage may be silently ignored

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

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

  • 18.0.5.1729 - 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

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

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

  • 18.0.5.1742 - Xml to Rdbms: base64Binary doesn’t have a matching datatype

  • 18.0.5.1749 - Auto-build conflicts with renaming of an opened Mapping

  • 18.0.5.1751 - Process: missing error icon on an invalid Mapping reference

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

  • 18.0.5.1758 - MacOS: missing symbolic link on stambiaRuntime

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

  • 18.0.5.1762 - Export Model and Dependencies: the tpc files are missing

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

  • 18.0.5.1769 - Reverse Query doesn’t take aliases correctly into account on some technologies

  • 18.0.5.1772 - ConcurrentModificationException sometimes occurs on startup

  • 18.0.5.1774 - Using a Variable in an expression adds the WARNING_FIELDS_NOT_FOUND

  • 18.0.5.1778 - Json Reverse With URL doesn’t work with https

  • 18.0.5.1787 - Open Process from mapping may not work since S18.0.3

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

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

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

  • 18.0.5.1798 - Cannot Dnd fields after alt+tab from another application

  • 18.0.5.1807 - Query on some technology, needs an "as" instruction

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

  • 18.0.5.1812 - ExpressionEditor: modifications sometimes lost when using lock + Dnd

  • 18.0.5.1814 - Mapping expression may be unset after moving the field’s metadata node

  • 18.0.5.1823 - Json Datatype Number are created as Varchar in database

  • 18.0.5.1826 - Error "Widget is disposed" sometimes occurs when opening SQLExplorer

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

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

  • 18.0.5.1838 - NullPointerException when deleting / saving Metadata used by opened Editor

  • 18.0.5.1845 - Build Mapping ProgressBar fills up before the build really ends

  • 18.0.5.1853 - Build produces wrong generated code when using linked folders

  • 18.0.5.1839 - Query generation might embed too many tables when loading XML Files

  • 18.0.5.1859 - Replicator RDBMS drop constraint generates invalid syntax on Mysql

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

  • 18.0.5.1797 - Cannot delete target table from a mapping

  • 18.0.4.981 - Replacement of a target datastore does not rename the object in the mapping diagram

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

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

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

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

  • 18.0.4.1244 - The Navigator view is not present in the list of the views

  • 18.0.4.1470 - Impact View : need to click two times

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

  • 18.0.4.1230 - Wrong tooltip on the creation of a Metadata Link in a Process

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

  • 18.0.4.1599 - A Process using a Mapping is closed when the Mapping is rebuilt

  • 18.0.4.1654 - A same Action can have multiple input binding links

  • 18.0.4.1666 - A Stage may contain multiple Fields with the same Alias

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

  • 18.0.4.1679 - Build documentation produces several icons for Execution Location

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

  • 18.0.4.1693 - 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

  • 18.0.4.1698 - Stack trace pop-up window may not open

  • 18.0.4.1716 - Deletion of a Stage may be silently ignored

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

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

  • 18.0.4.1729 - 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

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

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

  • 18.0.4.1742 - Xml to Rdbms: base64Binary doesn’t have a matching datatype

  • 18.0.4.1749 - Auto-build conflicts with renaming of an opened Mapping

  • 18.0.4.1751 - Process: missing error icon on an invalid Mapping reference

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

  • 18.0.4.1758 - MacOS: missing symbolic link on the Runtime

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

  • 18.0.4.1762 - Export Model and Dependencies: the tpc files are missing

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

  • 18.0.4.1769 - Reverse Query doesn’t take aliases correctly into account on some technologies

  • 18.0.4.1772 - ConcurrentModificationException sometimes occurs on startup

  • 18.0.4.1774 - Using a Variable in an expression adds the WARNING_FIELDS_NOT_FOUND

  • 18.0.4.1778 - Json Reverse With URL doesn’t work with https

  • 18.0.4.1787 - Open Process from mapping may not work since S18.0.3

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

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

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

  • 18.0.4.1798 - Cannot Dnd fields after alt+tab from another application

  • 18.0.4.1807 - Query on some technology, needs an "as" instruction

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

  • 18.0.4.1812 - ExpressionEditor: modifications sometimes lost when using lock + Dnd

  • 18.0.4.1814 - Mapping expression may be unset after moving the field’s metadata node

  • 18.0.4.1823 - Json Datatype Number are created as Varchar in database

  • 18.0.4.1826 - Error "Widget is disposed" sometimes occurs when opening SQLExplorer

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

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

  • 18.0.4.1838 - NullPointerException when deleting / saving Metadata used by opened Editor

  • 18.0.4.1845 - Build Mapping ProgressBar fills up before the build really ends

  • 18.0.4.1853 - Build produces wrong generated code when using linked folders

  • 18.0.4.1839 - Query generation might embed too many tables when loading XML Files

  • 18.0.4.1859 - Replicator RDBMS drop constraint generates invalid syntax on Mysql

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

  • 18.0.4.1797 - Cannot delete target table from a mapping

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

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

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

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

  • 18.0.3.1637 - NullPointerException when accessing the Advanced tab of a Join’s Properties

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

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

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

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

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

  • 18.0.3.1649 - Multiple editors can be opened on the same Process

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

  • 18.0.3.1655 - Foreign key with no name is reversed twice

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

  • 18.0.3.1659 - NullPointerException raised when building packages with accentuated characters

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

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

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

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

  • 18.0.2.1600 - Closing the properties popup of a Template may not work

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

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

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

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

  • 18.0.2.1502 - Unable to create two instances of a VariableManager

  • 18.0.1.1584 - Errors in cache management prevents building mappings

  • 18.0.1.1585 - NullPointerException when deleting an Action Parameter

  • 18.0.1.1586 - NullPointerException when undoing the creation of a DataSchemaConfiguration

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

  • 18.0.1.1581 - Runtime view may not list all the Runtimes

  • 18.0.0.1013 - Scrolling and selection issues in the StackTrace window

  • 18.0.0.1385 - Tooltip for Editors is too long

  • 17.2.14.1593 - Rhino is missing under JRE 1.8

  • 17.2.14.1674 - Start Delivery with absolute file path on windows does not generate any log entry

  • 17.2.14.1576 - Classpath is too long when defining the Runtime as a windows service

  • 17.2.14.1622 - Errors caught when Child Session executes a webservice are still raised

  • 17.2.14.1648 - Bind Error "Host variable 'p0' is not initialized" when implicit conversion disabled with some column types

  • 17.2.14.1691 - Indented XML files: elements are loaded with one text record for each indented child element

  • 17.2.13.1577 - Jdbc File Driver: line transformations do not work with Java 8

  • 17.2.13.1473 - Delivery as a webservice: pLogLevel has no effect, but plogLevel works

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

  • 17.2.12.1573 - NoClassDefFoundError javax/jms/JMSException when executing on Windows XP a process containing a bind link

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

  • 17.2.11.1483 - Wrong URL sample for the DB2 UDB driver

  • 17.2.11.1492 - Views' columns are not reversed on Teradata

  • 17.2.11.1493 - MSSQL: Size may exceed 53 when reversing FLOAT columns

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

  • 17.2.11.1415 - The position of the Fields is not respected when writing to hierarchical file

  • 17.2.11.1468 - Excel driver does not replicate the style of the cells to the inserted rows

  • 17.2.11.1414 - StartDelivery fails to parse properties on AIX

  • 17.2.11.1466 - Execute SSH: SSH_RET_MESS contains an extra carriage return

  • 17.2.11.1467 - Excel driver: conversion functions do not support empty values

  • 17.2.11.1405 - SendMail: cannot establish connection with TLS security

  • 17.2.11.1410 - Wrong substitution when generating a mapping expression containing more than 10 process parameters

  • 17.2.11.1412 - Command "resume trigger" has no effect

  • 17.2.11.1431 - Excel driver may fail when writing to excel file

  • 17.2.11.1437 - Variable Manager does not support LONGVARCHAR JDBC Datatypes

  • 17.2.11.1472 - NullPointerException when invoking Web Services with indented response

Analytics
  • 2.1.1.1570: Analyzing a Runtime displays NOT_EXISTS instead of NOT_MATCH

  • 2.1.1.335: When creating a new Configuration, the focus is not set on the configuration code textbox

  • 2.1.1.1610: Del key in the Name field deletes the Deliverable

  • 2.1.1.1780: Performance issue when displaying a large number of Sessions

  • 2.1.0.263: When the value of a text variable is too long Analytics doesn’t display it correctly

  • 2.1.0.613: Adding or deleting Configuration does not refresh the metadata tree

  • 2.1.0.1379: Elapsed time is not correct sometimes when the time zone changes

  • 2.1.0.1529: Session duration incorrect when the session lasts more than 24h

Version 3.0.0 (3.0.0-GA_Build17.2.10)

New Features

Designer & Runtime
  • 17.2.10.1375: New popup message when trying to open an XML file which does not exist

  • 17.2.8.1342: New option JDBC.BIND.DISABLE_IMPLICIT_CONVERSION to disable implicit conversion during a binding operation

  • 17.2.8.1330: New API ctx.createBindedPreparedStatement() in Scripting Actions to produce a Resultset for an outgoing Bind link

  • 17.2.8.1313: FileWait can be directly used as a source of bind link

  • 17.2.8.1301: StackTrace popup has a minimum size on opening

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

  • 17.2.8.1291: RDBMS: Actions > Properties opens the Reverse category by default

  • 17.2.8.1288: S3 technology: New property Physical Name on Buckets

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

  • 17.2.8.1264: File driver supports accentuated characters in column names

  • 17.2.8.1258: MSSQL: Datastores available through a Linked Server can be reversed

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

  • 17.2.8.1250: Add a Find/Replace utility to the Expression Editor

  • 17.2.8.1237: Memory optimizations when opening a Process containing references to other Processes

  • 17.2.8.1204: Metadata creation wizard is redesigned

  • 17.2.8.998: New statistic: SQL_STAT_MERGE

  • 17.2.8.951: Keep track of previous selection when selecting datastores to reverse

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

  • 17.2.8.629: Expression Editor can be used to edit the text of the Notes

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

  • 17.2.7.1218: HTTP Rest Web Service: add support for urlReplacement

  • 17.2.6.1196: Bean Scripting actions support ctx object

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

  • 17.2.6.1181: SQL To Parameters: new attribute dateTimeFormat to convert date or datetime into String

  • 17.2.4.1173: SAP Technology: some Properties are externalized by default

  • 17.2.4.1171: JDBC File Driver: PreparedStatement supports setClob()

  • 17.2.4.1170: Web Service HTTP: add support for XML inputs

  • 17.2.4.1168: Web Services: reverse MIME content-type

  • 17.2.3.1159: Add support for data integration into Salesforce.com

  • 17.2.3.1158: Add support for data extraction from Salesforce.com

  • 17.2.3.1157: Add support for reverse in technology Salesforce.com

  • 17.2.3.1156: New technology: Salesforce.com

  • 17.2.3.1136: Embedded Hypersonic SQL database version is upgraded to 2.3.2

  • 17.2.3.1125: LoadMask, IntegrationMask and RejectMask can be specified at Datastore level

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

  • 17.2.3.1118: StartDelivery’s stack trace contains the synchronous child session’s stack trace if any

  • 17.2.3.1117: Sap IDoc Generation: add support for SEGMENT and BEGIN attributes

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

  • 17.2.3.1071: Line numbers are displayed in the Expression editor

  • 17.2.3.1066: Bean Scripting Framework: Use dropdown list to specify language

  • 17.2.3.1065: Java Native Scripting: Use dropdown list to specify language

  • 17.2.2.1067: SqlToParameters: add SQL_TRANSACTION_NAME and SQL_TRANSACTION_TYPE to the Properties view

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • 17.2.2.1047: Scheduler: org.quartz.jobStore.dataSource property supports "internal" keyword to avoid the definition of a datasource

  • 17.2.2.1045: engineScheduler.properties is optional

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

  • 17.2.2.1041: New property databaseMajorVersion for RDBMS Servers

  • 17.2.2.1037: Add "gYearMonth" datatype to XML technology

  • 17.2.2.1036: Add "gYear" datatype to XML technology

  • 17.2.2.1035: Add "gMonthDay" datatype to XML technology

  • 17.2.2.1034: Add "gMonth" datatype to XML technology

  • 17.2.2.1033: Add "gDay" datatype to XML technology

  • 17.2.2.1032: Add "ENTITY" datatype to XML technology

  • 17.2.2.1031: Add "NCName" datatype to XML technology

  • 17.2.2.1030: Add "token" datatype to XML technology

  • 17.2.2.1029: Add "anyURI" datatype to XML technology

  • 17.2.2.1028: Add "unsignedShort" datatype to XML technology

  • 17.2.2.1027: Add "unsignedInt" datatype to XML technology

  • 17.2.2.1026: Add "nonPositiveInteger" datatype to XML technology

  • 17.2.2.1025: Add "nonNegativeInteger" datatype to XML technology

  • 17.2.2.1024: Add "negativeInteger" datatype to XML technology

  • 17.2.2.1020: SqlToXml: new option NO_DATA_BEHAVIOUR

  • 17.2.2.1010: Oracle technology reverses check constraints

  • 17.2.2.992: Mapping and Process names are optional

  • 17.2.2.980: New function ref:container(<SchemaName>) returns a reference to a schema based on its name

  • 17.2.2.971: Update Tutorial to comply with Designer’s layout

  • 17.2.2.970: New log file com.indy.engine.<port>.RDBMSLog.log provides information on log storage

  • 17.2.2.969: New log file com.indy.reverse.log

  • 17.2.2.965: XSD annotations are reversed (documentation and appinfo)

  • 17.2.2.950: New button to select existing tables when executing a reverse engineering

  • 17.2.2.949: Allow reverse engineering to run in background

  • 17.2.2.948: Allow compilation to run in Background

  • 17.2.2.947: New context menu entry "Replace usages by…​" allows to replace a metadata by another in the workspace

  • 17.2.2.927: New icon in the Project Explorer to identify unbuilt Mappings

  • 17.2.2.921: Concat Files: Support for special characters \n \t \r \f

  • 17.2.2.919: SQLFileExport: Support for special characters \n \t \r \f to specify the Field separator and the Row separator

  • 17.2.2.916: In a Mapping, a disabled constraint is displayed with a grey font

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

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

  • 17.2.2.910: Designer memory improvements

  • 17.2.2.895: Sort options alphabetically when using Arrange all

  • 17.2.2.868: Multi-selection is supported when adding Datastores to a Mapping

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

  • 17.2.2.864: When editing a Target Field directly in the diagram the "TargetFieldName → " is no longer needed and only the expression has to be set

  • 17.2.2.859: New logLevel -1 is supported to prevent any logging by the runtime

  • 17.2.2.858: startdelivery.bat and startdelivery.sh: new parameter loglevel

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

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

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

  • 17.2.2.509: Bean Scripting Framework: SCRIPTING_LANGUAGE now supports "beanshell" (Java Bean Shell)

  • 17.2.1.843: Renaming "Execution" menu to "Build/Execute"

  • 17.2.1.824: SCP/SSH actions: New parameter SSH_TIMEOUT (in milliseconds)

  • 17.2.1.823: Improved Mapping rendering

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

  • 17.2.0.797: Object delimiter is systematically added MySQL object names

  • 17.2.0.760: Configuration editor has an embedded editor for the Properties of a node

  • 17.2.0.759: Runtime editor has an embedded editor for the Properties of a node

  • 17.2.0.758: Metadata editor has an embedded editor for the Properties of a node

  • 17.2.0.750: New demo environment

  • 17.2.0.748: Drag and dropping a parameter of an Action moves the Action

  • 17.2.0.747: New layout and colors in an executed Process

  • 17.2.0.746: The resize of an Action is made from the corner of the optional border displayed when the Action is selected

  • 17.2.0.745: The button Open mapping on an Action is replaced by an icon button on the left side of the Action

  • 17.2.0.744: New context menu "Move" on a Metadata Node (e.g. on a Datastore) in the Project Explorer to move the node to a new Metadata

  • 17.2.0.743: The tab Appearance is removed from the Property View when an Action is selected

  • 17.2.0.742: New button on the top of an Action executed with errors to display the Stack Trace

  • 17.2.0.741: An Action is displayed as a stacked shape if a repetition query is specified

  • 17.2.0.740: New button on the top Actions with Parameters specified allows to show/hide the Parameters

  • 17.2.0.739: The dotted line on a Link is replaced by an icon at the beginning of the Link if a Generation Condition is specified

  • 17.2.0.738: The target shape of a Link depends on its Triggering Behavior

  • 17.2.0.737: The round at the beginning of a Link is removed

  • 17.2.0.736: New button on the bottom of the selected Action to draw links starting from this Action

  • 17.2.0.735: New button on the right side of the selected Action to enable/disable the Action

  • 17.2.0.734: New button on the right side of the selected Action to edit the Restart Point Type property

  • 17.2.0.733: New button on the right side of the selected Action to edit the Error Tolerated property

  • 17.2.0.732: New button on the right side of the selected Action to edit the is Begin Action property

  • 17.2.0.731: An icon on the top of Actions replaces the dotted lines around the Action if a Generation condition is specified

  • 17.2.0.730: New button on the top of the selected Action to specify the Generation condition

  • 17.2.0.729: New button on the left side of the selected Action to edit the Parameters of the Action

  • 17.2.0.728: New button on the left side of the selected Action to add new Parameters to the Action

  • 17.2.0.727: New graphical design of Actions

  • 17.2.0.726: The pop-up icons are no longer displayed when the mouse is left over an Action

  • 17.2.0.725: +/- icons to expand/collapse the Parameters and Metadata Links on Actions are replaced by buttons on the top of the selected Action

  • 17.2.0.724: New toolbar button to hide all parameters and metadata links

  • 17.2.0.723: Ability to select a configuration when executing from the Navigator a multi-configuration delivery built with Analytics 2.1.0

  • 17.2.0.722: Ability to select a configuration when scheduling a multi-configuration delivery built with Analytics 2.1.0

  • 17.2.0.718: Command execute delivery: new parameter configuration <configurationName> will support multi-configuration deliveries coming with Analytics 2.1.0

  • 17.2.0.717: startdelivery.sh: new parameter -configuration <configurationName> will support multi-configuration deliveries coming with Analytics 2.1.0

  • 17.2.0.716: ExecuteDelivery: new parameter Deliv Configuration will support multi-configuration deliveries coming with Analytics 2.1.0

  • 17.2.0.715: startdelivery.bat: new parameter -configuration <configurationName> will support multi-configuration deliveries coming with Analytics 2.1.0

  • 17.2.0.714: Designer’s memory management is enhanced

  • 17.2.0.713: FtpPut and FtpGet: new Parameter DATA_TIMEOUT in milliseconds

  • 17.2.0.712: FtpPut and FtpGet: new Parameter SOCKET_TIMEOUT in milliseconds

  • 17.2.0.711: FtpPut and FtpGet: new Parameter CONNECTION_TIMEOUT in milliseconds

  • 17.2.0.709: "Create a new Md model" is renamed "Create a new Metadata Model" in the Metadata creation window

  • 17.2.0.708: "Md Model" is renamed "Metadata Model" in the Metadata creation window

  • 17.2.0.703: Runtime can be configured to support HTTP Repositories coming in Analytics 2.1.0

  • 17.2.0.694: Back quote is used as the object delimiter on MySQL instead of double quote

  • 17.2.0.693: Add BIT and LOGTEXT datatypes on MySQL technology

  • 17.2.0.679: Elements of the Generic technology can now be typed

  • 17.2.0.671: New RDBMS Technology: Oracle RDB

  • 17.2.0.669: The list of configurations is sorted

  • 17.2.0.660: Input, Output and Fault checkboxes are grouped into a "Publication" tab

  • 17.2.0.659: Place the cursor after the prompt when a runtime command is executed

  • 17.2.0.654: New context menu: Advanced > Reinit Process diagram

  • 17.2.0.627: Copy-paste of an action creates the new action at the location of the mouse

  • 17.2.0.625: Process editor: Arrange all will stack all the Metadata links on a same column

  • 17.2.0.617: PutFtp: new Parameter "Append" allowing to append the content being transferred

  • 17.2.0.594: Bind links can be designed only between actions for which the Bind is supported by the Runtime

  • 17.2.0.569: List of schema is sorted in the RDBMS reverse Wizard

  • 17.2.0.562: A meaningful message is raised when an error occurs during the parsing of a delivery

  • 17.2.0.554: 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

  • 17.2.0.543: Using the "Open with" menu to open an object with a specific editor no longer sets it as the default editor for this object

  • 17.2.0.528: A Mapping must be saved prior to be executed

  • 17.2.0.526: Automatically expand the root node of a hierarchical Datastore when adding it to a Mapping

  • 17.2.0.518: New column "Configuration" in session list

  • 17.2.0.434: New property "Use JSON Format" on XML root elements

  • 17.2.0.424: By default the content of the .map and .proc files are not displayed in the Project Explorer (this can be overridden from the "Customize View…​" menu)

  • 17.2.0.423: Files extensions are hidden by default (this can be changed from the Project Explorer’s view menu)

  • 17.2.0.422: Add a border around the Expression in the Expression Editor

  • 17.2.0.421: Add a border around the list of Tags

  • 17.2.0.418: TransactionName property of actions having a RDBMS connection defaults to T1 instead of empty string

  • 17.2.0.417: The replacement of a target XML datastore ignores the root element name when remapping the columns

  • 17.2.0.404: The "…​" buttons are renamed into "Browse" buttons in the XSD Editor

  • 17.2.0.397: Display the Runtime view by default in the default perspective

  • 17.2.0.388: Dynamic Name and Is Begin Action properties are moved to the "Advanced" tab

  • 17.2.0.378: File Driver supports Timestamp

  • 17.2.0.375: When reversing a File the timestamp datatypes and their formats are automatically reversed

  • 17.2.0.374: When reversing a File the date format is automatically reversed

  • 17.2.0.360: Do not look for Column names when checking an Expression executed on Target

  • 17.2.0.325: A ',' is used as the default file separator on non-French environment instead of a ';'

  • 17.2.0.324: Directory Wizard is automatically launched when creating a new File Server

  • 17.2.0.298: Process Parameters can have a Label different from their technical name

  • 17.2.0.254: SSH: new parameter SSH_OUTPUT_PROPERTY allows to specify a session variable storing the standard output of the command

  • 17.2.0.192: The build and execution menus items are refactored to be consistent between the Project Explorer and the diagram editor

  • 17.2.0.172: Hierarchical source or target Datastores can be filtered to display only Mapped/Unmapped columns

  • 17.2.0.171: A parent XML field is displayed in blue to inform that at least one child (or grand child) node is mapped

  • 17.2.0.170: Open With > Other…​ Editor list is updated

  • 17.2.0.160: Add an icon on the table to show if a display filter is activated on columns

  • 17.2.0.139: New preference "Diagram refresh enabled by default" to manage the default value of the "Refresh Diagram" checkbox.

  • 17.2.0.138: Display the short name of a Parameter in the Project Explorer instead of the full path

  • 17.2.0.137: Hide the links in the Project Explorer when expanding the nodes of a Process

  • 17.2.0.136: The type of a child node of a process is no longer displayed in the Project Explorer

Analytics
  • 2.0.8.583: Deliveries can be published as web service

Bug Fixes

Designer & Runtime
  • 17.2.10.1404: Error when PutSCP is bound to a SqlOperation with more than one result

  • 17.2.10.1400: Session Id can sometimes be the same for two sessions launched at the same time (in addition to fix 1194)

  • 17.2.10.1397: Column with name starting with a dollar sign is incorrectly generated

  • 17.2.10.1380: Error when GetSCP is bound to a SqlOperation with more than one result

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

  • 17.2.9.1367: Bind sometimes leaves the statement open since 17.2.8

  • 17.2.9.1366: Writing to a Multi-record file can raise an error since fix 1342

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

  • 17.2.8.1335: WSDL: runtime locks temporary files if an Exception is raised

  • 17.2.8.1334: Command "get triggers" displays jobName instead of deliveryName in the Delivery column.

  • 17.2.8.1329: File driver: numeric data with more than 8 digits are altered by INSERT statements

  • 17.2.8.1328: Binding NVARCHAR data into PostgreSQL fails because setNString() is not implemented by the driver

  • 17.2.8.1318: Runtime command pause trigger has no effect

  • 17.2.8.1317: Runtime command: schedule delivery should use "jobName" instead of "with name"

  • 17.2.8.1312: WSDL: with REST URL replacement the space character in URL is replaced by + instead of %20

  • 17.2.8.1310: Log purge fails on MySQL and SQL SERVER since S17.2.2

  • 17.2.8.1306: Copy/Paste Actions: relative locations are lost

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

  • 17.2.8.1286: MySQL Bit datatype is not defined as default Bit datatype

  • 17.2.8.1284: SqlToParameters may raise an Exception on AIX

  • 17.2.8.1283: Build a mapping fails when DROP_TABLE_IF_EXISTS is used

  • 17.2.8.1282: Oracle technology: VARCHAR2 creation Mask generates columns with size 4000

  • 17.2.8.1280: installEngineAsService : AccessControlException when security.policy is externalized

  • 17.2.8.1275: Explicit Joins do not support circular references

  • 17.2.8.1274: New Parameter FTP_ENCRYPT_CHANNEL_DATA to FtpPut and FtpGet

  • 17.2.8.1266: Outer Column with Not In instruction doesn’t work for filter or Join with implicit mode

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

  • 17.2.8.1259: Sap: Transaction commit does not work with jco3

  • 17.2.8.1257: Execute and schedule Commands do not work anymore since s17.2.5

  • 17.2.8.1242: startdelivery.sh configured with an encrypted password for the log database raises "Problems getting the log parameters"

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

  • 17.2.8.1232: License check fails with "Error during contacting server" on some VPN on MacOS X

  • 17.2.8.1225: NullPointerException may be raised when creating a new Parameter in a Process

  • 17.2.8.1222: ProjectExplorer: icons and labels of some Metadata may be missing

  • 17.2.8.1221: Variable Manager: only the latest value of one Variable is saved. Other values are always lost

  • 17.2.8.1110: Automatic Mapping does not work when the target is a File

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

  • 17.2.8.700: Hide unused on a hierarchical source hides the root node

  • 17.2.8.633: Arrange all works correctly only after arranging twice

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

  • 17.2.7.1217: SQL To parameters: String datatype doesn’t work anymore since bug 1181

  • 17.2.7.1216: SQL File Export: Max File Size parameter unit (K M G) doesn’t work correctly

  • 17.2.7.1212: Links are broken in Welcome Page

  • 17.2.6.1205: PostgreSQL: reverse NUMERIC columns generates NUMERIC(131089) metadata

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

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

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

  • 17.2.6.1195: Unable to locate shared library when starting Designer on Ubuntu 12.04

  • 17.2.6.1194: Session Id can sometimes be the same for two sessions launched at the same time

  • 17.2.6.1193: Process with a loop : Sub-process in error is not executed on next iterations

  • 17.2.6.1192: Sessions View: vertical scrollbar may disappear

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

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

  • 17.2.6.1186: Mapping may be broken when moving Metadata

  • 17.2.5.1184: Unable to execute a command on a Runtime

  • 17.2.4.1172: SqlFileExport fails when data contains a CLOB column

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

  • 17.2.4.1166: Server Wizard doesn’t save information if closed before reverse

  • 17.2.4.1162: The Properties of a Configuration node are not displayed correctly

  • 17.2.4.1160: Unable to generate a WebService with XML metadata

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

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

  • 17.2.3.1139: Wrong tooltips on Restart Point types

  • 17.2.3.1135: Unreadable Delivery file generates Exceptions during session report

  • 17.2.3.1133: tech:creationDdl() does not support the BIT datatype on MySQL

  • 17.2.3.1132: Default inner join mode is ignored and Implicit mode is always used

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

  • 17.2.3.1126: Stop/Start/Restart soap sever doesn’t work

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

  • 17.2.3.1113: Stop/Start (restart) scheduler doesn’t work on version S17.2.2 only

  • 17.2.3.1109: VariableManager: refreshing a variable with datatype NVARCHAR raises an error

  • 17.2.3.1108: Variable Manager with save and refresh connections doesn’t release correctly the connections to the connection pool

  • 17.2.3.1107: File Driver delimited mode does not generate unmapped fields in the correct order

  • 17.2.3.1105: null keyword may be displayed in the StackTrace Popup window

  • 17.2.3.1103: NullPointerException may occur when moving Actions

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

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

  • 17.2.3.1096: StartDelivery: default session name is the delivery ID instead of the delivery name

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

  • 17.2.3.1094: Xml to Rbms may execute a last empty batch which fails on some technologies

  • 17.2.3.1092: Runtime Session may not be updated in Designer

  • 17.2.3.1083: Delivery file parsing error on AIX

  • 17.2.3.1079: A process with too many RDBMS connections in parallel hangs

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

  • 17.2.3.278: Documentation error may be raised if the process is too complex

  • 17.2.2.1044: NullPointerException when opening Mapping if the template cannot be found automatically

  • 17.2.2.1005: Consult Data (console) doesn’t close the JDBC connection properly

  • 17.2.2.1004: File driver silently ignores errors on dates and timestamps with wrong numbers and returns erroneous values

  • 17.2.2.1002: JDBC File Driver: Computed Field do not work correctly on delimited files

  • 17.2.2.991: Excel JDBC driver does not handle correctly upper case column names when columnNameStyle is set to flat

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

  • 17.2.2.978: XML driver fails to load shouldn’t expose XML integers as standard SQL integer because its size is too small

  • 17.2.2.975: Designer may hang when on startup when using SVN

  • 17.2.2.972: Performance issue when executing a reverse on pureData Technology

  • 17.2.2.962: Log deletion on DB2 UDB doesn’t work

  • 17.2.2.960: Core Stack Trace Popup window does not format correctly the Exception

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

  • 17.2.2.933: Concat Files : option FILE_SEPARATOR not available in Properties view

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

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

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

  • 17.2.2.909: Execute Delivery doesn’t work if JAVA_HOME contains a space character

  • 17.2.2.894: Source fields may appear as not selected when they are selected

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

  • 17.2.2.892: Context menu Build > Documentation shouldn’t be displayed for Mappings

  • 17.2.2.891: Wrong font color after editing directly a Target Mapping

  • 17.2.2.888: Missing method when generating a Hierarchical File on AIX

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

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

  • 17.2.2.865: Consult Data does not always connect to the database

  • 17.2.2.863: 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

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

  • 17.2.2.849: Process Editor: StackTrace popup window is misplaced

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

  • 17.2.2.580: SOAP Web Services published by Runtime are not WS-I compliant

  • 17.2.2.296: When exporting a Sap Bapi Structure the name "Structure" is used instead of the real name

  • 17.2.1.842: Popup tool error icon action remains in process editor after step deletion

  • 17.2.1.839: NullPointerException may occur when displaying the stack trace of an Action

  • 17.2.1.836: Hide the tooltip on a target field when no mapping expression is defined

  • 17.2.1.835: Conflicts occur when using the same runtime installation directory to run multiple runtimes publishing the same delivery as a webservice

  • 17.2.1.834: Wrong statistics returned to Analytics when iterating in a process

  • 17.2.1.832: When F1 key is hit on certain Actions, the contextual help displayed is not corresponding to the selected action

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

  • 17.2.1.821: ClassNotFoundException when executing Actions > Consult data (console) on a flat file

  • 17.2.1.818: SqlFileExport: SQL_EXP_UNCRYPTED_JAVA_PASWORD parameter returns null

  • 17.2.1.816: Calculation of statistics is sometimes incorrect

  • 17.2.0.702: Read Mail Action doesn’t propose the correct default value for some of its parameters

  • 17.2.0.676: FtpCommand: Proxy parameters are repeated twice

  • 17.2.0.656: Passwords are not hidden in the Configuration edition

  • 17.2.0.653: Diagram is in error after a copy-paste of a Mapping within the Project Explorer

  • 17.2.0.647: File Driver writes fields based in the order where they were declared instead of using the Position

  • 17.2.0.646: Unable to move the anchor of a link on the Parameters of an Action

  • 17.2.0.631: Execute opens the Process of the Mapping: only Open and Execute should open the Process

  • 17.2.0.621: Copy-Paste of a Note does not work in the Process editor

  • 17.2.0.602: Unable to expand the node of an object in error in the Project Explorer

  • 17.2.0.599: Diagram layout is lost after undoing the deletion of a Process or a Mapping

  • 17.2.0.595: NullPointerException when opening a Process from the Search view

  • 17.2.0.590: Package generation error when number of Parameters is greater than 127

  • 17.2.0.573: Starting the same delivery twice may cause an error on Runtimes using the logging on a RDBMS

  • 17.2.0.567: Inconsistent behavior when renaming an object currently being edited

  • 17.2.0.563: Bind links may execute a last empty batch which fails on some technologies

  • 17.2.0.561: Unsuccessful links are not evaluated when used on Actions bound to a Target action with a Bind link

  • 17.2.0.560: Error occurs when closing the Properties view and re-open it from the "Show Properties View" context menu

  • 17.2.0.550: Node name is not updated dynamically when renaming a node in the Metadata editor if the Name and Schema Name differ

  • 17.2.0.548: 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

  • 17.2.0.547: 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

  • 17.2.0.546: Copy paste an Action with a Metadata Link may move the Metadata Link from the Action to the Process

  • 17.2.0.536: Foreign keys with multiple columns are not reversed correctly

  • 17.2.0.522: Foreign keys are not reversed correctly on DB2 UDB

  • 17.2.0.513: tech:rejectMessage() doesn’t handle simple quotes

  • 17.2.0.512: The Del key does not produce the same result as CTRL+X: deletion cannot be undone without errors

  • 17.2.0.511: Unable to Execute a Process on an existing Workspace on Linux

  • 17.2.0.507: Links are not copied during a copy-paste operations on the Actions

  • 17.2.0.503: Copy Paste of Actions and Metadata Links does not paste the Metadata Link

  • 17.2.0.501: When multiple Metadata editors are opened the properties view is not refreshed correctly

  • 17.2.0.481: Cut and Paste of an Action reverts the Parameters to their default values

  • 17.2.0.478: Cut and Pasts Actions with parameters creates Parameters on the Process

  • 17.2.0.471: When renaming a field in a metadata, the children fields are not updated accordingly in the Mappings

  • 17.2.0.470: Field positions are lost when replacing the target Datastore in a Mapping

  • 17.2.0.460: When replacing the target Datastore the fields that cannot be found in the new Datastore are not in error

  • 17.2.0.454: Typo in the XML Wizard: "Revere" should be "Reverse"

  • 17.2.0.446: Add a border around the "Verb" attribute of a WSDL Port

  • 17.2.0.439: When creating a WSDL Metadata the Finish button is not always enabled

  • 17.2.0.398: Schema wizard and Server Wizard do not use the same Window size

  • 17.2.0.395: Unable to delete a link having another link as a source

  • 17.2.0.394: Wrong column order used in Target columns for XML Datastores

  • 17.2.0.393: Error occurs when using the context menu Transform Last Delivery To File

  • 17.2.0.387: SubProcess Actions are missing the "Core" tab in the Properties view

  • 17.2.0.382: The Reverse helper of a File does not support the timestamp datatype

  • 17.2.0.381: The position is mandatory in the Reverse Helper of a Delimited file

  • 17.2.0.380: The first time the properties of an Action are scrolled down in the Properties View they disappear shortly

  • 17.2.0.377: Typo in the name of the "Miscellaneous" accordion

  • 17.2.0.371: Updating a Metadata does not automatically update the Mappings under edition

  • 17.2.0.367: When adding a missing Variable to a Mapping the errors/warnings are not updated

  • 17.2.0.366: Deleting a Variable in a Mapping does not refresh the errors/warnings

  • 17.2.0.364: Adding a missing source Datastore does not update the errors/warnings of the Mapping

  • 17.2.0.363: Renaming or deleting a Metadata used by a Mapping under edition closes the Mapping editor

  • 17.2.0.361: Changing the alias of a Source datastore does not refresh the warnings/errors

  • 17.2.0.358: Unable to execute a Mapping from the Project Explorer

  • 17.2.0.357: Compilation fails when Numeric datatypes from Oracle and SQL Server are used in the same Mapping

  • 17.2.0.351: Collapsing a parent node of a hierarchical datastore only hides the direct children

  • 17.2.0.341: Undoing the deletion of a target Datastore does not restore the Templates that were selected

  • 17.2.0.322: Parameters set by a MetaDataLink are not highlighted until the Action is moved in the diagram

  • 17.2.0.321: Right mouse click does not display the context menu if another object is selected

  • 17.2.0.320: Reverse Positional File: Changing positions automatically reloads the File

  • 17.2.0.316: Source and/or Target columns can be dragged and dropped from one datastore to another datastore

  • 17.2.0.314: CTRL+X in the Properties view deletes the selected node being edited instead of cutting the currently selected text in the Properties view

  • 17.2.0.268: Del key is ineffective when a link is selected

  • 17.2.0.262: The Documentation is not displayed correctly in Internet Explorer 8

  • 17.2.0.205: ArrayOutOfBoundException when reversing a Positional File containing lines below the expected length

  • 17.2.0.190: Wrong type of node restored after undoing a "Change to"

  • 17.2.0.165: Inconsistency on child nodes between All, Sequence and Choice nodes in a WSDL metadata

  • 17.2.0.159: An error occurs when canceling Documentation generation

  • 17.1.19517: Runtime does not start on AIX

  • 17.1.19499: Execute Delivery: Property file is not set correctly when the STAMBIA_PROPERTIES_LOCATION variable is set in the child session

  • 17.1.19475: Sessions may not be displayed correctly

  • 17.1.18495: Exception is thrown when converting a SQL BIGINT datatype into an XML long datatype

  • 17.1.18494: Missing method when generating an XML File on AIX

  • 17.1.18493: Execute Delivery fails when the parent session is started in command line

Analytics
  • 2.0.9.1183: Analytics does not load after an upgrade to Firefox 29.

  • 2.0.9.1120: Page content is lost after scrolling page on Chrome v33 or Safari for Mac.

  • 2.0.8.591: Problems during Analytics deployment on certain JBoss configurations.

  • 2.0.8.589: Some large packages cannot be imported in the repository.

Version 2.2.0 (2.2.0-GA_Build17.1.17)

Known Issues

  • DI-29: Designer Crashes on Linux when accessing the Welcome screen.<br/>This is an "Known Issue with Eclipse":HTTPs://bugs.eclipse.org/bugs/show_bug.cgi?id=404776#c6 . As a workaround, on Linux versions having this problem, add the following in the semarchy.ini: -Dorg.eclipse.swt.browser.DefaultType=mozilla

  • DI-27: Error "SQL_EXP_JAVA_PASSWORD is null" when using SQLFileExport.<br/> This error happens when providing all connection parameters (and not a connection). As a workaround it is recommended provide the connection information through a bind metadata.

  • DI-28: ORA-28040 error with Oracle 12g.<br/> This issue is due to references to ojdbc14.jar remaining in the drivers definitions. To solve this issue, edit the Oracle This Driver, remove the references to this driver to point to a newer driver definitions.

New Features

Designer
  • DI-24: Workflow Templates are modified to support transition name for task completion, and not target task name. The new template provided by default and are compatible with Convergence for MDM version 2.2.0 and above. Templates compatible with previous MDM releases are available in the template.semarchy.2.0.zip file.

  • DI-23: Integration Templates are modified to use the new INTEGRATION_LOAD package for managing loads. The new template provided by default and are compatible with Convergence for MDM version 2.2.0 and above. Templates compatible with previous MDM releases are available in the template.semarchy.2.0.zip file.

  • DI-25: Getting Started project is updated to work with Convergence for MDM 2.2.0 Getting Started environment.

  • 1.7.1.v017.450: Add the ability to write into hierarchical files

  • 1.7.1.v017.445: New Generic technology

  • 1.7.1.v017.426: New method ctx.executeRemoteCommand(<host>, <port>, <command>) to execute a command on a remote host from the scripting context

  • 1.7.1.v017.413: WSDL Wizard is launched automatically when creating a new WSDL Metadata

  • 1.7.1.v017.412: XML File Wizard is automatically launched when creating a New XML Metadata.

  • 1.7.1.v017.402: JDBC File Driver uses an implicit conversion when no number formatting is specified.

  • 1.7.1.v017.400: ReadMail: new option MAIL_MARK_AS to mark emails as read

  • 1.7.1.v017.383: XSD generation allows to select another encoding when the default encoding does not comply with XML file’s encoding

  • 1.7.1.v017.376: In the Process editor, Templates and Actions parameters are now displayed in the "Standard" tab of the Properties view.

  • 1.7.1.v017.373: Support reverse-engineering of Foreign Keys across different logical schemas based on the same physical schema

  • 1.7.1.v017.353: The Generate XSD dialog looks for an XSD file instead of an XML file

  • 1.7.1.v017.326: New method ctx.executeCommand(<command>) to execute a Runtime command from the scripting context

  • 1.7.1.v017.302: Support for JSON as a source.

  • 1.7.1.v017.301: The description of a Process is moved to a dedicated tab in the Properties view

  • 1.7.1.v017.147: Increased the default size of Directory and File wizards to see at least 4 lines in the Preview panel

  • 1.7.1.v017.134: When creating a new Metadata the user is prompted for a metadata name instead of the file name

  • 1.7.1.v017.133: The name of a Connection no longer requires to end with .RDBMS, .file, etc.

  • 1.7.1.v017.112: New option "Hide Files Extension" in the Project Explorer menu.

  • 1.7.1.v016.259: New property SSH_TIMEOUT on SSH Servers (expressed in milliseconds).

  • 1.7.1.v016.258: New property SSH_PASSWORD_PHRASE on SSH Servers (password to decrypt the private key file).

  • 1.7.1.v016.257: New SSH_PRIVATE_KEY_FILE property on SSH Servers (path to the private key file).

  • 1.7.1.v016.256: All SSH Servers' properties are externalized by default.

  • 1.7.1.v016.264: When editing the foreign keys, added new properties in order to select the parent table of a foreign key and filter available columns.

  • 1.7.1.v015.218: Add "datetime2" datatype to the MSSQL technology

  • 1.7.1.v015.213: New RDBMS Technology: Vertica

  • 1.7.1.v013_20121214.20121214.5: Added the ref:schema() function for mappings to switch to the desired schema. For example: %x{md:objectPath(ref:schema("<SCHEMA>"),'<OBJECT>')}x%

  • 1.7.1.v013_20121214.20121214.4: Added the cdcAlternateName property on RDBMS tables to define the name of the CDC objects.

  • 1.7.1.v014_201300221.20130221.2: Removed "delete from diagram" contect menu on Processes

  • 1.7.1.v014_201300221.20130221.1: Removed "delete from model" context menu on Mappings

  • 1.7.1.v013.20121206.23: Global improvement of context menus.

  • 1.7.1.v013.20121206.22: Added fast creation for metadata configurations.

  • 1.7.1.v013.20121206.16: Links icons changed in the palette.

  • 1.7.1.v013.20121206.15: Added in the palette the "unsuccessful" and "anyway" links.

  • 1.7.1.v013.20121206.14: Added a "meta-inf" tab and a description in the process editor.

  • 1.7.1.v013-20121206.12: Naming change for the SSH_PUBLIC_KEY_FILE parameter to SSH_PRIVATE_KEY_FILE for ssh and scp actions.

  • 1.7.1.v013-20121206.6: Added the newInstance method for scripting (ctx) to instantiate a class with a specific classloader.

  • 1.7.1.v013.20121206.5: A double-click on a template in a mapping now opens this template.

  • 1.7.1.v013.20121206.3: Support for reverse-engineering and DDL for the ccsid property for AS/400-DB2 Graphic fields (graphic, vargraphic, dbclob).

  • 1.7.1.v013.20121206.2: Reverse-engineering specific queries can use an XPath expression for triggering (performance optimization).

Runtime
  • 1.7.1.v017.452: New parameter "silent" to the "connect" command avoids standard output feedback.

  • 1.7.1.v017.449: New option "var" on execute delivery and schedule delivery commands allowing to pass a Variable value

  • 1.7.1.v017.419: Initial Pool Size for JDBC connections is set to 1 by default

  • 1.7.1.v017.403: New attribute "status" allowing userLog event filtering. Allowed values are: EXECUTED, ERROR, KILLED

  • 1.7.1.v017.369: Web Service invocation now supports XOP and MTOM binary data formats

  • 1.7.1.v017.356: Web Service invocation supports WSSE Security

  • 1.7.1.v017.276: Runtime now supports user log events production to enrich actions.

  • 1.7.1.v017.113: Runtime no longer requires a JDK to publish Web Services.

  • 1.7.1.v016.252: Stopping a Runtime with sessions in "Waiting" status stops the scheduler and the execution services.

  • 1.7.1.v014_201300221-20130221.11: Added header parameters to xmlToWsdl Action (HTTP)

  • 1.7.1.v014_201300221-20130221.6: Copy file action now allows regexp or glob as the file name mapper

  • 1.7.1.v014_201300221-20130221.5: Move file action now allows regexp or glob as the file name mapper

  • 1.7.1.v014_201300221-20130221.4: New parameter "wait sessions" to the stop runtime command

  • 1.7.1.v014_201300221-20130221.3: New runtime commands: pause trigger and resume trigger

  • 1.7.1.v014_201300221-20130221.1: New runtime command: wait session

  • 1.7.1.v013_20121220-20121220.6: Added the OS_TIMEOUT parameter on the Operating System action to stop this after the duration expressed in milliseconds.

  • 1.7.1.v013_20121220-20121220.5: New parameter "duration" to the get sessions command.

  • 1.7.1.v013_20121220-20121220.4: get session command now filters on the current runtime only.

  • 1.7.1.v013_20121220-20121220.3: Memory cleaner log session timeout now set to 30 seconds instead of 300 by default.

  • 1.7.1.v013_20121220-20121220.2: SOAP Server now support multi-threading.

  • 1.7.1.v013_20121220-20121220.1: Optimized memory usage.

  • 1.7.1.v013_20121211-20121211.1: startcommand.sh now supports the -usage or -file options.

  • 1.7.1.v013-20121206.23: Added the optional userLogRDBMSEncryptedPassword parameter in the runtime parameter files.

  • 1.7.1.v013-20121206.4: New Runtime Command : <start|stop|restart> <name> service

  • 1.7.1.v013-20121206.3: New Runtime Command : <stop|restart> session <id>

  • 1.7.1.v013-20121206.2: New Runtime Command : get services [name <name>] [format <format>]

  • 1.7.1.v013-20121206.1: New Runtime Command : get sessions [name <name>] [id <id1,id2,idn>] [status <running,error,done,stopped>] [limit <limit>] [format <format>]

Analytics
  • 2.0.7.261: Sessions can be deleted from the Sessions Reports editor

  • 2.0.7.202: Hide the "Statistics" keyword in the statistic list

  • 2.0.7.200: The Remove button is replaced by a Delete context menu in the Repository editor

  • 2.0.7.199: New error message when a configuration referenced by other objects cannot be deleted.

  • 2.0.7.194: Better tooltip when a wrong Configuration code is provided

  • 2.0.7.184: The Delete context menu is disabled in the Session editor

  • 2.0.7.183: Added tooltips on the buttons of the Session editor

  • 2.0.7.181: Focus is now set on the Folder name when creating a new folder

  • 2.0.7.149: When creating a new Schedule its name is initialized with the name of the Delivery

  • 2.0.5.20121207.6: Monospace font for the command editor.

  • 2.0.5.20121207.2: Added CronDayOfWeek (#) to the scheduler.

Bug Fixes

Designer
  • 1.7.1.v017.461: Default variable value is displayed in Designer instead of the one really used when the runtime is stopped/restarted.

  • 1.7.1.v017.408: The XML Path is removed when reverse-engineering a root element twice.

  • 1.7.1.v017.391: HSTORE datatype is missing for PostgreSQL.

  • 1.7.1.v017.390: Rejects detection code for Foreign Keys is not generated

  • 1.7.1.v017.372: Foreign key is reverse-engineered twice when the parent table is not reverse-engineered.

  • 1.7.1.v017.287: NullPointerException when reverse-engineering a WSDL with a namespace

  • 1.7.1.v017.279: Performance issue when saving a Mapping with a complex expression.

  • 1.7.1.v016.251: When setting a property for the first time, the label of the object’s node is not refreshed properly

  • 1.7.1.v017.204: Charset Name is ignored in the File editors

  • 1.7.1.v017.156: NullPointerException when reverse-engineering an XML file without refreshing the root element first.

  • 1.7.1.v017.153: The file wizard of the XSD Generator looks for an XML file instead of an XSD file

  • 1.7.1.v016.236: Oracle Materialized View Columns are reverse-engineered twice.

  • 1.7.1.v015.217: Schema cannot have "no" in the physical name, "no" disappears with code generation

  • 1.7.1.v015.219: "All" nodes in a WSDL definition cannot have "element" as a child

  • 1.7.1.v015.206: On an implicit outer Join on Oracle, the keyword "(+)" is not automatically added within "is null" or "is not null" expression

  • 1.7.1.v015.186: Metadata is deleted from workspace when saving a mapping with same name in the same folder

  • 1.7.1.v014_201300221.20130221.12: Number of seconds displayed in connection retry is not accurate.

  • 1.7.1.v014_201300221.20130221.6: Team preferences do not show automatically.

  • 1.7.1.v014_201300221.20130221.3: Encoded arrays were not always reverse-engineered.

  • 1.7.1.v013_20121214.20121214.3: Creating a purge via the editor incorrectly sets the host and port to the default runtime.

  • 1.7.1.v013_20121214.20121214.2: The purge editor always points to the latest one.

  • 1.7.1.v013_20121214.20121214.1: Exception in the property editor for a link with an execution condition.

  • 1.7.1.v013.20121206.24: Memory optimization at code generation issue.

  • 1.7.1.v013.20121206.19: Removed certain popup menus (validation, load resource etc.)

  • 1.7.1.v013.20121206.18: Memory Optimization for the process editor.

  • 1.7.1.v013.20121206.13: Refactoring of the link parameter and metadata link objects in the process editor.

  • 1.7.1.v013.20121206.12: Fixing an incorrect behavior when copying/pasting a parameter between two processes.

  • 1.7.1.v013-20121206.11: The passphrase is mandatory for getScp and putScp actions when a key file is specified.

  • 1.7.1.v013.20121206.7: Memory Optimization for the mapping editor.

  • 1.7.1.v013.20121206.6: Duplicate operation is removed from mappings

Runtime
  • 1.7.1.v017.414: Issues when using transactional mode on Teradata

  • 1.7.1.v017.401: ReadMail: Exception is thrown when "Mail Keep on Server" is unchecked and reading emails from an IMAP server.

  • 1.7.1.v017.392: ReadMail generates an error when receiving an email without subject.

  • 1.7.1.v017.318: ReadMailAction: Connection timeout is ignored

  • 1.7.1.v017.311: XML attributes are ignored with no apparent reason.

  • 1.7.1.v017.309: Runtime unexpectedly hangs when executing multiple mappings in parallel in the same process.

  • 1.7.1.v017.292: ExecuteDelivery ignores parameters DELIV_ENGINE_HOST et DELIV_ENGINE_PORT

  • 1.7.1.v017.267: Action SqlToParameters used repeatedly on Oracle throws Max Open Cursors error

  • 1.7.1.v017.127: Runtime connection Retry time does not wait the specified number of seconds.

  • 1.7.1.v014_201300221-20130221.10: Action xmlToWsdl SOAP RPC, unable to read output

  • 1.7.1.v014_201300221-20130221.9: Format option does not work with the get sessions command

  • 1.7.1.v014_201300221-20130221.8: Jython is not working in the Action scripting

  • 1.7.1.v014_201300221-20130221.7: Kill runtime command generates an error on the console

  • 1.7.1.v013_20121214-20121214.1: Scheduled purge causes an exception when the purge is scheduled with the editor (works with the command line)

  • 1.7.1.v013_20121212-20121212.1: The execute delivery does not work in memory when host and port are not set.

  • 1.7.1.v013_20121211-20121211.2: If the SOAP service is not started, retrieving the detail of the deliveries no longer work (from Analytics or a command line).

  • 1.7.1.v013.20121206.4: Added a #!/bin/sh header to the builddelivery.sh file.

Analytics
  • 2.0.7.334: Context menu "delete" should be "Delete" in the Repository editor

  • 2.0.7.329: Error 404 when opening the Documentation in a new Window

  • 2.0.7.328: A ghost folder is created when a Session Report is created in a folder with a name containing a space.

  • 2.0.7.231: When executing a Delivery with a parameter, the value passed for the parameter is {value=<ParameterValue>} instead of <ParameterValue>

  • 2.0.7.208: When a Runtime is deleted from the Parameter editor, it remains in the Repositories which were using it

  • 2.0.7.201: Some labels are aligned to the right in the Repository editor

  • 2.0.7.196: When building a Deliverable the focus is lost from the repository editor

  • 2.0.7.188: The profile itself is in the list of objects that can be included in a Profile

  • 2.0.7.178: The Pause menu entry is enabled when multiple Schedules are selected in the Navigator

  • 2.0.7.155: NullPointerException when viewing the Threads tree in the Monitoring tab of a Runtime

  • 2.0.7.151: Wrong Session name displayed in the Schedule editor

  • 2.0.7.142: Editing a paused Schedule doesn’t reset the pause/resume icons

  • 2.0.7.141: Manually modifying the start or end date of a schedule doesn’t allow further modification

  • 2.0.7.102: When deleting a Repository, the corresponding Repository editor should be closed

  • 2.0.7.86: Information tab is incorrectly refreshed when switching between two Actions

  • 2.0.7.40: The Publish menu entry on a Package should be disabled when no Runtime is declared

Version 2.0.0 (2.0.0-GA_Build17.1.12)

New Features

  • Initial Release of Semarchy Convergence for DI Analytics - Web Application v2.0.0.

  • 1.7.1.v012.20121120.1: Designer now uses the Eclipse/Juno platform.

  • 1.7.1.v012.20121120.1: Support for Windows 64bit

  • 1.7.1.v012.20121120.1: Support for Linux 64bit

  • 1.7.1.v012.20121120.1: Support for Linux 32bit

  • 1.7.1.v012.20121120.3: Support for linked projects.

  • 1.7.1.v012.20121120.5: New "Preview" display for fixed file reverse-engineering

  • 1.7.1.v012.20121120.10: Refactoring of the .bat files.

  • 1.7.1.v012.20121120.11: Refactoring of the "impact" view.

  • 1.7.1.v012.20121120.: Embedded Web application in Designer is replaced by Semarchy Convergence for DI Analytics web application.

  • 1.7.1.v012.20121120.13: Runtime modules are now added to the Analytics application.

  • 1.7.1.v012.20121120.15: Added an XSD editor for XML metadata.

  • 1.7.1.v012.20121120.16: Added an text editor for Text metadata.

  • 1.7.1.v012.20121120.17: Added an XML editor for XML metadata.

  • 1.7.1.v012.20121120.28: Added an icon for the actions with error tolerated in the process editor.

  • 1.7.1.v012.20121120.29: Added a green border for actions set as "begin action"

  • 1.7.1.v012-20121020.8: Read and Send Mail can log in a database when a database schema link is added to these actions.

  • 1.7.1.v012-20121020.9: Added a SQL_EXP_NULL_VALUE_REPLACEMENT parameter for the SqlFileExport action to generate a specific character for null values.

  • 1.7.1.v012-20121020.14: New Runtime Command : purge keep <number> <minute|hour|day|session> [sessionname <name,name2,…​>] [status <done,error,killed>]

  • 1.7.0.v011_20121016-20121016.2: New execution variables : CORE_STACK_TRACE_NEXT_XXX in order to retrieve the following SQL errors.

  • 1.7.0.v011_20121011-RUNTIME.20121011.7: Added the capability to transform lines through scripting in the File JDBC Driver.

  • 1.7.0.v011-DESIGNER.20120924.11: New menu items to create metadata, mappings and processes through the File and context menus.

  • 1.7.0.v011-DESIGNER.20120924.7: "Action > Count Data" context menu allows counting the result of joins and filters in mappings (Multiple Selection is supported).

  • 1.7.0.v011-RUNTIME.20120924.3: Unzip File and Untar File actions: Added the "include" and "exclude" parameters to manage selection patterns.

  • 1.7.0.v011-RUNTIME.20120924.2: SqlFileExport action: added the "SQL Export Short Date Format" (which default value is the value of the "SQL Export Date Format" parameter) and "SQL Export Time Format" (default value: null) to handle date and time formats.

  • 1.7.0.v011-RUNTIME.20120924.1: SQL To Parameters Action added the defaultValue and failsIfNoRecord attributes (default value: false).

  • 1.7.0.v010-DESIGNER.20120831.5: Added the "Alternate Name" property on technologies (XML Element) for replication purposes.

  • 1.7.0.v010-DESIGNER.20120831.4: DB2/400 technology: Added data types BLOB, DOUBLE, CLOB and BIGINT

  • 1.7.0.v010-DESIGNER.20120831.1: RDBMS technology: Added the "Drop Table If Exists Syntax" expression depending on database types.

  • 1.7.0.v010-RUNTIME.20120802.5: Write to File Action: Added handling of \n and \t in the line separator.

Bug Fixes

  • 1.7.0.v011_20121011-DESIGNER.20121011.3: History in SqlExplorer is disabled by default, which may cause side effects.

  • 1.7.0.v011_20121011-RUNTIME.20121011.6: Values in the FILE_OPERATION column of the IND_SESSION_FILE_OP_LST table have been standardized. Old Values: "Ftp Put Ftp Get waitFiles Make Dir". New Values: "FtpPut, FtpGet, Copy, Move, Delete, Wait, MakeDir".

  • 1.7.0.v011_20121011-RUNTIME.20121011.3: FTP Put and FTP Get actions: Informations (FILE and DIR) were incorrectly written in the IND_SESSION_FILE_OP_LST table.

  • 1.7.0.v011_20121011-RUNTIME.20121011.2: SQLToXML Action: fixed the error caused when using the xsi:nul="true" feature.

  • 1.7.0.v011_20121011-RUNTIME.20121011.1: Unzip File and Untar File actions: Fixed a regression introduced by bug fix #20120924-3.

  • 1.7.0.v011-DESIGNER.20120924.22: When using the "Arrange All" operation on processes the parameters are now correctly vertically aligned.

  • 1.7.0.v011-DESIGNER.20120924.10: Improved the "Arrange All" operation on mappings.

  • 1.7.0.v011-DESIGNER.20120924.9: Fixed broken links issues in mappings.

  • 1.7.0.v011-DESIGNER.20120924.8: "Snap to Grid" diagram property is disabled by default on mappings.

  • 1.7.0.v011-DESIGNER.20120924.3: In the RDBMS technology, fixed the creation order for PKs and FKs

  • 1.7.0.v010-RUNTIME.20120802.3: Make a Directory action is fixed and now works even if it is not linked to a database.

Version 1.3.2 (1.3.2-GA_Build17.0.9)

New Features

  • 1.7.0.3-RUNTIME.20120510.3: New option for the Operating System action: OS Standard Input Limit Size, maximum size for the standard input reader for the sub-process. Default value is -1: No limit.

  • 1.7.0.3-RUNTIME.20120510.4: New option for the Operating System action: OS Error Input Limit Size, maximum size for the standard error reader for the sub-process. Default value is -1: No limit.

  • 1.7.0.3-RUNTIME.20120510.5: New option for the Operating System action: OS Successful Exit Code, return code on success. Default value is 0.

  • 1.7.0.4-RUNTIME.20120601.4: Execute Delivery action now passes variables to the child session.

  • 1.7.0.4-RUNTIME.20120529.1: startCommand can be used in non-interactive mode. Commands can be passed on the command line, separated by a ";".

  • 1.7.0.4-DESIGNER.20120530.7: New userLogRDBMSIndexCreationOption and userLogRDBMSTableCreationOption options in the log configuration files for creating indexes.

  • 1.7.0.5-DESIGNER.20120615.1: RDBMS.tech added remarks for schema, server, pk, fk, ak and ck

  • 1.7.0.5-DESIGNER.20120614.7: New parameter Deliv Standard Output Redirection for the ExecuteDelivery action.

  • 1.7.0.5-DESIGNER.20120614.5: Mapping metadata generation optimization (with an Index).

  • 1.7.0.5-DESIGNER.20120614.1: File Driver and Reverse-engineering: Added a Transformation script to preprocess the file.

  • 1.7.0.6-DESIGNER.20120622.6: New parameter SQL Disable Bn Rows Statistic to disable the Nb Rows Statistics.

  • 1.7.0.6-DESIGNER.20120622.3: map.tech and RDBMS.tech modified to generate [sesionTimestampName] and truncation size for the object mask.

  • 1.7.0.7-DESIGNER.20120629.7: Added the conversion for XML string to CLOB for MySQL.

  • 1.7.0.8-RUNTIME.20120713.6: New loglevel parameter can be specified in the Process Metainf field: <logLevel>0|100|200|300|400</logLevel>.

  • 1.7.0.8-RUNTIME.20120713.3: Added four new indexes in the log tables to optimize the purge.

  • 1.7.0.8-RUNTIME.20120713.2: XML Action can implement a specific DataTypeConverter.

  • 1.7.0.8-DESIGNER.20120713.5: Added the Datastore Exclude Type property of RDBMS Technology definition to exclude types of datastores from the reverse-engineering process (e.g. INDEX for PostgreSQL)

  • 1.7.0.8-DESIGNER.20120713.4: Added the conversion for XML string to LONGVARCHAR for MSSQL

  • 1.7.0.9-RUNTIME.20120727.12: XML files accessed for reading now support file name masks. XML load template reads all corresponding files in one pass.

  • 1.7.0.9-RUNTIME.20120727.8: SqlFileExport action now manages Oracle dates as timestamps and use the full precision.

  • 1.7.0.9-RUNTIME.20120727.4: Log tables now include a new field to store the Package ID.

  • 1.7.0.9-RUNTIME.20120727.3: CORE_TIMESTAMP is now unique for each runtime agent.

  • 1.7.0.9-DESIGNER.20120727.13: Memory Optimization for code generation.

  • 1.7.0.9-DESIGNER.20120727.11: XmlToJdbc, JdbcToXml and XmlToWSDL no longer appear in the palette. These actions are still available for usage into templates.

  • 1.7.0.9-DESIGNER.20120727.8: Added the concept of View to display the hierarchy of the tables based on foreign keys for the database metadata files.

  • 1.7.0.9-DESIGNER.20120727.7: Packages can be generated with the documentation.

  • 1.7.0.9-DESIGNER.20120727.3: Delimiters can be added to the temporary tables.

  • 1.7.0.9-DESIGNER.20120727.4: Temporary table names are computed from the physical name instead of the logical name.

Bug Fixes

  • 1.7.0.3-RUNTIME.20120509.6: Operating System action: The standard output that was not correctly read.

  • 1.7.0.3-RUNTIME.20120510.1: SqlFileExport Action: OUT_FILE_SIZE was computed in Kb and not in bytes.

  • 1.7.0.3-RUNTIME.20120509.5: Unclosed sessions left on the log database when watching for dead sessions. The problem is fixed, and dead session monitoring can be disabled by setting the userLogRDBMSInactivityDetectionPeriod parameter of the log configuration to -1.

  • 1.7.0.3-DESIGNER.20120509.3: Metadata link variables are no longer visible by default by the parent process. Visibility is now set by default to Current, and can be changed in the metadata link variable properties.

  • 1.7.0.4-RUNTIME.20120524.1: Log table fix for MySQL.

  • 1.7.0.4-RUNTIME.20120524.2: Index IDx_PROPERTY02 is disabled in the log table. This index is no longer needed and causes issue on MySQL/MyISAM.

  • 1.7.0.4-DESIGNER.20120530.10: Fix for column size reverse-engineering on Oracle Database (for BYTE or CHAR).

  • 1.7.0.4-DESIGNER.20120530.9: Code generation issue fixed when using "\" or "$" in the schema names.

  • 1.7.0.4-DESIGNER.20120530.8: Code generation issue fixed when using "tag" in the RDBMS or datastore metadata.

  • 1.7.0.4-DESIGNER.20120530.6: Fix for the buildDelivery.bat|sh scripts to work without XML externalization files.

  • 1.7.0.4-DESIGNER.20120530.5: Fix for property externalization for linked schema (sub metadata link).

  • 1.7.0.4-DESIGNER.20120530.4: Fix for delimited file reverse-engineering. Refresh did not work correctly when some columns were not defined.

  • 1.7.0.4-DESIGNER.20120530.3: Fix for buildDelivery.bat to support new package format.

  • 1.7.0.7-DESIGNER.20120629.6: Missing TEXT datatype for MySQL.

  • 1.7.0.8-RUNTIME.20120713.4: Fixing the purge for the new log tables.

  • 1.7.0.8-DESIGNER.20120716.8: DATE column for Oracle DBMS no longer loose precision in bind mode.

  • 1.7.0.8-DESIGNER.20120713.7: Mapping code generation ${ }$ corresponding to user variables are transformed to %{ }%.

  • 1.7.0.9-RUNTIME.20120731.2: Cursor not correctly released on Oracle when saving a delivery.

  • 1.7.0.9-RUNTIME.20120727.10: Read Mail action now terminates correctly when an error occurs.

  • 1.7.0.9-RUNTIME.20120727.11: Send Mail action now terminates correctly when an error occurs.

  • 1.7.0.9-RUNTIME.20120727.1: File management actions are now reinitialized at each bind (bind links)

Version 1.3.1 (1.3.1.GA_Build17.0.1)

New Features

  • 1.6.1.4-DESIGNER.20120312.3: New file driver supporting multi-record files. You can add record child elements in a file metadata to define the various record formats.

  • 1.7.0.1-DESIGNER.20120427.5: Mail Server technology: New toTextList property.

  • 1.7.0.1-DESIGNER.20120427.3: New reverse-engineering option (Databases, XML and WSDL) to delete elements and columns that no longer exist.

  • 1.7.0.1-DESIGNER.20120427.2: Database reverse-engineering: new option to enable/disable foreign keys reverse-engineering.

Bug Fixes

  • 1.7.0.1-DESIGNER.20120427.1: Reverse-engineering now retrieves correctly CHAR and BYTE information on Oracle Databases.

Version 1.3.0 (1.3.0.GA_Build16.1.3)

Initial Release, no change log.