Welcome Guest! Log in


In this article

You can find below the major changes and improvements of Stambia DI Designer 2020 (S20.3.x) version.

This article only highlights the most important changes.

If you need further information, please consult the full changelog and/or reference documentation.

 

Prerequisites

Migration from S17, S18, S19

Stambia DI 2020 (S20) major version changes some important part of the software which require your attention.

Migrating from Stambia DI Designer S17, S18 or S19 require to follow the migration guide, which can be found in the following article.

If you are simply updating from another Stambia DI 2020 (S20) version, simply follow the minor version upgrade guide, as usual.

 

What's new on Stambia DI Designer 2021 (S20.3.1)

Stambia DI Components Updated (20.3.1)

You can find in this section the list of Components which have been updated in Designer 20.3.1.

Note that this lists only the Components shipped within a default Designer.

Components name Update Description Components release notes
Base component Some improvements and fixes about Mail Process Actions Release notes

HTTP REST component

Two new metadata attributes have been added in HTTP REST technology and in HTTP Security Metadata, which allow to indicate if certificate and hostname verifications should be performed.

Two new parameters in the Tempalte "INTEGRATION Rdbms to HTTP Rest". (Nil Behaviour and Write XML Key Values)

Release notes
Microsoft Excel component Some fixes Release notes

 

Metadata improvements:

Externalize OAuth2 properties through a json structure

To be able to externalize OAuth2 “additional properties” metadata attribute, an attribute “Json Properties” which contains directly a JSON representation of all the OAuth2 attributes has been added, this attribute is automatically generated.

json structure

For compatibility purposes, an attribute named “Use Json Properties” is also added to enable / disable the use of the Json Properties.

When enabled, the Templates will use the Json Properties, when disabled (default value), it will use the attributes uniquely as before.

Use json Properties

Once externalized, user will be able to modify the whole JSON in analytic.

jso analytics

Externalize default value of attribute

With previous version of designer, when an attribute externalization is set to enable, only the attributes on which the user has defined a manual value is externalized. It has bee improved to externalize attribute with its default value if no value is provided by the user.

 

Certificates and hostname verifications

New attributes allowing to indicate that if certificates and hostname verifications should be performed. These attributes are available on HTTP Security OAuth2 Metadata and on HTTP REST.

On HTTP Security OAuth2 Metadata, the parameter allows to define if the verification should be performed on the exchange performed to get OAuth2 token.

On the HTTP REST Metadata, the parameter allows to define if the verification should be performed, for the certificates verifications of the operation itself.

Default values of these parameters are "true" and when setting it to false the certificates and hostname verifications are not performed

hostname certificate verif

 

 

Complete changelog

The complete changelog with the list of improvements and fixed issues can be found at the following location.

 

What's new on Stambia DI Designer 2021 (S20.3.0)

Stambia DI Components Updated (20.3.0)

You can find in this section the list of Components which have been updated in Designer 20.3.

Note that this lists only the Components shipped within a default Designer.

Components name Update Description Components release notes
Base Component Some improvements and fixes Release notes
HTTP REST Component Adding multipart request contents support, adding a cookies response, connection and read timeouts, OAuth2 improvements. Release notes
Hyperfile Component Homogenization of the Change Data Capture usage Release notes
IBM DB2 Component Homogenization of the Change Data Capture usage Release notes
IBM Informix Component Homogenization of the Change Data Capture usage Release notes
Microsoft Excel Component Adding support to delete statements which works with "delete all target table" Release notes
Microsoft SQL Server Component Adding new option in load file Mssql template, homogenization of the Change Data Capture usage, adding reversing indexes support. Release notes
MySQL Component Homogenization of the Change Data Capture usage, adding a new datatypes and creation mask. Release notes
Oracle Component Adding new parameters and attributes, homogenization of the Change Data Capture usage Release notes
PostgreSQL Component Adding new support for xpath expressions and for automatic creation of primary key, adding json datatypes, homogenize of the Change Data Capture usage. Release notes
Progress Component Some improvements and fixes Release notes
SAP ASE Component Homogenization of the Change Data Capture usage Release notes

 

