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.

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:

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.

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

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.