Welcome Guest! Log in

Using Mapper utility

    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.

    Read more: Using Mapper utility

    Restoring deleted objects

      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 :

      • Right click on the parent element (project or folder) / Restore from local history...
      • the User interface will show the items which were recently deleted

       

       

       

      Displaying the required and missing dependencies for an item

        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

        Upgrading Mappings

          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.

          Read more: Upgrading Mappings

          Configuring JDBC drivers

            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.

            Configuring the JDBC Driver entry

            • Open the Designer's Preferences (menu Window / Preferences)
            • Select the "SQL Explorer / Jdbc Drivers" entry on the left
            • If the database is not listed, then click Add, otherwise select it and click Edit
            • The following popup is displayed (example for Microsoft MSSQL) :

            563 edit driver

            • Name: not technical, this is the description of the Driver
            • Example URL: this will be used to provide an URL example when creating metadatas
            • If your JDBC jar file is not listed in the Extra Class Path tab, then click "Add JARs" and add it
            • Select your JDBC jar file in the list and click "List Drivers"
            • Make sure the appropriate "Driver Class Name" is selected at the bottom of the popup
            • Click OK and OK again

             

            Your Designer is now ready to connect to databases using this JDBC driver.

             

            Articles

            Suggest a new Article!