Parameters

Use this page to Set Parameters for Other Components

This page has the following tabs:

To access this page:

  1. Select dspMigrate in the Navigation pane, or select Console in the Context bar.
  2. Select Advanced Configuration > Parameters in the Navigation pane.

General tab

Field

Description

Application Information

Application Name

Displays the name of the component, Console.

Version

Displays current version of Console.

Date

Displays date when this version of Console Was released.

Common Options

Migration Source Database Filter

Displays the filter Console uses when displaying options in the SOURCE ID list box on the Source page’s Horizontal View and Vertical Views. This filter selects the Source data source as a database that begins with sdb.

Migration Object Database Filter

Displays the filter Console uses when displaying options in the DATASOURCE ID list box on the Process Area: Object page’s Horizontal View. The default value is dsw% used by Transform databases.

Email From

Displays the email address from which dspMigrate™ Advanced Data Migration (ADM) will send workflow emails.

 Map tab

NOTE: Fields on this page that are not described in the table below are not used in the product.

Field

Description

Field Options

Key Prefix

Displays the prefix added to a Source key field during the Transform automation process. These key fields are used to track legacy Source keys during the migration process to the new key value (often generated by the new ERP system). The default is zLegacy.

Xref Prefix

Displays the prefix added to a cross reference field during the Transform automation process. When using a cross reference rule (on the Field Mappings page in Map by selecting Xref or RuleXref in the ACTION list box) that requires additional or multiple rules to determine a value, Map creates a zField and a zLegacy field on the source table used in Transform. The zLegacy is used to complete client data conversions and the zField is used to complete the value mapping Source to Target check table values. The default is zLegacy.

Xref Source Field Default Status

Displays the default value mapping status for a cross reference Source field for value mapping. When the a field mapping’s Action is set to Xref , the Source field on the Value Mapping page will default to this selection

Auto Set Not Used For Multiple Sources

Displays the option that controls how Map updates the ACTION column for Add Row and Update Row source mappings when the action has not been set (i.e., the ACTION column is blank). The ACTION column displays on the Field Mappings page in Map.

Options include:

  • None - The values in the ACTION column for the Add Row and Update Row Sources are not changed in other Sources.
  • Primary and Secondary Source - When a mapping is saved in a Add Row and Update Row Source, Map updates the ACTION column for actions that are not set with NotUsed.
  • Secondary Source only - When a mapping is saved for an Update Row, the ACTION column for all other Update Row source mappings is set to NotUsed. In this case, if the Add Row source does not have an ACTION set, Map does not update that mapping. The Add Row source’s action remains unchanged.

Auto Load Mapping History

If checked, when mapping is deleted and added back the mapping is automatically restored to the latest mapping from history.

NOTE: Enabling this option can affect performance and add overhead to the sync process.

If unchecked, when mapping is deleted and added back, the user must use the Restore option on the Field Mapping History page to restore the mapping. Refer to Restore Current Field Mapping From History for more information.

Build Xref Target Rules

If unchecked, Map builds cross reference rules at the source level for those field mappings with an action of Xref or RuleXref.

If checked, Map builds cross reference rules at the target level for those field mappings with an action of Xref or RuleXref.  By default, the check box is unchecked.

Build Remediation Rule Reports

If checked, Map builds Transform Remediation Rule reports to display data audit updates during the Transform Automation process.

NOTE: Enabling this feature may affect performance.

If unchecked, Map generates the remediation rule value to process, but does not build the new view to generate the remediation report.

Reset Field Mapping

Displays the action taken when a user clicks the Reset icon for a field mapping on the Field Mappings page n Map or the Automation SQL Field Mappings page in SQL AutoGen.

Options are:

  • Reset all Field Mapping Fields – All fields are cleared of values

NOTE: If the mapping is associated with a field group other than the default field group (* or “All”), the Target Relationship ID field is not updated on a reset.

  • Reset Status Fields only – All fields retain values except for the Mapping Status and Rule Status, which are set to Pending Review.

Reset Value Mapping

Displays the action to take on value mappings for field mappings using the Xref or RuleXref action when the field mappings are reset.

Reset Transform Rule

Displays the action to take on Transform rules for field mappings using Copy, Default, Rule, Xref or RuleXref action when the field mappings are reset.

Metric Options

Metric Daily Retention

