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.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 processe 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.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 processe 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.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.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.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.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.