Adding & Editing Applications

This topic relates to the following sections:

• Datasources

• Adding & Editing Instances

• Adding & Editing Datasources

• Adding & Editing Tables or Columns

• Import Metadata

• Maintain Working Datasources

About Applications

On the Datasources multi-panel page, the data is divided among Applications, Instances, and Datasources. The Show list controls these types. Select a type from the Show list and the page provides guidance for building the details.

• Applications include Source and Target systems, for example, JDE, SAP HANA DB, MAXIMO, and so on.

• The Syniti Migrate system stores all the Snapshot Datasources, for example, SRCJDE, TGTECC, and so on.

• Migration Working Databases Application stores Working DB tables (for example, WRKRTR, WRKPREP, WRKOTC, and so on) in an Instance that collects the tables for grouping as a Reporting Object. Refer to Maintain Working Datasources for more information.

• The Snapshot Datasources provide a static database of tables and values pulled on a specific date from a system being used for Mock or Live Conversions. Refer to Snapshot Management for more information.

Add an Application

Note

This section and page are the same as used when referring to the Applications topic in Administer > Advanced. Before adding a new Application in this section, make sure to check the configuration page as it may contain the same Application marked as Inactive. Inactive Applications do not display in this section.

To add an application:

1. In the Applications panel, click the Add icon to open the Applications page.

   

2. Enter the details for this application using the following table as a reference:

   Section	Field	Description
   Details	Application Name*	(Required) The name of the Application.
   Details	Description*	(Required) The description of the Application.
   Details	Prefix	Text to store any additional information.
   Details	Vendor	Name of company who provides this application.
   Details	Website	Internet Website of this Vendor account.
   Details	Active	Toggle switch to make the table Active/Inactive. NOTE: Defaults as Active.
   Technical Details	SAP	Toggle to mark as an SAP Application.
   Technical Details	Table Extract SQL	Notes for the Extract - Also stored in DBCommands table in Administer > Advanced > Database Types
   Technical Details	Column Extract SQL	Notes for the Extract - Also stored in DBCommands table in Administer > Advanced > Database Types
   Technical Details	Check Table SQL	Notes for the Extract - Also stored in DBCommands table in Administer > Advanced > Database Types
   Technical Details	Extract Notes	Notes for the Extract - Also stored in DBCommands table in Administer > Advanced > Database Types
   Stakeholders	Owner*
   Attributes	Various
   Audit	Various	These are the system generated values for auditing the work.

3. Click the Save icon to complete.

Edit an Application

To Edit an existing Application, click the Edit  icon to display the Application Details page.

You may add new Instances, Tables, and Columns to the existing application. You may also modify the Details section to update field values as required.

The left side of the Application Details page contains the Application Details. These fields are supportive of the Application design, usage, classification, and review. Each section of this panel stores valuable information. In the left-side panel, the following quick use icons are available at the header bar:

Icon	Name	Use
	Save	Saves the current entries.
	Cancel	Leaves the current page without saving changed data.
	Help	Redirects you to the page in Syniti Online Help to provide detailed explanation of this section and use.

When finished with editing the Application details, click the Save  icon to complete.

Delete an Application

The deletion process for Application cascades delete through to the Datasources. Clicking the Delete icon produces a warning message that includes the Application Name and a count of the supporting child objects that are deleted in this effort.

Click OK to Proceed or Cancel to exit without saving.

The Application and all associated Instances and Datasources delete. The page updates to show these objects as removed. There is no back out or replace for this action. A message displays to indicate that the deletion was successful.

Note

Should the Datasource have attached Dataset, Metrics, and Mappings, then it will not show as active for delete. The Delete icon will show as gray or inactive.

Application Tabs

On the right side of this page are the tabs of the Application as shown below:

Refer to each section for details of Create and Maintain for these data objects. These entries are specifically associated with the Application selected.

Subsequent Steps

The next step in this process is to create the Instance for this Application.