--- title: "ETL Import" slug: "etl-import" updated: 2026-07-08T12:50:06Z published: 2026-07-14T12:30:00Z canonical: "skthelp.syniti.com/etl-import" stale: true --- > ## 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. # ETL Import This topic is related to the following sections: - [Mapping the Fields of a Datasource](/v1/docs/mapping-the-fields-of-a-datasource) - [Mapping Import](/v1/docs/mapping-import) - [Reporting Import](/v1/docs/reporting-import) ## About Import As the clients who currently are supported with older versions of Syniti ADM or DMR Concento begin to upgrade into Syniti Migrate application, the active data is converted into this system. The users extract from the older version the mappings for each table into an Excel spreadsheet of standard fields (**ETL Import Template.xlsx**). They extract and save each active mapping to import into Syniti Migrate using this set of pages. This process imports only Excel extensions and fails should the user attempt to import other extensions (Ex: txt, csv) > [!NOTE] > Note > > *UTF- 8 double-byte characters load using Excel Import (Ex: Japanese or Korean language).* ## Prerequisites Prior to importing mappings metadata from a prior version of Stewardship Tier ADM or from DMR Concento complete the following steps: - Create the Datasources within [Catalog > Datasources](/v1/docs/datasources) for Source Datasource and Target Datasource. - Create the Subject Area within [Administer > Setup > Subject Areas](/v1/docs/subject-areas). - Create the Dataset within [Catalog > Dataset Design](/v1/docs/dataset-design). - The Project, Release, Milestones, and assigned Subject Area must be set up within [Migrate > Project Setup.](/v1/docs/project-setup) - Set the ETL Tool for Syniti Migrate within either the [Parameters](/v1/docs/parameters) page or the [Release](/v1/docs/creating-maintaining-releases) for the dataset. - The object data must be exported from the source system and organized within the template spreadsheet and saved as an Excel file. The excel file must have same names for the source datasource, target datasource, working datasource and release names as in the Syniti Migrate application. - The ETL Import Template may be produced locally by clicking the **Download Template** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/cb73870e-2670-4104-bb15-65c7c4e52048.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A51Z&se=2026-11-17T20%3A37%3A51Z&sr=b&sp=r&sig=dALMI%2FYGI%2BqzADBa2hox1%2BW4YmxZVgLF%2BcpiLv6FV9M%3D) button. Refer to [Download ETL Import Template](/v1/docs/etl-import#download-etl-import-template) section for details. ## ETL Import Template Spreadsheet During the initial setup of this application for a new project, the Admin should add the Mapping Import template file to [Migrate > File Management](/v1/docs/file-management) so that it is easily accessible for users. The Excel spreadsheet is titled **ETL Import Template.xlsx** and it may be requested from Syniti IT and then added to File Management for use. The spreadsheet must remain in its original form with no changes to the column sequence or column names. The template provides a few rows of example data for use in determining the field values. Make sure to use the same names for the Release, Dataset, Tables and Datasources as are setup within the target Mapping in Syniti Migrate for this ETL, otherwise the import will fail. The **ETL Import Template** spreadsheet contains column headers for: - RELEASE - DATASET_NAME - DATASET_TABLE - SOURCE_DATASOURCE - PRIMARY_TABLE - ETL_TYPE - TASK_INDEX - ACTIVE - TASK_TYPE - DESCRIPTION - DATA_ELEMENT_NAME - COMMENT - DATASOURCE - DB_OBJECT_NAME - AFFECTED_DATASOURCE - AFFECTED_DB_OBJECT_NAME - TEMPLATE KEY Use the Example Data worksheet as a reference when working with the ETL Import Template. The first row provides usage instructions, and the second row contains the column headers. > [!NOTE] > Note > > You can also download the Export - ETL Data report from Monitor > System Reports to view the ETL details for your releases. ## Import the Template Spreadsheet View the following page by navigating to **Administer > Imports > ETL Import** from the Syniti Migrate Homepage. The initial page displays as ETL Import Setup. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ETL Import_1.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A51Z&se=2026-11-17T20%3A37%3A51Z&sr=b&sp=r&sig=o6DHMkwGDARxf%2Fp971ackbJJYk5MpS0v2%2BD10iXnDSY%3D) ETL Import: Display Click **Choose File** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/e4a46871-8ad2-4146-8a3b-eadb6529c69e.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A51Z&se=2026-11-17T20%3A37%3A51Z&sr=b&sp=r&sig=sm6SN%2FIILEWlhQS%2B0owH0EH9nyCRrlAi%2BbF8KM9cKrs%3D) button and then select the appropriate file. Click **Open** to add this file to the page. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ETL Import_2.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A51Z&se=2026-11-17T20%3A37%3A51Z&sr=b&sp=r&sig=UasxEfBNWiyVykQov7fgMAS5xm4aUGFWeysdzWXDr7k%3D) ETL Import: Choose File The ETL EXTRACT TEMPLATE spreadsheet contains a row of notes and instructions at the top, and so the value in **Header Start Row** defaults to 3. Should there be need to alter the start row, change it now. The preview lists the first ten rows of data and the count of rows is provided within the Import File section in **Number of Records Detected**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ETL Import_3.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A51Z&se=2026-11-17T20%3A37%3A51Z&sr=b&sp=r&sig=gUM9zZrO2gsCTLAJsUmaYMS4NFNQe5VWBnO7sgQbzvA%3D) Click the **IMPORT ETL** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/f3312766-d3e4-4090-8de4-d4eb7943f67d.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A51Z&se=2026-11-17T20%3A37%3A51Z&sr=b&sp=r&sig=2YS7xoJ2L1hdlMrUGeNyaRKsfaFpIHZQUeTlhc%2BNkhs%3D) button to initiate the import of data to the assigned objects within Syniti Migrate. A warning message displays to request a selection of either **CANCEL** or **APPEND** or **TRUNCATE**. Depending upon the need, the user may want to append this new data onto an existing object, or they may want to truncate the tables and add this data as the only data for the object. The page indicates that the job is running. It updates to Status: Import Finished once complete. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ETL Import_6.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A51Z&se=2026-11-17T20%3A37%3A51Z&sr=b&sp=r&sig=uLZXbBnGzUPfdc3qgurHm9oCQkTeHSp7xFzVVhk0iN0%3D) ETL Import: Import Data Once the job completes, the user may click the **VIEW DIAGNOSTICS** (Debug Log) button to display the job queue. ## Job Queues Steps for Each Import The resulting job is entered as a Job Queue with the insert of ETL Tasks set as a step. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ETL Import_5.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A51Z&se=2026-11-17T20%3A37%3A51Z&sr=b&sp=r&sig=8WAinwZK%2FuNldBFwOX0L4k3cuDbA6GcmsZy7gny5PhI%3D) Job Queue: Import ETL ### Job Queue Steps for Failing Import If the import fails, the system will provide the **VIEW DIAGNOSTICS** button to view the Debug Log of the Job Queue. In this case, the import failed due to the data not matching existing data for the Datasource. Prior to importing these files, the system must be prepped for the Datasource and other objects. See [Prerequisites](/v1/docs/etl-import#prerequisites) section above for details. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ETL Import_6B.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A51Z&se=2026-11-17T20%3A37%3A51Z&sr=b&sp=r&sig=QlJc8UX9xckdf9CmXwzmPsga9I72KAzrAjArjGxbGRY%3D) ## Validate Data has Imported Successfully Once the import job queue has completed without errors, and the diagnostics have been viewed and verified, go to Mappings and click to view the ETL tasks to ensure that the list of tasks imported are displaying as expected. ### Source Transform Tasks All tasks labeled with **ETL_OBJECT_TYPE** = Interface Source will show within the working table ETL tasks as a Source Transform. The new tasks are set to allow for edit and delete, and their status will be unknown until the ETL is run to change status. ### Target Transform Tasks All tasks labeled with **ETL_OBJECT_TYPE** = Interface Target will show within the working table ETL tasks as a Target Transform. The new tasks are set to allow for edit and delete, and their status will be unknown until the ETL is run to change status. ## Download ETL Import Template To produce a local copy of the ETL Import Template, click the **Download Template** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/cb73870e-2670-4104-bb15-65c7c4e52048.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A51Z&se=2026-11-17T20%3A37%3A51Z&sr=b&sp=r&sig=dALMI%2FYGI%2BqzADBa2hox1%2BW4YmxZVgLF%2BcpiLv6FV9M%3D) button. This produces a local version of the Excel spreadsheet used to store the rows of data for ETL Import. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ETL Import_10.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A37%3A51Z&se=2026-11-17T20%3A37%3A51Z&sr=b&sp=r&sig=fXBz0qkmPFx29frUYkhS9xqz90%2F55bWlupmhGRVMNdc%3D) ETL Import: Download Template