--- title: "Import Metadata" slug: "import-metadata" updated: 2025-01-06T05:07:01Z published: 2025-01-06T05:07:01Z canonical: "skthelp.syniti.com/import-metadata" --- > ## 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. # Import Metadata This topic is related to the [Adding & Editing Datasources](/v1/docs/adding-editing-datasources) topic. ## About Import Metadata The Syniti Data Catalog is the system of record for all datasources stored as system datasources within Syniti Migrate. The import of metadata from the legacy systems to the Data Catalog will pull in all tables of all databases within that relevant Datasource. Should a value change or a new field be added to the table within a legacy system, the Data Catalog is refreshed to update and then this data will be available to import to Syniti Migrate through the Import Metadata process. Within Datasources, while viewing Datasource Table Details, click the **Options** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/76a97251-f55b-4f94-817d-67d0a288cd47.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=uUO2GkyblLo15mBHj23%2F2AjsPY07WDqx2lF2b9AMEMY%3D) icon and click **Import Metadata** to refresh the metadata using SKP Data Catalog for changes to tables, fields, or columns, and for adding new metadata. This button allows users to refresh the active tables and columns from Migrate and show the most current metadata stored within SKP Data Catalog. Should the Datasource have a reasonable list of tables to pull, then the user may toggle **Import All** as active which pulls every table in the SKP Data Catalog list. In case of systems with large numbers of tables, the user should build out a list of valid, active tables within [Administer > Advanced > Applications](/v1/docs/adding-editing-applications). This subset of tables are pulled into the import metadata job queue when Import Metadata is selected at the Datasource level. > [!NOTE] > Note > > If the data imports from an SAP system, the **Import All** toggle is hidden. Setup Applications for SAP with all needed Active tables, and then run **Import Metadata** from the Datasource. Refer to section [Administer > Advanced > Applications](/v1/docs/adding-editing-applications) for more details of this process. > [!NOTE] > Note > > During the initial Import of Metadata for an Application, only the active tables are added to the import.Metadata for all tables (including System tables) imports in all subsequent runs. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/14a43dee-86b7-4c7e-933f-44879cffa355.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=vl5UjmVQojxEHRcwKe92UngHosUhKHjQVmHNLsq%2Ft0M%3D) Datasources: Details: Import Metadata The **Import All** toggle in the **Metadata** section of details overrides the filters setup in [Administer > Advanced > Applications](/v1/docs/applications) to import all tables and fields. > [!NOTE] > Note > > Should the **Import All** toggle be inactive and there are no tables assigned to the Datasource within Applications, a message shows that no metadata is imported for this situation. To schedule a repeated refresh, run the refresh and then setup as a **Scheduled Job** within **Job Queues**.Refer to section [Monitor > Job Queues](/v1/docs/job-queues) for details of this process. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/b1dc0c7a-38cf-40dc-b190-43a493943939.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=fdPXIMIaigYkwzSzWz1zOVg%2F8GFiOMsFRQAgt3fvCWQ%3D) The user selects **Import Metadata** to initiate the import. A warning message displays. Click the **OK** button within the Deploy window to continue. The message "**Import metadata job has been successfully added to job queue**" displays once set. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/d5083d01-7ad9-4dfa-8b4e-033bb5d84bb0.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=GBsSHs%2FQoZ%2F22t0YXOFlF4RwUDYTxIG%2BBXL8L4ns2Uo%3D) Datasource: Import Metadata: Warning message When a user attempts to import the metadata of a datasource, the system may prompt them to confirm the action as shown below. This can happen both as part of the datasource wizard, and also when they click the "Import Metadata" option on the datasource form's ellipsis menu. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/2310d6eb-553f-44f6-868b-9126ba9a99f0.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=bVY5MdmTzPKo83X0KnOiFzv9txFlmoULTpjqNG6j1oY%3D) Datasource: Import Metadata: Warning message ## Import Metadata Job Queue If the Datasource has a valid connection setup, the system executes an update to save a new Job for the import of this Datasource based upon the options selected within the metadata section as shown below.To view details of the job, use pathway [Monitor > Job Queues.](/v1/docs/job-queues) The details of the Import datasource job and Status should be available to view within the Job Queue page. If there are errors, fix the connection and try again. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/a3c20e80-51c8-4487-947a-a5455703be45.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=Fp4HgZCQtvlu6SZO8MEBpH0RVZyg62EEHaDm2uyFTOw%3D) Administer: Job Queue: Import Datasource metadata Once the job is In Process, the tables as they are building are added to the details for Table. Click the **Debug ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/d187ecf9-03b3-4042-a095-4b3e3c6cd490.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=3E1RP3Td%2BmLo5p7gmYudUqbb80ZpktaJfTTeQUPFnHc%3D)**icon within panel Steps to view the table details as shown below. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/a5e6fc92-d712-4569-8708-91175358f6ce.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=%2FGBYgd%2BKINWO24gy232dtX%2B0kNGvaC3f9hck2wkmQk8%3D) Administer: Debug Log: Import Table Details Job Queue details for Import Metadata is a vertical split page with two panels of data - Tables on the left side and Columns or Constraints tabs on the right side. The Tables panel provides the list of all tables that were included in the Metadata import effort. If the **Refresh ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ae24b599-6ea9-44c3-8048-ccdbb5b40a32.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=guS4Nl4eFhy1eND0U74uCQWzeQNz9aOwI0LFJLuTI8E%3D)** icon is active, then the Datasource may be imported again using this button. Refer to section [Monitor > Job Queues](/v1/docs/job-queues) for section titled Importing Table Data to a Datasource for more details of this process. If the Datasource contains an Invalid Connection, then the process fails immediately with a message as shown below: ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/edb433b7-3ea4-41cf-88d7-801d0da5bc72.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=5%2B5pg0kXd0PCT%2F%2FDmFqccySJIoxqySGHnEUGto6Sis8%3D) Datasource: Import Metadata: Error for Invalid Connection ## Import Metadata at the Table level The user may also refresh one table at a time by clicking the **Edit** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/16353f2e-7189-4d6d-a0f7-59ee8129e8b3.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=R7XG61t7IMUNKshTa%2BteM2dRQ7trtzvuMbUfxRSNwd0%3D) icon to view the Table details as shown below. Click the **Options** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/76a97251-f55b-4f94-817d-67d0a288cd47.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=uUO2GkyblLo15mBHj23%2F2AjsPY07WDqx2lF2b9AMEMY%3D) icon and select **Import Metadata** to initiate the job queue to refresh the table and columns for the selected table. > [!NOTE] > Note > > Should the selection for **Import Metadata** be grayed out, check the details of this table. Most likely the Schema* field is blank as it is not necessary for Import all, but for individual table import, it needs to have a value. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/1bf6d6fd-a9c2-4ebc-9b5c-b6f104ecf804.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=%2Fd9xiZRbkRx%2BoyBHW2BmNcsMquA9teLKdRwvz9rKLaA%3D) Datasources: Edit Table: Import metadata The user clicks **Import metadata** button to initiate the import. A warning message displays. Click the **OK** button within the Deploy window to continue. The message "**Import metadata job has been successfully added to job queue**" displays once set. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/5e737a6c-698b-4843-bdb0-d8fc982cbdea.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=ac40fHrzlhG9PVZ7ET9QVU6jap2y9UxXJvXDmPoqy80%3D) Datasource: Import metadata: Warning message The system execute an update to save a new Job for the import of this Table. The details of the Import table job and status should be available to view within the Job Queue page. If an error occurs, validate the connection and try again. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/9b4da705-73ba-4b5a-9219-c3b507c49a97.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=8LNch644P8fvSwRAwn76vb%2B%2FGYAm26axtCGSfGaZzNY%3D) Administer: Job Queue: Import Table metadata Once In Process, the table data stores within the panel for Steps. Click the **Debug** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/d187ecf9-03b3-4042-a095-4b3e3c6cd490.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=3E1RP3Td%2BmLo5p7gmYudUqbb80ZpktaJfTTeQUPFnHc%3D) icon to view the table details. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/70020877-4195-4c83-8487-fd49e3df0a26.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=B705Bu1dWw6gSrNmOBAIcMLnaGBEukeoBXY3FYZRcUA%3D) Administer: Debug Log: Table Details ### Import Metadata Response to Added Columns in a Table Should a column be added manually to a System Datasource table for use in Mapping (Refer to [Catalog > Datasources > Adding & Editing Datasources > Adding & Editing Tables or Columns](/v1/docs/adding-editing-tables-or-columns) for details of adding new columns to existing tables in a System Datasource) the Import of Metadata may require updates made to the added field. In the process of importing the metadata for a table, Syniti Migrate checks that the fields of that table match exactly - same count and same names. Should there be an added field in the target table for System Datasource that does not exist within the Target system, Syniti Migrate updates to mark that field as Deleted and a comment is added to the Comments field as well. In the example below, the field zADDMANUAL exists in the target table with the Syniti Migrate Database, but not within the actual system datasource table. To prevent the process from failing, this field is set as **Do Not Import** and the system ignores the field in the XML Build for the Dataflow. The tables show the field, but there is no import of data for that field. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/a4e55f40-10fd-4fce-8794-ce05a6a31530.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A01Z&se=2026-11-17T20%3A15%3A01Z&sr=b&sp=r&sig=dgOxAtLhiA%2Buy1UANSmoolV0dVfu9yYiL47EXUpE%2FT4%3D) Systems Datasource Table: Added Column Marked as Do Not Import