Parameters
  • 21 Jun 2024
  • 4 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Parameters

  • Dark
    Light
  • PDF

Article summary

This topic relates to the following sections:

About Parameters

View the following page by navigating to Administer > Setup > Parameters from the Syniti Migrate Home page or access by using the Guided Setup.

The Parameters page stores the system settings. Details such as the product version, Working DB Type, and Snapshot ETL Tool determine the client specific requirements. Parameters are assigned at the start of a project, and require minimal revisions through the project lifetime. 

Only users with Administer security access may view or change this page. Refer to section Initial Setup First Week for details of the timing and steps where this section is updated.

Edit Parameter Details

The Parameter page provides sections for the setup, methodology, job queue details, and SAP Data Services details. The SAP Data Services section is contingent upon the Snapshot ETL Tool field is SAP Data Services, otherwise it is hidden.

Note

The System Admin or IT Lead defines the parameters as per the specified values in the screenshot below.

Parameters: Details for SAP Data Services Tool

The Parameter Details tab displays the following fields:

Note that the fields marked with the asterisk (*) symbol are required.

Section

Field

Description

Setup

Base URL*

The URL for the application is used for WADL scripts within Data Services. This field is not required if not using DS, however, the WADL scripts fail as it is needed to run reports.

Working Database Type*

Select from the drop-down list the database type for the project. (Ex: HANA, Oracle, or SQL Server)

Log Retain Days*

This field identifies the maximum number of days to retain data for the User Audit Log stored within Migration Security.

Debug Level*

Provides the level to which the Debug Log is filled with entries. Set to None as default and then changed to either Error or Trace when using Debug to prevent the table from overloading the system.

Snapshot ETL Tool*

Snapshot ETL tool used for data migration is defined for system default. This field triggers different back-end logic when generating XML files to be imported into the ETL tool as part of automation. Options are SAP Data Services or Syniti Migrate.

Export Path*

Defines the server location to which physical files are exported when needed.

Create Export Specific Folder

This toggle button allows you to specify whether to include the export folder name in the Export Path that Syniti Migrate passes to Syniti Replicate when generating a Target Export file. By default, this toggle button is turned on.

  • When this toggle button is turned on, the export file path is passed as E:\Exports\LOAD\MM_MARA_T_EXP\.

  • When this toggle button is turned off, the export file path is passed as E:\Exports\LOAD\.

SAP Data Services

ETL Tool

Displays as DS. (Display only)

DS Repo Version

Displays the Data Services Repo version number.

DS Version

Displays the Data Services version number.

Methodology

Field Prefix*

Defines the prefix that is concatenated to the working fields of the source and target tables for use in conversion of data. (Ex:Z)

Key Prefix*

Defines the prefix that is concatenated to the Key fields of the source and target tables for use in conversion of data. (Ex: ZLEGACY)

Xref Prefix*

Defines the prefix that is concatenated to the XREF fields of the source and target tables for use in conversion of data. (Ex: ZXREF)

Job Queue

Low Priority Threads*

Defines how many job queue processes per Low priority to allow to run in parallel. The default value is 3.

High Priority Threads*

Defines how many job queue processes per Low priority to allow to run in parallel. The default value is 3.

Job Queue Retention (Days)*

This field identifies the maximum number of days to retain data for the Job Queues stored in Migrate. You can enter values between 1 and 30.

The default value is 5 days.

Report Export

Excel Export Max Record Count*

This value limits the number of records in an XLSX report to download. Any report exceeding the limit downloads as a CSV.

Note

Do NOT set this value higher than 1 million.

Excel Export Max Cell Count*

This value limits thenumber of cells in an XLSX report download (records multiplied by columns). Any report exceeding the limit downloads as a CSV.

Note

Do NOT set this value higher than 3.99 million.

CSV Export Alternate Leading Zero Format Enabled

Toggle promotes using leading zeros on the report if the file is large enough to export as a csv file. This passes the values as ='00012345' into the file as an example. CSV files do not show leading zeros if this flag is toggled inactive.

Release

Product Version

Current Release of this application as set during installation (Display Only)

Build Date

Date that the current release was installed (Display Only)

Commit ID

The ID for Syniti Dev team to identify exact version and commit of this release

The following image is an example of the Parameters page when the Snapshot ETL Tool is set to Syniti Migrate:

Locate the SAP Data Services Version Values

Note

These SAP Data Services values may be derived by viewing the Help > About Data Services window within Data Services as shown below. These settings are used in the XML Scripting for migration of objects to SAP.

SAP Data Services: About Data Services

When finished with edits, click the Save  icon to complete.

Subsequent Steps

Parameters is part of the initial setup of the Syniti Migrate system. By following the steps of the Guided Setup, the preliminary processes are set in place to start running a successful migration project.


Was this article helpful?

What's Next
ESC

Eddy, a generative AI, facilitating knowledge discovery through conversational intelligence