--- title: "SAP Data Services for Syniti Migrate " slug: "sap-data-services-for-syniti-migrate" status: "update" updated: 2026-08-05T14:39:22Z published: 2026-08-05T14:39:22Z canonical: "skthelp.syniti.com/sap-data-services-for-syniti-migrate" --- > ## 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. # SAP Data Services for Syniti Migrate This topic contains the following sections: - [Preparation of XML in Migrate](/v1/docs/preparation-of-xml-in-migrate) - [Importing XML Code Into Data Services](/v1/docs/importing-xml-into-data-services) - [Post Import Maintenance of Project](/v1/docs/post-import-maintenance-of-project) - [Mapping Standards](/v1/docs/mapping-standards) - [Export Building and Execution](/v1/docs/exports) - [Report Building and Execution](/v1/docs/reports) - [Cross Reference Building and Execution](/v1/docs/cross-reference) ## About This Guide > [!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. This guide will provide details for the import of XML scripting build to SAP DataServices and instruct the user with tips for best practice and management of the Object conversion and loading to the target system. This guide is not intended to instruct on the installation, setup, security, or user access for SAP DataServices except where there is interaction with Syniti Migrate. ## Prerequisites for Using Data Services As part of the setup and connection from Syniti Migrate module to the (in this case SAP systems), there are a few steps that must be performed to ensure that the systems can communicate efficiently and successfully. The IT Lead or Project Manager will organize this setup and will be responsible for successful connection of the systems. The following sections will provide details of steps that have become part of the routine for setup and use of SAP Data Services as the ETL for Syniti Migrate. ## Building Datastores in Data Services Although the XML Scripting that generates for the Import of data to Datasources or the Migration Project is very robust and provides much of the hierarchy in terms of Workflows, Dataflows, and Queries, it cannot build the Datastores. This is a manual task that is performed by either an IT Lead or the Developers depending upon the security setup and roles on the project. Datastores must be created manually within SAP Data Services Datastore section before the XML files are imported to Data Services system. They must be setup to connect to the system from which they will tie for table data, and they must be tested. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(124).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=vVoYClcMKYjKlI%2FDAYzqIhpfSHGTWaRlDSEsHjfTwZw%3D) Datastore: Edit: Target Datasource ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(125).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=bnUYdcVCXXrm1FJ4w9JrKJ%2FY1cc%2FH0%2BVf5k6x%2FuOp3U%3D) Datastore: Edit: Source Datasource In addition to building the Datastores for System Datasources, Target Datasources, and Source Datasources, Datastores are required for xAppMigrate, xAppReport, and xAppMigrate_Webservice. These Datastores assist in connection to Syniti Migrate for updating tables, storing the report output, and for WebServices functions for use in building the WADL reports. ### xAppMigrate Datastore The xAppMigrate Datastore will connect to the Migration Working Server for the purpose of updating values in tables **XTVALUEMAP** and **LIST_TARGET_VALUE** for the Xref data conversion. This Datastore will point to the MIGRATE database within the Migration Working Server. Every dataset will reference the tables contained in this datastore and so it too must be present prior to importing XML for Datasets or Sources. The actual tables will be created as part of the Import of XML for Dataset ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(126).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=tCEds1kJ1t%2FpWx8MGRwAMTqeDUVYpeCEOrkz5TmJ99M%3D) ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(127).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=Fvc6aBMp20MY7WqEpDrkUEZvvL9W5J6zP1Z0d19tsiU%3D) Datastore: xAppMigrate ### xAppMigrate_WebService Datastore The xAppMigrate_WebService datastore will store the functions used within WADL reporting. This datastore is created as Datastore Type = Web Service REST as shown below. As the XML scripting imports for the migration project, these functions will also import to load to this Datastore. > [!NOTE] > Note > > The URL is stored within the notes of the Transform job in the XML script. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(128).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=jqoUxdwqJPrxjN8ep%2BITtvfu052tSuYuj1elR9e0zbE%3D) Datastore: xAppMigrate_WebService The import for this Web Service REST is slightly different than for the others. The user will open the pathway for this datastore to view the Functions that are attached. For each of these functions, highlight and then right click to open the options and click on Import. This will import the data. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/3b455c4b-0cea-4b97-a59c-86b51a23b501.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=uXBNfMvl5Ty2Rv8k1xcZ9xQf7aiqBytlIPsrUZmaSDo%3D) Only after these functions are imported will they be present in the Datastore as shown below. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(129).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=BK2HCUfl3jjYkYxQvrmKE%2BsC56LNWn4AQ6dBBT2J42Y%3D) Within the query for CallWebService, there will be functions for the xAppMigrate_WebService function category. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(130).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=3cU731nrmjllNNw5rzRVGeT%2BIJmkMlbcfqpecbH0MsI%3D) ## DS Repository Setting for Case Sensitive ODBC Datastore Owners and Table Names As part of the overall setup of Data Services for use with Syniti Migrate, the IT Lead will need to add a row of code to the file as a DS Repository setting. This is linked to DS Repository setting. Attached SAP note with details. **Cause** Data Services automatically converts the ODBC Datastore owner and table names to all uppercase characters when importing table metadata. **Resolution** To override this behavior, follow these steps before you create the ODBC Datastore: 1. On the Designer workstation open DSConfig.txt located: %DS_COMMON_DIR%\conf (%LINK_DIR\bin in older versions) 2. Go to the [AL_Engine] section of the file and the manually add the following parameter: ODBCAlwaysCaseSensitive=TRUE 3. Stop and restart the SAP Data Services service via Windows Services in order to implement the change. 4. Create (or recreate) the ODBC datastore and import the table(s) ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(131).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=2qmj6OcmCzrKh%2FSb3ODFCnato9TdsUtmAyp7xLy6KZ8%3D) ## WADL SSL Certificate Setup in Data Services WADL report refresh error is providing an SSL certificate error ### Background Information User was having trouble with installation of WADL-based report refreshes - User could not import functions to the Datastore due to a certificate failure, however when trying to hit the link both locally and on the server, they did not get certificate warnings. In a normal situation without issues, the User could open the datastore for xAppMigrate_WebService as shown below to import the Metadata for all 6 functions. This Datastore is setup as Type = Web Service REST and it stores functions that are used to run the reporting for remediation, validation, and refresh. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(132).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=wYKJfhHNVVCLz4PVeJbC%2B9E4JR2bYYM1KUL1dxDSNco%3D) Datastore: Web Service Rest When they would try to import the XML Scripting for these functions, it would produce errors as shown below: ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(133).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=CXfpUiApQz4JYCQDiQ5E8iFnNh3h8hs4Q67s%2FKzQ1yc%3D) Datastore: xAppMigrate_WebService: Error message Per the Note within the imported XML scripting, the web address is listed as: ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(134).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=Z%2BknTJCf7IoSkcSP71X%2B6KlJGCHRuobmIES0tLhv3jw%3D) ### SAP Solution SAP Support provided this solution and when applied it resolved the issue. The error message below is generated due to this issue. The 2 specific SAP Notes reference a tie back: https://launchpad.support.sap.com/#/notes/2338044 - BODI-1111469 https://launchpad.support.sap.com/#/notes/2841300 - BODI-1112446 Also, the SAP Portal provides this Note as a resolve, but the system is running a newer version of Data Services than within this note: ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(135).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=wZxdTfMLNhG9fpfngdcU%2F1CGeu4G62vk%2B79aASC4Wj8%3D) Steps for Resolve of this Issue **STEP 1** - The Browser response to the error while using Chrome shows the following: ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(136).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=Ga0lor4JsCfwfKVhqBEQgSHcWydPKH%2FEJIYm7tP6HUY%3D) **STEP 2** - From Chrome, click **F12** key to go to the Security Tab and then click **View Certificate** button. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(137).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=ZK1IN4JaIAo9EQ6lVpdDoBLJ%2BV4mwwfaLXqtoBL%2FqQE%3D) **STEP 3** - The certificate is displayed. Click tab for **Certification Path.** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(138).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=52LAN0a4hwb26UNNtkvdnN4ULU%2FmZxmX%2BK%2BeRfF1r%2BY%3D) Certificate **STEP 4** - Click the **View Certificate** button. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(139).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=lbOGgGAZ6%2FGJykyYPBN7%2BHAhvuCwkoLfZ%2BS%2Bru26hL0%3D) Certificate: Certification Path **STEP 5** - Click **Details** tab. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(140).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=sXXtXgy%2Bb54s4xOr9XT7qBlB9yIFgdfFPjZFXDDEXMs%3D) **STEP 6** - Click **Copy to File...** button to start the Export Wizard for the certificate. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(141).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=3o0MrN1q8a5PMq73rJ8eaDCV5gCU9Nnho311xPXIeJ0%3D) **STEP 7** - Follow the wizard steps - Click Next ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(142).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=M8oOwscF%2FWDL5EfDEYsJRHytZ18lWEwe1UHFQlHB4MA%3D) Certificate Export Wizard **STEP 8** - Select **Base-64 encoded x.509 (.CER)** as the format to use and then click **Next.** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(143).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=frlOjah809bKuPs0UNhVR0nBedWSNhv91pUYK0HV4Dc%3D) **STEP 9** - Save Top Layer as ***filename***_1.CER (please note all saved files are in this image including the next few steps) Click Save button. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(144).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=cuGgye86z6Lsb63Q1Wx9KqvFbNtwnnZGdySGdS3CGBw%3D) File Save **STEP 10** - The Wizard will return on page. Click **Next** button to proceed. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(145).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=eedr8sCrUUrDARZeurVLV3mVC1B9nzRQFXWZOwmf%2Bjg%3D) File pathway **STEP 11** - The Certificate should have exported successfully - Click **Finish** button and then click **OK** to complete this process. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(146).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=POCFYqt98md9SCzB2qWQRF8PgYPPyXOaoaRJscoIR4M%3D) Certificate Export Wizard: Completing **STEP 12** - Select the next tree Layer, click **View Certificate** button and then **REPEAT STEPS 5 through 11** for the second level. Make sure to name the File as ***FileName***_2.CER for the second Layer Once the export is successful, move to the next level and repeat until all levels have the Certificates exported. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(147).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=ehUqqOs%2B2ms9Kakf6TD2bDhANKo%2FMX%2BrTsaDbVJ0D6w%3D) **STEP 13** - Combine all of the Certificate export files into a single file and name it ***Filename*.CER** Do this by using Notepad - Copy all contents into a single file, appending ALL CONTENTS as shown below. Each certificate will have ----- BEGIN CERTIFICATE ----- and ------ END CERTIFICATE ----- to identify and separate. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(148).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=X1pu5QgEuYlkDkXqnFM%2F87LsAS%2FW72D4HrmUAwru5Ys%3D) Notepad: All Certificate files merged together **STEP 14** - Data Services References Now that the combined Certificate file is available, save this file in a location that the Job Server can reach. A shared drive is preferred as each person at their local run level will also need to be able to reach this same path. With the file saved on a shared drive, the user can now edit the Datastore for xAppMigrate_WebService - Add SSL Pem File, fully qualified path, and file name: When the user clicks **Apply** button the Error message will no longer be present. Next, click **OK** and continue the process for Import of Metadata for Functions. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(149).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=69aOkRvSr9wyw2fDoIOX%2FTudd6MHk%2FuocqSkHWEIxQ4%3D) Datastore: xAppMigrate_WebService: Edit For each of the 4 Functions, click to highlight and then right click and Import. Refer to section **Building Datastores in Data Services** for details of this process. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(150).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A22%3A25Z&se=2026-11-17T20%3A22%3A25Z&sr=b&sp=r&sig=IKHsFpD0Xo1%2F8r0TOPtJh3Z9C1OZMLYB8LuUqWiQs48%3D) Datastore: Web Service Rest