Construct Pages

This topic relates to the following sections:

• Construct Page Deployment Security

• Construct Page Metrics

• Metrics Configuration

About Construct Pages

This section of Syniti Migrate is specific to the Construct Pages process. Construct Pages is the process of building or cleansing data to use as part of the migration of data. New Construct pages are registered once identified during a mapping session to track the design, build, and deployment of Construct Pages. They are built in Syniti Construct and therefore follow all the naming conventions and logic of that application.

Construct Pages is supported by individual tables built in the SQL server CONSTRUCT database.  These tables contain Syniti defaulted fields for use as Key fields to uniquely define each row of data as well as fields from legacy and target tables to provide the level of details for the users to properly maintain the output values.  A Construct Pages table may support all relevant fields of a target table, or can be a set of fields from multiple tables to support the build of the target field(s). 

From this page, the user may access Syniti Construct by clicking the Syniti Construct icon in upper right corner of page.

Dependencies on Database Setup

• Prior to registering a Construct Page within Syniti Migrate, the project database system must include a CONSTRUCT datasource as a System Datasource associated with a CONSTRUCT Datasource Server. The CONSTRUCT Datasource Server is linked through the Agent to a SQL Server database system within Syniti Construct application at the client site. This datasource is the Syniti Construct database where all pages, rules, validations, and customer construction data is stored. Refer to sections Datasource Servers and Adding & Editing Datasources for details of building and linking these.

• The DBA also builds a database for the Construct Snapshot Datasource (SRCCONSTRUCT).  This secondary snapshot datasource (at client site) stores the copy of Construct table data in a static mode for use during testing while the CONSTRUCT database continually has maintenance by the users. Refer to section Migrate > Snapshot Management > Add SRCCONSTRUCT as a Snapshot Datasource for more details.

• The Syniti Construct WebApp Page must be built within that system. Refer to Syniti Construct online help for more details of the building of the Webapps and pages.

Users & Roles in Construct Pages

Users of Construct Pages have security defined by the Syniti Construct application. Refer to Syniti Construct online help - Assign Users to Security Roles for more details.

Prerequisites

Prior to adding a new Construct Page to the Syniti Migrate application, the user must:

• Build the table and views in the client's CONSTRUCT database that are assigned to the Construct Page.

• Link the client's database to the Syniti Construct application by assigning the Migrate Datasource to the client's database.

• Build the WebApp page and all security, checks and validations associated with the Construct Page.

  Note

  Refer to the Syniti Construct online help for specific steps for this setup.

Access the Syniti Construct application by navigating to Migrate > Construct from the Syniti Migrate Homepage or by clicking the link Syniti Construct in upper right corner of the page.

Working with Construct Pages

View the following page by navigating to Migrate > Construct Pages from the Syniti Migrate Homepage.

Construct Pages

This section of Syniti Migrate provides opportunity to link to the construction pages in Syniti Construct that create, cleanse and modify data. 

The icons within this page are identified as follows:

Icon	Function	Description
	Add	To add a new object to a panel, click the Add icon to navigate to the detail view window.
	True/False	Toggle the field as Active/Inactive.
	Delete	To delete the current object, click the Delete icon, and select OK/Cancel on the subsequent verification window. NOTE: This cannot be undone. Deleting an object also affects tables, fields and mapping in the future steps of the process.
	Save	To save a new or edited object, click the Save Icon. When you have completed any changes, be sure to click the save button or all changes are lost.
	Search	To search for values in any relevant fields, click the Search icon and type the desired search value in the field drop-down.
	Cancel	To exit the detail view window without saving the changes made, click the Cancel icon.
	Deployment	Add deployment(s) to template. Refer to section Add Security to the Construct Page for details.

Add a Construct Page

Once the table is created in the Construct database and the WebApp Page has been added to the Syniti Construct system, the user can add the construction page to Syniti Migrate. Click the Add icon to open a Construct Page dialog box.

Within the dialog box, fill in the fields to create the new Construct Page:

Note

Field Construct Page ID stores the Page Name of the WebApp Page created within Syniti Construct. Click the drop down arrow to select from the list the Construct Page ID.

Note

Estimate Per Record -

Note

Construct Pages of Type = Enrichment do not require an estimate per record because existing records from the legacy system are being updated. The count of total records is defined by the list pulled in to update. However, Construct Pages of Type = Construction (where new records are created from scratch) have no total count as estimate to serve as the denominator for metrics. Therefore, the field Estimate Per Record(Minutes) attempts to provide timing to use for all construction type templates.

Save the record and the Columns in the panel on the right side of the page is populated based on the Table Definition.

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

Add View Lists to Construct Page

Construction table snapshot data is stored within database SRCCONSTRUCT of the Client's database system and MIGRATE_APP is linked to SRCCONSTRUCT as a system datasource that provides many tables for use in System Reporting, Construction pages, and for Central Relevancy. The tables MIG_ZDEPLOY_LIST and MIG_ZSOURCE_LIST may be used as field lists within a Construction page. They store the current system's list of Deployments and Source Datasources. These values are refreshed using Snapshot Management repopulation. The data must be setup as a Snapshot from SRCCONSTRUCT datasource to the SQL Server CONSTRUCT database for use in Construction pages.

Table MIG_ENRICH_METRICS provides a list of Construction pages that use a metric view with metric values for use in reporting.

Refer to section Add a CONSTRUCT Snapshot Datasource of Snapshot Management for details.

Link a Metric View to Construct Page

Syniti Migrate monitors the metrics for Construct Pages, if each of the Construct Pages are provided a Metric View stored within the client's CONSTRUCT database. These consolidated metric results are provided in both the Metric Scorecard and the PMO Dashboard sections of the system. Refer to section Construct Page Metrics for details of the setup and use.

1. Select the Construct Page.

2. Click the Edit icon to enter the Metric View name into field Metric View.

3. Click the Save icon to complete this change.

Add Security to the Construct Page

A Construct Page requiring security may incorporate the Deployments to split out or filter data based upon the deployments assignment to users. Deployments for a Project and Release are maintained within Project Setup, and then assigned to the users in this section through clicking the Deployments icon. Refer to section Construct Page Deployment Security for details of this process.

Edit a Construct Page

Throughout the usage of a Construct Page, it may be altered to update Status, Metric counts, Dates, and usage.  The user clicks to highlight the Construct Page to edit and then update the fields on the right side panel Construct Page.

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

Delete a Construct Page

In order to keep history of the project work, Construct Pages should not be deleted.  If the template has been maintained by users within Excel, the data could be lost to the project.  The Delete  icon should only be used during the initial setup prior to introduction to the users.  Mark the Construct Page as Inactive for use to save the metrics, audit details, and many rows of updates for history of the project.  To delete a Construct Page within Syniti Migrate click the Delete icon. A validation warning message may display should there be deployments associated with the page. Click Continue button to remove the page.