Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.
Mapping editor includes a utility called "Mapper" which helps to quickly define expressions in a special window where every source is listed for a given target.
All the objects can be accessed easily in this window and added in expression with a drag and drop or double click.
This article gives an overview of how to use it and the possibilities offered.
If you have accidentally deleted objects from the Project Explorer, you can try to restore them. You can rely on the versioning system functionalities you are using - such as GIT or SVN - but if you can't there is an other option :
When working on Projects, all the Metadata, Mappings, Processes and Templates might not be located at the same place.
Most of the time, users choose to structure developments in multiple projects, centralize all Metadata, etc.
This means that a Mapping, for instance, might depend on multiple Projects to work correctly.
The Designer offers the possibility, for a given item (Project, Folder, Mapping, ...) to list all its required dependencies, and the missing ones.
This can help users to find what is required, what is missing, and the potential place where it can be found.
Read more: Displaying the required and missing dependencies for an item
The internal structure of Mappings evolves silently between the versions to support the new Mapping features, to improve its cache indexation, and to make it more efficient.
The Designer updates the model version of existing Mappings through different ways, which are explained in this article.
The Designer can connect to JDBC databases for reversing table models and for executing SQL statements using SQL Editor.
JDBC drivers are provided by the database vendors, and you may need to download them and configure them in the Designer.
Your Designer is now ready to connect to databases using this JDBC driver.