Displays the number of days metrics are saved. The default value is 35.

This daily summary is used to build the Snap Shot metrics.

Metric Summary Retention

Displays the number of days metric summary data is saved. The default value is 180.

Rule Options

Source Delete Rule Priority

Displays the priority Map assigns to a Source delete rule when the rule is created. The default value is 19999.

Source Insert Rule Priority

Displays the priority Map assigns to a Source insert rule when the rule is created. The default Value is 20000.

Source Priority Multiplier

Displays the number used to multiply against the field’s priority on the Target Fields page in Map and the result is the Priority for the Rule in Transform. Source rules will be registered in Transform using this priority, leaving gaps in the priority numbers to be used for manual rules. For example, if the field MEINS is priority 20, and the Source Priority Multiplier is set to 10, then Map would set the Source rule priority to 200 in Transform. The default value is 10.

NOTE: Once a Source rule for a field is registered in Transform, Map will not adjust the priority.

Target Priority Multiplier

Displays the number used to multiply against the field’s priority on the Target Fields page in Map and the result is the Priority for the Rule in Transform. Target rules will be registered in Transform using this priority, leaving gaps in the priority numbers to be used for manual rules. For example, if the field MEINS is priority 20, and the Source Priority Multiplier is set to 10, then Map would set the Target rule priority to 200 in Transform, The default value is 10.

NOTE: Once a Target rule for a field is registered in Transform, Map will not adjust the priority.

Target Report Priority Multiplier

Displays the number used to multiply against the field’s priority on the Target Fields page in Map and the result is the Priority for the Rule in Transform. Target reports will be built and registered in Transform using this priority, leaving gaps in the priority numbers to be used for target reports created manually. For example, if a report is priority 20 and the Target Report Priority Multiplier is set to 10, then Map would set the target priority to 200 in Transform. The default value is 10.

NOTE: Once a Target report is registered in Transform, Map will not adjust the priority.

Target Report Remediation Priority Multiplier

Displays the number used to multiply against the field’s priority on the Target Fields page in Map and the result is the Priority for the Rule in Transform. Target reports with remediation will be built and registered in Transform using this priority, leaving gaps in the priority numbers to be used for Target reports with remediation created manually. For example, if a report is priority 20, and the Target Report Remediation Priority Multiplier is set to 10, then Map would set the Target report with remediation priority to 200 in Transform. The default value is 10.

NOTE: Once a Target report with remediation is registered in Transform, Map will not adjust the priority.

Transform tab

 

Field

Description

Directory Paths

Source Path

Displays the path for the Source directory where Source files (generally package files) that can be imported into Transform are stored.

Report Path

Displays the path where Transform will create report files. All files are generated to the path:

C:\DSW\Report\<Wave Name>-<Process Area>\<Target Name>

For example, if Transform were generating reports for the target ttMARA in the SouthAmerica Wave, MM Process Area, the reports would be written to:

C:\DSW\Report\SouthAmerica-MM\ttMARA

Export Path

Displays the path where Transform will create export files. All files are generated to the path:

C:\DSW\Export\<Wave Name>-<Process Area>\<Target Name>

For example, if Transform were generating an export file for the target ttMARA in the SouthAmerica Wave, MM Process Area, the file  would be written to:

C:\DSW\Export\SouthAmerica-MM\ttMARA

Package Path

Displays the path Transform will look in for package files.

Documentation Path

Displays the path where Transform will create documentation files.

Other

Temp Database Name

Displays the name of the temporary database used by Transform.

Audit Reports

If checked, Transform generates audit statistics during processing.

Run Remediation Rules

If checked, Transform runs remediation rules. This field should not be checked for production loads.

Report File Generation Mode ID

Displays the mode for file system generation.

Values are:

  • Automatic – Both file system files and Report Cache are created.
  • Custom – Only file systems file are created
  • On Demand – Neither file system files nor Report Cache created.

The counts (i.e., the number of rows returned) on Target/Source/Remediation/Audit Report pages are updated.

If the Report File Generation Mode ID is none, the Report Generation Mode ID is Custom.

NOTE: Report Cache are only created if Publish is enabled.

File system files, sample and segment reports are created in a path on the application server using folder names based on the Object, Target, and Source names used in the report. The path displays in the Report Path field.

The Report Cache is created in the Report Cache Data Source ID for My Reports

