--- title: "Snapshot Datasource Build Import XML" slug: "snapshot-datasource-build-import-xml" updated: 2026-08-05T13:52:03Z published: 2026-08-05T13:52:03Z canonical: "skthelp.syniti.com/snapshot-datasource-build-import-xml" --- > ## 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. # Snapshot Datasource Build Import XML > [!NOTE] > Note > > The SAP Data Services ETL Tool is deprecated. It is recommended to use **Syniti Migrate** as the preferred ETL tool going forward. While the SAP Data Services integration and documentation is retained for the existing implementations, new implementations should use Syniti Migrate for all ETL-related processes. ## Overview This process builds out the tables in the database for the Datasource with the Snapshot datasource purpose (Target Datastore) as well as building the XML Scripting for the Project for Importing data from System Datasource to Target Datastore. This process is relevant when ETL tool = **SAP Data Services**. This process is not necessary if the ETL Tool is Syniti Migrate. > [!NOTE] > Note > > Since the Datasources are not Release specific, the setting for ETL is taken from the Parameters page. ## Prerequisites to Running the Build Import XML - Prior to running this Build XML process, make sure to have already attached a Source Datasource from which the table rows of data are pulled. The Source Datasource may be a source system or target system, and the data is pulled into the Snapshot Datasource tables (either SRC or TGT prefix) in the Snapshot database based upon this setup. The tables for import of data need to be marked as active and contain the metadata for Columns and other formatting so that the data builds properly in the XML Scripting. - The System Datasource must have a value in field XML Datastore prior to running the Build Import XML process. If there is no Datastore value, this build fails. - If within **Parameters** page the ETL Tool = **SAP Data Services**, the Build and View XML processes is active. If however, the ETL Tool = Syniti Migrate, then this article is not relevant. Migration ETL Jobs Tool does not use XML Scripting. > [!NOTE] > Note > > The field XML Datastore within the Snapshot Datasource must contain a value in order for the XML scripting to build properly - if this field is left blank a check during the Build Import XML produces an error message for missing XML Datastore value. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Snapshot Datasource BUILD_1.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A09Z&se=2026-11-17T20%3A22%3A09Z&sr=b&sp=r&sig=rxAm%2BCCv3tLRWN6l8u7Ra0G7QS2d6xyfHQkRxsDuUbY%3D) Snapshot Datasource: Details: XML section ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Snapshot Datasource BUILD_2.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A09Z&se=2026-11-17T20%3A22%3A09Z&sr=b&sp=r&sig=rg8%2FYq96OeRDInkTwRvU2iTEZ%2BXkzaq6RCN61by5xR0%3D) Snapshot Datasource: Build Import XML: Debug Log: Exception for missing Datastore ### Column Do Not Import Toggle This toggle was previously used to exclude columns from the XML Import build scripting for the ETL. The fields remain included in the SQL scripting for the table builds in the database system. This functionality has been replaced by the Field Mappings feature in the Replications panel. Refer to [Performing Field Mappings](/v1/docs/performing-field-mappings) for more information. To exclude columns: 1. In the Replications panel, access the required replication and select **Field Mappings** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image-B7C20AWD.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A09Z&se=2026-11-17T20%3A22%3A09Z&sr=b&sp=r&sig=yMwDqSkTch063oPCd2bxMa7Z88evo5d7paL7MX4EpIw%3D) **> Map Explicit** mapping rule. 2. Deselect the columns that are no longer required and click **Save**. ## Build Import XML While viewing the Snapshot Datasource Details stored within Application Syniti Migration, click **BUILD IMPORT XML** button to build the XML code. The Snapshot Datasource is attached within section Source Datasources to one or more source systems. The tables used for Datasets and Mapping is active within both the source Datasource as well as the Snapshot Datasource as this indicates that they are promoted in the XML scripting for import to the ETL and DDL builds within the Database. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Snapshot Datasource BUILD_5.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A09Z&se=2026-11-17T20%3A22%3A09Z&sr=b&sp=r&sig=8z2XBHCJiQZw%2F8VZhfzeY7vh%2FgD9FEpr6GVSwpvHY4E%3D) Datasource: DS XML tab This action builds the XML code that can be downloaded and imported to the ETL Data Services to accelerate the migration process. The Job Queue produces 2 jobs - one to create the XML file loads and DDL Scripting as one step, and one to build the tables within the database as a step for each table with status of completion. A window displays to indicate that "Job Queue has been initiated successfully". > [!NOTE] > Note > > Should the Snapshot Datasource be an SAP system, the Build XML process fails if the **SAP Client** is not defined within the Source Datasource. See the error shown in DEBUG LOG for Building XML below: > > ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Snapshot Datasource BUILD_6.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A09Z&se=2026-11-17T20%3A22%3A09Z&sr=b&sp=r&sig=qdVHMs4B5nBj%2FVXmz7Y%2BlU6AJThhd92GfSoJtQgKNLM%3D) > > DEBUG LOG: Build XML for Snapshot Datasource: Error Message An error message displays. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Snapshot Datasource BUILD_6B.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A09Z&se=2026-11-17T20%3A22%3A09Z&sr=b&sp=r&sig=E1EG1ZVV%2B9ArbrYhmDuiXNtd7sfUXMlc%2Bu3ZxOQfkh0%3D) If the job does not have issues, it may take some time to complete. Review the status of this build by a click on pathway [Administer > Job Queues](/v1/docs/job-queues) ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Snapshot Datasource BUILD_7.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A09Z&se=2026-11-17T20%3A22%3A09Z&sr=b&sp=r&sig=1e8Tld2hPrTfGeceiFCW23FaX7QM1UtnyOrjkFOgeEo%3D) Administer: Job Queues: Build Import XML for... ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Snapshot Datasource BUILD_8.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A09Z&se=2026-11-17T20%3A22%3A09Z&sr=b&sp=r&sig=TBp2%2FMwGzQsofqCccjQk6Yusyki31DUoSwbPGpDLm7s%3D) Administer: Job Queues: Import Build XML: Table builds The user may view the Debug Log entries associated with each step by clicking on the Debug Log ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/3829634e-2657-41f8-8c70-6fb58bf71ed1.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A09Z&se=2026-11-17T20%3A22%3A09Z&sr=b&sp=r&sig=GPDmTAHMTRYjRHZzDq%2B2JmMGKtnykEEfBwvv3%2BFKcI8%3D) icon. In the case above, the tables are already created within the Snapshot database, and so they ERROR as they do not build again. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Snapshot Datasource BUILD_9.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A09Z&se=2026-11-17T20%3A22%3A09Z&sr=b&sp=r&sig=ywB48JW1KLPd7r5d0nthHNxjNc0gPQ4cFISjE0AV588%3D) Administer: Debug Log ## Format for DATE fields and SAP Default Date (00000000) Date fields translate in a format of MM/DD/YYYY as example '01/01/1900'. Additional scripting is added to each DATE field to include a filter that updates for the SAP Default date (00000000) to '01/01/1900.' See the example highlighted below - ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Snapshot Datasource BUILD_10.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A09Z&se=2026-11-17T20%3A22%3A09Z&sr=b&sp=r&sig=%2Fjp%2Fb2ie5OL3TfpITtqVQXJtc252WDeefb311jJzQrI%3D) Snapshot Datasource: View XML: Target System SAP Table scripting: Format and Filter for DATE fields ## Related Articles - [Snapshot Management Workspace](/v1/docs/snapshot-management-workspace) - [Edit Snapshot Tables and Columns](/v1/docs/edit-snapshot-tables-or-columns) - [Snapshot Datasource View Import XML](/v1/docs/snapshot-datasource-view-import-xml)