--- title: "Build xAppMigrate Datastores" slug: "build-xappmigrate-datastores" updated: 2024-03-26T08:00:53Z published: 2024-03-26T08:00:53Z canonical: "skthelp.syniti.com/build-xappmigrate-datastores" --- > ## 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. # Build xAppMigrate Datastores As part of the setup of the Data Services system, the IT Lead builds the Datastores manually. The Datastores discussed in this section are required as part of the Syniti Migrate setup to run the Reporting generate process and the XREF processes. The steps below will build out both the xAppMigrate and xAppMigrate_WebService Datastores. ## Build xAppMigrate as a datastore The user opens the tab for Datastores within the Local Object Library. Click **Project > New > Datastore** to open the Create Datastore window. The new Datastore will be built like the image below. Enter the appropriate values for the client's system. ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/DS_CreateDatastorexAppMigrate_1.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A29%3A59Z&se=2026-11-17T20%3A29%3A59Z&sr=b&sp=r&sig=r7KbpsRA%2BqwfMTvIQf0%2FEU588IRaqczTdLedMBLhO30%3D)Data Services: Datastore: Build xAppMigrate details | Field | Definition | | --- | --- | | Datastore Name | Enter **xAppMigrate** as the name. | | Datastore Type | Enter **Database** as the type. | | Database Type | Enter the database type (EX: SQL Server, Oracle, Netezza) | | Database Version | Enter the version of the database | | Database Server Name | Enter the client's server name for the database | | Database Name | Enter the Migration db name | | User Name | Enter the Migration user name | | Password | Enter the Migration password | Once the data has been updated, click **OK** to save this new Datastore. There are a few Dataflows within any standard migration object that will call out to this Datastore. Examples are shown below: ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Build xAppMigration Datastores_1.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A29%3A59Z&se=2026-11-17T20%3A29%3A59Z&sr=b&sp=r&sig=36Z%2FhkgDTcH%2F2JI5UZBvLYpa3%2FCmzf66V0s%2Bv0IjVnI%3D)Data Services: Project Dataflow for Insert XREF: XTVALUEMAP![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Build xAppMigration Datastores_2.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A29%3A59Z&se=2026-11-17T20%3A29%3A59Z&sr=b&sp=r&sig=TKFokQSSq7xa3C1r9JIorhoL4r0E%2F%2Bl9MqWSKg5bOOs%3D)Data Services: Project Dataflow for Target Ready Reports: COR_REPORT![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Build xAppMigration Datastores_3.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A29%3A59Z&se=2026-11-17T20%3A29%3A59Z&sr=b&sp=r&sig=%2Fr%2BHvM3BJSwyAYw6Y3eVpraxjahQKtE4yk617i9nMrQ%3D)Data Services: Project Dataflow  for Target Ready Updates: COR_INTERFACE These Dataflows within Data Services will import with errors if the Datastore for **xAppMigrate** is not setup prior to import of the XML files. ## Build xAppMigrate_WebService as a datastore This Datastore is a Web Service REST. It will store the URL to run to create as type WADL the Reports. This automated option for projects and all XML scripting will use the WADL process for Report Update and Generate. The information is posted in the 010_Transform Job of the Project in Data Services - WADL reporting requires a webservice datastore named **xAppMigrate_WebService**. 1. Manually create a new datastore Datastore Name: xAppMigrate_WebService Datastore Type: Web Service Rest Web Service URL:https://migrateds.migrate.syniti-dev.com/Services/migrationreport/metadata?version=1&type=wadl 2. Open the new datastore, expand the metadata, expand each function, right-click and choose Import for all 6 functions. The user will open the tab for Datastores within the Local Object Library. The new Datastore will be built as the image below. The Web Service URL can be copied from within the Post It notes in the Project Build - Reporting. Enter the appropriate values and then click **OK** to save. ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Build xAppMigration Datastores_4.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A29%3A59Z&se=2026-11-17T20%3A29%3A59Z&sr=b&sp=r&sig=VOi5B8RYZ9JEBq720UaUeVwHN78dZ6zjb5EEAOrAN3k%3D)Data Services: Datastore: Build xAppMigrate_WebService details The Functions imported in the project will need to be manually imported as well. Highlight the Datastore and then double-click on the line to open the details. click to open to show the details for each function. Right click and select Import to import in the actual function scripting (displays in left side panel) that will be used in the query for Reporting generate in the project. > [!NOTE] > Note > > Each time the project is imported, it will produce a new file with extension (EX: _1, _2), so the Queries will need to be updated to match the active functions within **xAppMigrate_WebService** to the functions within the query. ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Build xAppMigration Datastores_5.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A29%3A59Z&se=2026-11-17T20%3A29%3A59Z&sr=b&sp=r&sig=ba4sGB8XlSjqm6KTAyxqjJ1D5XfcXWOQoAx1cpSmZAY%3D)Data Services: Datastore: Import the Functions to the Datastore