Twitter Component

Stambia Data Integration allows to work with Twitter.

You can reverse in Metadata the common operations which can be performed with Twitter such as posting and searching Tweets, retrieve various information, and more...

You can also design your own operations as you want.

Refere to this article for more information.

You can find Components download section and installation procedure at this location.

 

Usability Improvements

Warning when Runtime not connected

When performing operations from Designer which require a Runtime while no Runtime is connected, a warning popup will now appear to inform about it.

Being connected to a Runtime is necessary for instance when performing operations such as prepare, execute, publish, ...

This helps to be warmed before executing the operation which, when no Runtime is connected, might fail.

 

warning01

 

Open Mapping from breadcrumb trail

When navigating in a Process which contains Mappings, a new context menu called "Open Mapping" has been added to open a Mapping directly from breadcrumb trail.

This menu is available by right clicking on the Mapping in the breadcrumb trail:

open mapping

XPath menus ordered alphabetically

XPath and Global XPath context menus which are available at several places such as in Metadata, will now show their list of XPath expressions ordered alphabetically.

 

Metadata link - XPath menus

On Processes, XPath and Global XPath menu have been added when right clicking on a Metadata Link.

This allows to quickly access the available XPath expressions without having to open the related Metadata.

Xpath01

 

Metadata Link - tooltip displaying real name

The real name of the Metadata node which is being a Metadata Link is now displayed as tooltip when hovering it.

This allows to see the real name quickly when the Metadata Link name is different than the real name of the Metadata, without having to open the Metadata.

metadatalinkName

 

Metadata reference attributes improved

On Metadata, reference attributes had a tooltip on the left which was indicating that it was a reference attribute, and that it supports therefore drag and dropping references inside.

The icon of the tooltip was the same as the icon for the documentation, and the text was not clear enough to help understanding its usage.

We therefore revised this information by changing its icon, location and text:

 

On previous versions:

icone01

 

On this new version:

BQ02

 

Syntax highlight on SQL File Export Process Action

Syntax highlight is now available also on SQL File Export Process Action.

sql file export syntax highlight

 

New button to remove transparent stage

A new button has been added to remove easily a defined transparent staging area.

button remove transparent staging area

You can still remove it also by deleting it on the datastore as it was possible before.

 

 

Upgrade Mapping Models

The menu "Upgrade Mapping Models" has been renamed to "Upgrade Models" for clarity because it can apply also on other models, such as Metadata and Processes.

This menu, which can also be used to upgrade several models at once by selecting multiple Projects / folders / Mappings / ... has also been improved to appear as soon as one of the selected items contains outdated models.

Before this change, it was only displayed when all selected models were outdated, which was making hard to update models massively in a workspace.

upgradeModels

 

File Reverse Wizard

We added, in Runtime S20.1.0 the support of escape character when reading files, for files which does not have string delimiter and instead escape the characters of data which can cause issues.

This works well at execution when reading files through Runtime, in a Mapping or Process.

But it was not yet implemented in the File Reverse Wizard, so we updated the reverse wizard to also support it:

 

Escape01

 

Execute Delivery Process Action

New parameter to define repository

Prerequisites:
  • Stambia DI Runtime S20.3.0

 

Addition of a new parameter to define the repository from which Runtime repository the delivery should be executed.

This parameter defines the runtime repository in which the delivery will be searched.

It is similar to the "-repository" parameter that is supported on startdelivery.bat script.

 

When this parameter is not defined it search for the delivery in default repository, as usual.

repo01

 

Minor improvements and fixed issues

This version also contains some other minor improvements and fixed issues, which can be found in the complete changelog.

 

Complete changelog

The complete changelog with the list of improvements and fixed issues can be found at the following location.

 

 

You have no rights to post comments

Articles

Suggest a new Article!