Parameters
  • 25 Mar 2024
  • 3 Minutes to read
  • Contributors
  • Dark
    Light

Parameters

  • Dark
    Light

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 screen shot below.

null
Parameters: Details for SAP Data Services Tool

The Parameter Details tab displays the following fields:

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. (Required)

Setup

Working Database Type*

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

Setup

Log Retain Days*

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

Setup

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. (Required)

Setup

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. (Required)

Setup

Export Path*

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

SAP Data Services

ETL Tool

Displays as DS. (Display only)

SAP Data Services

DS Repo Version

Displays the Data Services Repo version number.

SAP Data Services

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) (Required)

Methodology

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) (Required)

Methodology

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) (Required)

Job Queue

Low Priority Threads*

Defines how many job queue processes per Low priority to allow to run in parallel. The system defaults values as 3. (Required)

Job Queue

High Priority Threads*

Defines how many job queue processes per Low priority to allow to run in parallel. The system defaults values as 3. (Required)

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. (Required)

Note

Do NOT set this value higher than 1 million.

Report Export

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. (Required)

Note

Do NOT set this value higher than 3.99 million.

Report Export

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)

Release

Build Date

Date that the current release was installed (Display Only)

Release

Commit ID

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

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

null
Parameters: Details for Syniti Migrate Snapshot ETL Tool

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.

null
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