Dataset Design

This topic contains the following sections:

• Create & Maintain Subject Areas

• Create & Maintain Datasets

• Import / Export Dataset

• Maintain Tables and Fields tab

• Maintain Data Elements tab

• Maintain Migration tab

• Stakeholder Details

• Attribute Details

• Working Databases in Migrate

About Dataset Design

The Dataset Design process captures the business process design including relevant tables and fields for a dataset. It is the To-Be state of the migration as well as the hub for governance of the processes and policies. The information gathered and stored in Dataset Design provides the Target side of the Mapping process. The Subject Areas are similar to a process within a company and they group the Datasets together that together form this process.

The business process design includes all the relevant business objects, i.e., business partners, articles, purchase orders, etc., as they relate to one another within the business process. At each step of the process, there is usually 1 or more datasets that encompasses data needed to let a company process advance.

Prerequisites

Before working in Dataset Design, several steps must be completed within Syniti Migrate to enable the availability of the metadata for design. These steps include:

• Create System Datasources and Snapshot Datasources linked to active Connection Agents for use in Dataset Design.

• Import Metadata from the target system.

• Create the Subject Area.

Users & Roles in Dataset Design

The Design Team is responsible for determining the relevant functional areas for data migration and data governance. There are additional roles within Dataset Design that must be defined for both the business users and consultants.

Note

Within Dataset Design, Security access for Datasets and Subject Areas may be restricted to certain roles (Ex: Admin only access). This is considered Child Control within Security.

Working in Dataset Design

View the following page by navigating to Catalog > Dataset Design from the Syniti Migrate Homepage to launch the Dataset Design multi-panel page. This page includes two main functional panels of Dataset Design - Subject Areas and Datasets.

Note

The counts of each grid panel are displayed within parenthesis next to the panel titles.

Sliding Divider Bar

This page is set with a Sliding Divider Bar - the divider may be moved from side to side to give more room to a panel. Refer to Migration User Interface > Menu Structure for details of this benefit.

Rules and Tasks specific for Using a Database other than the Migration SQL Server

Refer to the section The Data Migration Process for details of working in a database that is not same as the Migration SQL Server.

In some cases, the project uses SAP HANA DB or Oracle DB or may even enforce using a different Client held SQL Server for the working database. For example, Syniti Migrate is stored in SQL Server; however, the data may reside in a different Database. The Data Migration Process provides sections for:

• Migration Using Oracle as the Database

• Migration Using SAP HANA DB as the Database

• Migration Using a 2nd SQL Server as the Database

Subsequent Steps

Refer to section Create & Maintain Subject Areas for the next set of steps in this process.