Glossary
A
Add Row Source
A table in the source database that contains source object data that is moved to a target table. A source’s system type determines the database schema, or table definitions, for the source. Add an Add Row source if another source database object is needed from the same system for the same target table. For example, the same source system has two tables for customers, one table contains SoldTos and another contains ShipTos. Both these tables are in the same system and need to be migrated to the target table ttKNA1.
After Post Rule
A rule (a business rule, collect download or status view), registered to a process template in Integrate, that runs after the process template executes successfully and before the next process template begins processing (if posting with a multi-template process). For a multi-template process, when a process template with an After Post Rule registered posts successfully, the data is passed to the next dependent template process as an input parameter.
Assemble
An import and export tool that allows for the creation and execution of packages that transfer data between two sources.
Assemble Package
Used to import and export data from various database and flat file types including: SQL Server, Oracle, ODBC/OleDB databases, fixed width and delimited text files, and Excel spreadsheets.
AutoGen
Process that automatically creates rules and objects based on configuration in Target Design. SQL AutoGen create basic objects used by the migration process (tables, rules and reports). Data Services AutoGen generates Data Services Jobs that perform target enrichments and validations. Data Services AutoGen also runs a set of standard validations (format checks, target value mapping checks and field status checks).
Automation Engine
Allows for the programmatic creating and processing of instructions, for example, creating rules in Collect. Instructions can only be automated from within a single data source.
B
Basic Rule
Conditional or default (one that populates the field with a default value) rule created in Target Design and used in AutoGen to apply conditions to up to three combined fields.
BDC Script
Batch Data Communication script recorded using either Integrate or the SHDB transaction in SAP. The script results are used to post data to SAP from Integrate and dspCompose™. For example, BDC scripts can be used to create a customer, then add customer address details.
Breakpoint
Stops rule or report processing in Transform at a specified place to assist when troubleshooting an issue. Make changes to a rule or report, then add a breakpoint to stop the job before the rule or report is run to see if the fix was successful. Breakpoints can be set for target source rules, target source reports, target rules and target reports.
Bulk Execution
Ability to run an event on a DSP™ page for all records or a subset of those records via a simple, guided user experience. Bulk Execution can be used on any page where it is activated by the page designer.
Business Contact
Type of user in Target Design used for reporting purposes who automatically receives published reports from Transform.
C
Catalog
Provides a means to populate and administer translations, help text and alias values at the WebApp and page levels.
Check Table
Table that stores the target field and value used in value mapping. A legacy (source) field and value is converted to a value in the lookup table (also called a check table) that the target system accepts in the target table. For example, if two companies merge, the legacy org numbers can be converted and then value mapped to new org numbers (stored in an org number lookup table) in the target ERP system.
Closed Loop Remediation
A process that uses passive data governance to facilitate data correction. After rules are run, a WebApp generates error reports, then sends the reports to the roles responsible for the data via a workflow. The roles fix the errors and post the corrected data to the target system. For example, after rules run in IS, the ISA creates a request in dspCompose. Using the workflow, the data is assigned to the role responsible for fixing the errors, and drives the data correction, review and posting of the corrected data via Integrate.
Collect
A data repository management component that is a core entity of many DSP™ product offerings. Collect maintains a unified collection of data from multiple, disparate systems without requiring users to connect to the actual systems. It can be configured to extract the data at scheduled intervals and at an individual table level. In this way, the data can be kept in sync based on the processing schedule of each data source. Collect also contains import groups to organize and manage sets of tables.
Common
A collection of utilities used throughout the DSP™ and dspMigrate™ components, including tracking rate of change, data encryption, data profiling, duplicate detection and scheduling.
Complex Rule
Rule documentation in Target Design that provides information the Data Services developer uses when writing the rule. When an AutoGen request is processed, a placeholder where Complex rules can be developed is created.
Console
A component that is the single point for the management and administration for dspMigrate™.
Construct
A component of dspMigrate™ that assists in creating, enhancing and converting data to load into the target system. Construct eliminates the inconsistency of maintaining multiple spreadsheets and provides a single location where users can update or directly enter data. Construction pages are used to enter or modify data required by the target ERP system that doesn’t currently exist in the source system(s).
Context
Combination of a wave and process area created in Console to which an object, target and source are assigned.
CTS
Change and Transport System (CTS) migrates objects from a source instance to a target instance of the DSP®. Each WebApp has a pre-defined set of objects that can be moved.
D
Data Quality Scoring
A process that uses industry standard calculations to calculate data quality. These calculations are used in dspMontor™ to determine a data quality score at the category (Groups, Objects, and Applications) and report level.
Data Services AutoGen
A component of dspMigrate™ that provides the ability to generate Data Services Jobs that perform target enrichments and validations, including post load validation of the data loaded into the target application. Using the AutoGen request options in the DSP™, users send the metadata required to generate the Data Services Jobs for the specific target to the dspCloud™ for processing. Data Services Jobs are created based on Target Design. Once generated, the Jobs are registered in Transform as Data Services rules.
DBMoto®
Application that provides packages for data replication from Microsoft SQL Server, Oracle, IBM DB2 LUW (or other ODBC-enabled databases) to Microsoft SQL Server. DBMoto® offers complete data replication (Refresh), followed by regular data updates (Mirroring) of changed data only and complete data replication (Refresh) using DBMoto® replication technology.
dspCompose™
A workflow-enabled application to govern the entry, review and approval of a proposed mass change. Users are assigned to roles, which are associated with templates. A template aligns with a single BDC or GUI script, an Integrate template, or a custom template, and can be reused for multiple requests. A request drives the workflow process to mass change a single object in SAP.
dspConduct™
A component that provides an Application Data Management solution for governing data business processes across disparate applications and infrastructures. dspConduct™ provides the ability to design, execute, and monitor business processes within an organization as they relate to the creation and maintenance of data within the enterprise architecture of an organization. A Designer creates the governance elements hierarchy, where tasks, roles, scenarios, business processes and their dependencies are defined.
dspMonitor™
The analytical component of the DSP™ that facilitates reporting on and maintaining high quality master data.
dspTrack™
A project tracking tool used to ensure project tasks are completed according to a project schedule and to alert managers when tasks and projects are in danger of being late or are late.
E
Enrichment Construction
Source used when legacy data does not exist for a field or a number of fields. A construction page is created that contains only the mapped field, not all active fields for the target. For example, a construction page could be created that contains a field from a particular object, such as Material UOM or Vendors Fax Number. The field is required by SAP but the field does not exist in the source system and the value for that field cannot be inferred.
Excel Integration
Feature that allows users to import data from Excel into DSP™ pages.
External Data Role
Role type in dspCompose™ that receives a spreadsheet with current request data via email when a request is created. The spreadsheet contains only required columns for adding (or in the case of validation failures, updating) request data. When a user creates a request based on a template with an External Data role, dspCompose™ sends an email with an Excel file attached to the external contact designated for the External Data role. This file contains current request data. The user with the External Data role updates the data in the spreadsheet and emails the file to the External Data Email Account set up in dspCompose™. If the data in the spreadsheet passes validations, dspCompose™ imports the data into the request automatically and continues processing the request.
F
Field Group
Filter used to create a subset of data in a target field in Target Design and Map. Based on values in another related field, these subsets can have different settings, such as criticality, whether the field is required or which rules run against the field. For example, the ttMARA table in SAP stores general material data. The field MTART on that table stores the material type. Material types include FERT (Finished Goods), HALB (Semi Finished Goods) and ROH (Raw Materials). Field groups can be created based on material types, so that rules can be run on all Finished Goods, all Semi-Finished Goods, and so on.
Field Mapping
Process of mapping fields from a source legacy system to a target system at the field level. Each field mapping has an action that determines; whether AutoGen builds a rule, the type of rule that AutoGen builds, the fields required to save the mapping on the Field Mappings page, and whether value mapping is necessary to map values in source fields to specific values in target fields.
Fixed Remediation Rule
Rule used when only one value in a field in the target data requires remediation to quickly correct the data in that one field for all the records. Fixed remediation rules can correct instances where a required field in the target system has been left blank in the source data, or has been formatted incorrectly to be loaded into the target system.
Full Construction
Source used as a single source or as one of multiple sources for a target in cases where no legacy data is available. Once the source is saved, AutoGen builds the Construct page (using the target’s active fields), the underlying table, and associated rules and stores them in the configured database. For example, a legacy application stores data about a material type, but does not support storing BOM or Routing data. If BOM or Routing data is required for the material type, a full construction source can be created to store it.
I
IG Universal Connect
IG Universal Connect uses the DSP® combined with Dell Boomi, an Integration Platform as a Service (IPaaS) solution. Boomi’s connectors allow the DSP® to extract and load data in systems that do not use a database connection, such as Workday, Salesforce or SAP SuccessFactors.
IGC
The Information Governance Cloud™ provides a holistic view from a single console across your data landscape with key features to help you easilty design and set data policies in your everyday governance work, without any programming.
Integrate
A component of the DSP™ that contains loading mechanisms to push data into an ERP system. Integrate loads data to SAP using Batch Data Communication (BDC) processing, Graphical User Interface (GUI) scripting, a Remote Function Call (RFC) or a BAPI. Integrate can also create and transfer user defined text files formatted as Delimited, Fixed Width, or XML to the SAP server.
L
Lookup Table
Table that stores the target field and value used in value mapping. A legacy (source) field and value is converted to a value in the lookup table (also called a check table) that the target system accepts in the target table. For example, if two companies merge, the legacy org numbers can be converted and then value mapped to new org numbers (stored in an org number lookup table) in the target ERP system.
Looped Template
Integrate template that uses a posting mechanism that processes multiple child keys for one parent key, allowing for multiple headers with multiple details to be posted. Looping is necessary when data in the same field at the detail level should be updated for multiple header records. For example, to enter data for the Export Legal Control for a Material, a template would need to generate one transaction with multiple screens to update the export control class for each country.
M
Map
A tool that facilitates the process of mapping for a target system implementation. Map is a key component for capturing and tracking requirements, customer decisions and specifications to provide accurate mapping information.
Mapping Set
Set of field mappings that can be exported and used as a back-up or imported and reused in another source in Map.
Metric Group
Subcategory of a field group in Target Design to further organize data for metrics tracking and mapping progress. Each set of metric groups is delineated into logical sets of fields that relate to a screen within the target system. For SAP-related objects, the metric groups can represent the tabs within an SAP screen or TCode (e.g., Customer Basic, Sales, Company and Accounting).
O
Opportunity View
A view configured for the dspMonitor™ report repository that contains the full set of possible records that could potentially fail in the associated error report Opportunity views are used for Data Quality Scoring.
Org Unit
Used to manage data security by restricting data a user can access based on organizational structure. Org units such as plant or company code can be tied to one set of validations, one set of dependencies and configuration options. For example, a template to perform a material change can be segmented by plant. At the request level, the org unit values, or the specific plants, can be assigned so that only users who are assigned to those plants can view or add request data.
P
Page Event
Actions that contain Validation Rules and/or Business Rules. Validation rules run first and validate data before executing any rules. Business rules run after validation rules complete and perform an action. They can be incorporated into each page or for a specific field triggering an action or event.
Position
A security template defined by a Security Administrator in dspConduct™ to which multiple users can be assigned. With positions, a Security Administrator can create a template for security once and assign multiple users to the template as needed. Position security is used to establish security for users in the Content WebApp.
Profile
The process of examining the data available from an existing data source and colleting statistics and informative summaries about that data. This information is used in Mapping, Data Quality, and Data Governance initiatives.
Project Distribution
Group consisting of 1. Users in ISA who receive reports detailing data that failed IS rules and 2. The rules and rule bindings that run for the distribution.
Q
Quality Dimension
An industry-recognized term used by data management professionals to describe a feature of data that can be measured or assessed against defined standards to determine data quality. In ISA, Quality Dimensions are used to organize rules and provide a score that contributes to the scorecard value, which is used to track progress towards a designated goal. When a user creates a rule in IS, it is assigned a Quality Dimension. The ISA displays a project’s Quality Dimension and a rule can be added or removed from projects based on the rule’s Quality Dimensions.
Quick Link
Bookmark accessible from the Quick Links icon in the Site toolbar that opens a DSP™ page. Quick Links are created for an individual user or all users assigned to a security role.
Quick Panel
Navigation tool that displays to the right of the vertical scroll bar and provides access to the Messages, Work List, Mapping Approval, Automation and dspCompose Requests tabs.
R
Relationship Join
Type of table join that supports the automation of rules built for Update Row sources within mapping where rules are automatically created and registered in Transform. Add relationship joins between the Add Row and the Update Row source(s) where the source information and source criterion comes from a table other than the Add Row table being mapped. The join indicates how the table in the Add Row source is joined to the table in the Update Row source so the update rules can be created and registered in Transform. For example, if the Add Row source table is Product (e.g., the LEFT TABLE is stMARC_AW_Product), and the Update Row source table is ProductInventory (e.g., the RIGHT TABLE is stAW_ProductInventory), a join would be set up on the keys between the two tables, the ProductID field.
Remediation Report
Report generated after Transform has processed target data, and used as a basis to create remediation rules. These rules correct erroneous values to temporarily fix a data issue so the affected records can be loaded into a test environment.
Report Repository
Reports in dspMonitor™ are organized by report repository. Once created in the database and registered in Common, report repositories must then be registered in dspMonitor™.
S
S Field (boaStatus)
Indicates the status of a record based on an assigned event. Validation Rules and Business Rules are assigned to events to verify conditions or take action on data based on a given condition. Actioned events run and can require certain actions from the user. Events can be run at the page level (affecting all records) or at the individual record level, for example, when a record is saved.
Security Definition
Defines what data elements are used to limit access to records on a page displayed in the DSP™. A security definition must be defined to enable security for a component.
Security Key
Key that represents values defined in the security definition to which users assigned to the role can access. For example, each wave-process area created in dspMigrate™ is a security key that can be assigned to a role to allow users assigned to that role to access data for that context.
Security Role
Role that is assigned to set of users that perform certain functions, such as Application Administrator. Security roles are associated with security definitions, which set access to pages and allowed actions (such as Edit) on those pages.
Service Page
Non-interactive page that allows events to be configured and executed on a time-based Unit of Measure (UOM). Commonly used for automating a process to execute business logic against a specific record set, service pages could execute public WebApp events such as running Assemble packages or trimming log tables in a custom application.
Snap Shot Process
A Map process that captures mapping statistics at a specific point in time to measure against Gate Wave metrics for field mapping and value mapping. A gate, with a gate date and a percentage complete, allows a user to evaluate current mapping status against a customizable goal.
SQL AutoGen
A component of dspMigrate™ that creates basic objects used by the migration process (tables, rules and reports) so that users can focus on addressing complex requirements.
System Type
Generic information about external systems (e.g., Target ERP and Legacy) used for a data migration. Information captured for system types includes field names and description. A System Type flags key fields, and assigns check tables to field keys, join relationships between tables and generic mappings.
T
Tag
Optional label applied to a task or group of tasks in dspTrack™. Tags can ensure that a group of tasks all have the same users, rules or validations, and can be used to group tasks for reporting purposes.
Target Design
A component of dspMigrate™ used to document tables, fields and sources used in the migration project. Targets can be imported from a database, system type, or Excel file. Target Design can also be used to configure rules for target fields and lookup tables for value mapping and to create field groups and metric groups to categorize and prioritize data as it is mapped.
Threshold
Defines the status assigned to an object being scored when the percentage of defects falls below the threshold. Statuses are Red (critical), Yellow (warning) and Green and are displayed on summary pages, charts and dashboards in dspMonitor™.
Transform
A component of dspMigrate™ that cleans, manipulates and reports on data, and exports the data so that it can be loaded into a target ERP system using a load tool.
U
Update Row Source
Source used if data used in field mapping must originate from a source other than the Add Row source. For example, in the SAP target system, the Telephone2 field is on the same table (LFA1) as all the other address fields. A source system has a Supplier table that does not store the Telephone2 field. The field is stored on the Supplier Telephone table, which is an Update Row source, as it updates a field on the Supplier table.
V
Validation
Stored procedures or views that execute when an event occurs and confirm that data is valid. If the validation fails, processing stops.
Value Mapping
Process that allows an individual value in a source field to be configured and then converted to a value that the target system accepts in the target field. For example, if two companies merge, the legacy org numbers can be converted and then value mapped to new org numbers (stored in an org number lookup table) in the target ERP system.
W
WebApp
Application accessible in the DSP™. WebApps can be delivered applications or custom applications created in the DSP™ framework.
WebApp Group
Defines authorization or access on a page by page basis. Page rights are configured by granting WebApp groups access to view, add, edit or delete data on the page.
Workflow
Email notification method called from within a WebApp where an email is sent upon the execution of an event. If a workflow requires a user to log in to the platform to perform a function, a link can be included in the email to navigate directly to the relevant page in the WebApp. Workflow is used in situations where groups, users and fields outside the context of a particular page must complete a task, or when the decisions to manually send an email are complex.
Z
zLegacy Field
As part of the Transform automation process, additional fields with a zLegacy prefix are created as required for the rules generation process. These include all primary key fields and all fields with an associated lookup table in Target Design. For example, if MATNR is a primary key on the material master target, the field zLegacyMATNR is automatically created on both the source and target tables and contains the legacy material number. In addition, if the field MEINS is assigned a lookup table of T006 in Target Design, the field zLegacyMEINS is also created on both the source table and target tables. It contains the legacy information required for cross referencing data via the lookup table.