When a user clicks the Access Report icon on the My Reports pages a file is written to the file system (note that same location as the file system file above).

Source Active On Build

If checked, Target Sources are auto-generated with a default status of active in Transform. If unchecked, target sources are auto-generated with a default status of inactive in Transform.

Filters

Prefix Delimiter

Displays the delimiter used to separate filter prefixes when more than one filter is defined.

Procedure Filter

Displays the prefix used to filter Transform procedures.

Target Table Filter

Displays the prefix used to filter Target tables.

Target Rule Filter

Displays the prefix used to filter Target rules.

Target Report Filter

Displays the prefix used to filter Target reports.

Target Export Filter

Displays the prefix used to filter Target exports.

Source Table Filter

Displays the prefix used to filter Source tables.

Source Rule Filter

Displays the prefix used to filter Source rules.

Source Report Filter

Displays the prefix used to filter Source reports.

Import Table Filter

Displays the prefix used to filter import tables.

Report Settings

Default Report Format

Displays whether column headings in reports will include field names, a translation of the field names, or both. Field names in a Target system are often abbreviated or, in the case of SAP, are abbreviated in German.

Replacement Char

Displays a character to replace the following invalid characters: ? | : * ? “ < > in reports. The default value is ^.

Report Cache Data Source ID

Displays the name of the database that contains the tables storing the results of report views.

NOTE: REPORT CACHE DATA SOURCE ID is required for the execution of the Business Data Transformation and Report Delivery via Transform.

Report Header

Displays the header that will appear on all reports as defined on the Report Headers/Footers (Setup) page, accessible from Navigation pane in Transform by selecting Configuration > Setup.

Report Footer

Displays the footer that will appear on all reports as defined on the Report Headers/Footers (Setup) page, accessible from Navigation pane in Transform by selecting Configuration > Setup.

Report Landscape

If checked, the report is printed in landscape format. If unchecked, the report is printed in portrait format.

Report Generate Empty

If enabled, Transform will generate reports in the Report Path (set in the Report Path field on this page) even when there are no records on the report. If disabled, Transform will only generate a report if the report contains data.

Report No Rec Count

If checked, reports will not contain a record count. If unchecked, the record count is included on all reports.

Segment Signal Dir

If checked, Transform outputs Segment By reports to a single directory with the SegmentBy value appended to the report file name. If unchecked, Transform creates one directory per SegmentBy value.

Text Format Value

Displays the format for text in reports, either text format or x125.

Add IMEX

If checked, IMEX=1 is automatically added to Excel file connections, which instructs CranPort or SSIS packages to read intermixed columns (columns containing a mix of text and numbers) as text columns.

Generate Documentation

If checked, Transform creates technical documentation files.

Transform generates and saves versions of the Technical, Audit and Recon documents as HTML files every time an object, target or Target Source is processed.

Refer to Generate Documentation for Objects, Targets, and Target Sources for more information.

Report Max Rows

Displays the maximum number of rows to be generated into an Excel file. If the data contains more than the number of rows indicated by this field, a delimited file is generated instead.

Report Max Support Rows

Displays the maximum number of records that can be generated into a file (Excel or delimited).

Report Column Delimiter

Displays the delimiter used to separate the report data into columns in the report when the file is generated.

Report Column Qualifier

Displays the qualifier used to delineate column data containing spaces or special characters.

Package Properties

Import Suffix

Displays the import suffix for CranPort or SSIS packages.

Export Suffix

Displays the export suffix for CranPort or SSIS packages.

Source Connection

Displays Connection 1 for import CranPort or SSIS packages and Connection 2 for export CranPort or SSIS packages.

Destination Connection

Displays Connection 1 for export CranPort or SSIS packages and Connection 2 for import CranPort or SSIS packages.

Temporary Prefix

Displays the prefix used for temporary CranPort or SSIS packages.

Destroy Temp Package

If checked, Transform destroys any temporary CranPort or SSIS packages generated during report file creation. If disabled, the temporary packages are saved on the web server for review.

 

Construct tab

Field Description
Client Client value used in views for filtering.

 

Compare Settings tab

NOTE: This tab is only accessible if the current user is a member of the WebApp group Wavesynchronizer in Console or is assigned to a security role with access to the page. Refer to Set Security in System Administration for more information.