--- title: "Mapping When Using Syniti Migrate ETL Tool" slug: "mapping-when-using-syniti-migrate-etl-tool" updated: 2026-08-05T14:08:37Z published: 2026-08-05T14:08:37Z canonical: "skthelp.syniti.com/mapping-when-using-syniti-migrate-etl-tool" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Mapping When Using Syniti Migrate ETL Tool This topic relates to the following sections: - [ETL Jobs](/v1/docs/<span class=) - [ETL Jobs Details](/v1/docs/etl-jobs-details) - [Execution of the ETL Jobs List](/v1/docs/execution-of-the-etl-jobs-list) - [ETL Version Selection](/v1/docs/etl-version-selection) - [ETL Tasks at the Release level](/v1/docs/etl-tasks-at-the-release-level) - [ETL Tasks at the Dataset level](/v1/docs/etl-tasks-at-the-dataset-level) - [ETL Tasks at the Target level](/v1/docs/etl-tasks-at-the-target-level) - [ETL Tasks at the Source level](/v1/docs/etl-tasks-at-the-source-level) - [Working Databases in Migrate](https://skthelp.syniti.com/docs/introduction-to-syniti-migrate#working-databases-in-migrate) ## About Mapping when using Syniti Migrate ETL Tool Syniti Migrate allows for conversion of migration data using the **ETL Jobs** tool stored within [Migrate > Mappings](/v1/docs/mappings) section of Syniti Migrate. If the project requires an ETL processing tool, they may activate the Syniti Migrate ETL Jobs Tool for one or more Releases within the application. Effects of this change are: - Developer completes the auto generated views for all Rules as part of the ETL build process. They may also add additional manual rules. - Developer maintains the order of all steps of the conversion within the **ETL Jobs** page - Developer executes the ETL Job process to run the conversion through SQL Server to update the working table and target table - As each Mapping is marked as Complete, the system updates for changes to the Working Table for all XREF and RULE XREF actions - As each Mapping in a dataset is modified, the system updates the target table to reflect same. Users maintain the Syniti Migrate ETL Tool within these sections of the system: - Parameters page - Field ETL Tool allows for assignment of Syniti Migrate as the ETL Tool as a default. Refer to section [Administer > Setup > Parameters](/v1/docs/parameters) for details. - Project Setup > Release - Field **ETL Tool** allows for assignment of Syniti Migrate as the ETL Tool for each Release. Refer to section [Migrate > Project Setup > Creating & Maintaining Releases](/v1/docs/creating-maintaining-releases) for details. Mapping of the Datasource to target table - Map a field as a Type = Rule or Rule XRef to provide access to ETL Tasks page where all supporting update rules are stored for ETL process. Refer to section [Mapping Action Details](/v1/docs/mapping-when-using-syniti-migrate-etl-toolMapping When Using Syniti Migrate ETL Tool) for a Rule using Syniti Migrate ETL Tool below for details. - Mappings > Release - Execute the ETL Job at the Release level to process all Datasets within the Release. Refer to section [Migrate > Mappings > Mapping the fields of a Datasource > ETL Tasks at the Release level](/v1/docs/etl-tasks-at-the-release-level) for details. - Mappings > Dataset - Execute the ETL Job at the Dataset level to process all Targets within the Dataset. Refer to section [Migrate > Mappings > Mapping the fields of a Datasource > ETL Tasks at the Dataset level](/v1/docs/etl-tasks-at-the-dataset-level) for details. - Mappings > Target - Execute the ETL Job at the Target level to process all Rules of each Datasource within the Target. Refer to section [Migrate > Mappings > Mapping the fields of a Datasource > ETL Tasks at the Target level](/v1/docs/etl-tasks-at-the-target-level) for details. - Mappings > Source - Execute the ETL Job at the Source level to process all Rules for that Datasource. Refer to section [Migrate > Mappings > Mapping the fields of a Datasource > ETL Tasks at the Source level](/v1/docs/etl-tasks-at-the-source-level) for details. ## Prerequisite for this Process In addition to the dependencies discussed within section [Migrate > Mappings](/v1/docs/mappings), the selection of an ETL Tool within the Release is required. Although the default for the Project may be set as any ETL Tool (including Syniti Migrate or SAP Data Services) as shown in the Parameters image below, each Release of the Project Setup must be assigned to the appropriate ETL Tool to set the use of that tool for the Mappings and Rules builds. > [!NOTE] > Note > > SAP Data Services ETL Tool is deprecated. Use **Syniti Migrate** as the preferred ETL tool. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/bf161561-b062-4ae3-9c5b-5b150e9d34d7.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=i0z4ZQ5t1ftcC9BxE6qfD3ikfen%2ByjZianeYrA7t9AU%3D) Administer: Parameters: ETL Tool ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/1626d06f-cd4f-4702-8411-25e973bc478f.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=wypPWlnXZPd7Er77v784658NaJQZH%2BTdLfIjZM0HOMc%3D) Project Setup: Release: Edit details ## Mapping Action Details for a Rule using Migration ETL Tool > [!NOTE] > Note > > Migrate Mappers and Migrate Developers can now use Rule Mapping Assist to refine mapping rules and generate the corresponding SQL/DDL statements, respectively, in alignment with the SynitiONE methodology. Refer to [Rule Mapping Assist](/v1/docs/rule-mapping-assist) for more information. ETL (Extract Transform Load) process within Syniti Migrate - Within Mappings, the conversion of data through mapping actions of field values produces a list of views in the database as well as building a conversion that may be executed within Syniti Migrate to translate the data from Source to Target. > [!NOTE] > Note > > If the ETL Tool is not Syniti Migrate, all ETL icons and ETL Task buttons are hidden - it is tied to user Security (Changes to the ETL Tool setting requires users to log off / log in to refresh and update these settings). Once the Mapping Rule action has been determined, options for the rule's details display - 1. **SIMPLE RULE** - A field ' Rule Sql' displays with a text field so the user may include a Simple Rule (EX: LEFT(NAME1, 25) ). The entry is part of the Simple Rules Task of the ETL Job for this Object (EX: zNAME1 = LEFT(NAME1, 25) ) 1. **COMPLEX RULE** - The **ETL TASKS** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/c1481f78-5cae-416f-811c-155423fa937d.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=yWTWLTTPDKw42Vp7FZtR4hBgm1NDxQkJP6ec73A0c7s%3D) button displays as active. Auto generate the Complex Rules based upon Views saved within ETL Tasks page. > [!NOTE] > Note > > Complex Rules generate a default Update Rule view in the working database if no other Rules have been registered against that DATA_MAP_ID. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image-KVBRQBO5.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=LBcR%2BNEP6xQy0CM7mxVRmBa1k6ta2hiidL7K91soMrU%3D) Mappings: Data Mapping Details of a Rule: Adding the View/Stored Procedure rule > [!NOTE] > Note > > In the event that the data map changes from complex to simple (i.e., non-complex) the complex tasks (rules) become disabled. For example, if a mapping changes so that it now can be handled via a simple Copy, all ETL tasks (whether automatically or manually created) should become disabled when the job is rebuilt. The update is part of the insert task so the additional rule(s) won't be necessary. ### Build the Complex Rule A click on the **ETL TASKS** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/c1481f78-5cae-416f-811c-155423fa937d.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=yWTWLTTPDKw42Vp7FZtR4hBgm1NDxQkJP6ec73A0c7s%3D) button changes pages to display the ETL Rules page for this mapping. The page opens with no rows of tasks at first. The tasks are auto generated once the user initiates the Build functions by opening the ETL Tool set with a click on **ETL** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ef6e3ad7-693e-49a3-a9de-a49fc0ba69c2.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=BpTOVe5fVvEnEc3MUchmSoVLNUktOmMgFVjB1yQkJ9Y%3D) icon within the Mappings main page. > [!NOTE] > Note > > This process is relevant for projects using anyone of the [Working Databases](https://skthelp.syniti.com/docs/introduction-to-syniti-migrate#working-databases-in-migrate). ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image-AAWEMOWN.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=wUFHtnZtTKtfV4UXAAFm9iMdC8DCJp4xzNzRyExpszI%3D) Mappings: Data Mapping Details of a Rule: After ETL Rules build Once the ETL Tasks have been built for the mappings marked as Complete, the ETL Tasks for Mapping Rule page contains the rows for each defined rule. In the example below, the Update Rule was auto generated as part of the ETL Jobs Task Build function. There are two tabs for Edit ETL Task - Edit ETL Task and Rule DDL The Edit ETL Task tab contains fields for the task type, while the Rule DDL tab shows the scripting of the Rule (View in database). ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image-0VQ8XUCQ.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=ADvHJ0P262nHRAQraiMX6SAnXZJ3oX4iBoV0CFKDP6Q%3D) ETL Rule: Edit ETL Task Rule DDL Tab contains scripting text for the task. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image-GAAXB05E.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=wsAWH8uu8%2BiDYO7YoubK9MnBlm%2FpljLFz2l3r7ipMxM%3D) ETL Rule: Rule DDL The Quick Access icons perform as listed: | Icon | Name | Use | | --- | --- | --- | | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/1357b27d-b8e2-4dbd-8e71-5a2ad3279b7b.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=L1vFTGOuzB3l8t%2BVDwWfweyhflF4zA2vrAUvSOeSvvk%3D) | View Mapping | Click to change pages to view the related mappings of this object. | | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/297c9b2c-3aa1-40af-975f-67d98a17f7a8.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=yPu9YZRd2S583wWqdetwhcLuxeO3UFjXNYtQVkF5TGY%3D) | Copy | This icon copies the data into a new task. | | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/7fd95075-9c0a-4b9b-b26a-60297be2ea0b.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=xfvZeFOMNYEHVAW60Q3WC7gDHY829VZBi8sycidTLsU%3D) | Save | Saves the current updates to system. | | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/48e09b45-0679-49f7-b24a-5f37f44f9e5e.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=IKRvhMqbwnpVPcjgCVkm79g7VkeBlnmuoFGx%2B65jzXA%3D) | Cancel | Cancels the current action without saving. | ## Subsequent Tasks for using Syniti Migrate ETL Jobs Tool Once all of the Mapping has completed, the user may build the ETL Job for this process. The first time an ETL icon is clicked, it attempts to build out the entire set of tasks for that panel and it sets all simple mappings as Build Complete. It produces a list of errors if necessary. At this point, the Rule Views and Stored Procedures should be completed within SQL Server by the user who validates that they are correct. Highlight a row for the Target Source and then click on the **ETL** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ef6e3ad7-693e-49a3-a9de-a49fc0ba69c2.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=BpTOVe5fVvEnEc3MUchmSoVLNUktOmMgFVjB1yQkJ9Y%3D) icon to view the ETL Job List for that Target Source Transform. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/d227f89f-da63-4aef-9535-db25f14596e8.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=1yVafLnQ2TXvAEHg2I%2BanODZ9WmPDJ2iZeNQWBGmt7E%3D) Mappings: Dataset: ETL JOBS Refer to section [Migrate > Mappings > Migration ETL Job > Execution of the ETL Jobs List](/v1/docs/execution-of-the-etl-jobs-list) for more details of this process. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/82b2633d-d409-4260-923d-88f71f707efc.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=JmQd3Kqq53A5SMKyjA1vBSieVLRNiHDeQj%2BLx6P564M%3D) Mappings: Dataset: ETL: ETL Job List Details ### Execute the ETL JOB Queue To run the object through the conversion process, the user clicks on the **ETL** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ef6e3ad7-693e-49a3-a9de-a49fc0ba69c2.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A08Z&se=2026-11-17T20%3A25%3A08Z&sr=b&sp=r&sig=BpTOVe5fVvEnEc3MUchmSoVLNUktOmMgFVjB1yQkJ9Y%3D) icon within the row of the Release, Dataset, Target, or Target Source. This opens the Job Queue window so that the user may select and run the job at that level. Should the user want to manage the jobs for the project overall, they use the ETL Job List from the main menu. Refer to section [Execution of the ETL Jobs](/v1/docs/execution-of-the-etl-jobs-list) for details of this process.