In this tutorial, you will learn how to build your first data authoring application. This application mimics an Employee (i.e., HR) domain where employees and contractors will be authored, as well as the department to which they belong and their education credentials.

The overall data model for the application you are about to build looks like this:

Learning outcomes

Learning track

This tutorial is the first of a series of six units that will guide you through designing a complete data management application.

This tutorial assumes that you have already set up a functional Semarchy xDM environment and you have design-time privileges to connect to the Application Builder.

If you have not set up Semarchy xDM yet, you can complete the Quick Install tutorials from the Tutorials menu. Additional setup information can also be found in the Semarchy xDM documentation.

If you have not already done so, click the button below to download all the images and data sets that will be used in this tutorial.

DOWNLOAD TUTORIAL RESOURCES

Semarchy xDM uses an entity-relationship (ER) approach to help you create the logical model of your application.

To get started, you need to create a new logical model. The logical model will hold all your entities, attributes, rules, forms, collections, and application definitions.

  1. Open the Application Builder.
  2. Click on New Model.

  1. The Create a New Model wizard opens. Enter HRTutorial in the Name field and then click Finish.

  1. In the context menu, right-click on Diagrams and then select Add Diagram.
    The Create New Diagram wizard opens.

  1. In the Name field type MainDiagram and click Finish.

Congratulations!

You have successfully created a logical model for your application.

Next, you will add the first entity of your model.

You are now ready to create the Employee entity. Once fully set up, it should look as follows:

Attribute

Datatype

Mandatory

Notes

ID

Number

Yes

Auto-numbered ID

FirstName

String(128)

Yes

LastName

String(128)

Yes

Salutation

List of values

No

Refers to the Salutations LOV

Subsidiary

List of values

Yes

Refers to the Subsidiaries LOV

Title

String(128)

No

-

HireDate

Date (Built-in Type)

Yes

-

EndDate

Date (Built-in Type)

No

-

IsContractor

Boolean

No

-

Email

String(500)

No

-

Phone

String(128)

No

-

Picture

Binary

No

Will hold the employee picture

To create this entity, you will:

  1. Create the entity and add the FirstName and LastName attributes.
  2. Create two lists of values (LOVs): Salutations and Subsidiaries.
  3. Add the Salutation and Subsidiary attributes to your entity and refer to the LOVs you previously created.
  4. Add all the remaining attributes.

Add the Employee entity to the model

The fastest way to add a new entity to your model is using the diagram.

The entity you will create is a basic entity, which is best suited for data authoring use cases.

  1. Select Add Entity in the diagram Palette.

  1. Click anywhere on the diagram.
    The Entity wizard opens.

  1. Enter Employee in the Name field and then click Next.

  1. On the next page, set the Name attribute to ID.
  2. Keep the Sequence option selected for ID Generation. This means that the ID generation will use a sequence number instead of a manual or calculated value.

  1. Click Finish.
    The new Employee entity appears on the diagram.

You have successfully added the Employee entity.

Next, you will add its first attributes.

Add the FirstName and LastName attributes

  1. Right-click the Employee entity in the diagram and select Add Simple Attribute.
    The Simple Attribute wizard opens.

  1. Enter the following values:
  1. Click Finish
  2. Right-click again the Employee entity on the diagram and select Add Simple Attribute to create another attribute.
    The Simple Attribute wizard opens.

4. Enter the following values, and then click Finish:

  1. Save all your work. To do so, click the Save all current contents button at the top of the Model Design view.

Congratulations!

You have just created your first entity with three attributes. It appears on the diagram.

The ID of the Employee entity will be automatically set using a sequence.

Next, you will add lists of values to your model.

You will now create two lists of values (LOVs) that you will use to restrict the possible values for the Salutation and Subsidiary attributes.

Create the Salutations LOV

  1. In the Application Builder, right-click on Lists of Values from the Model Design view and select Add List of Values.
    The creation wizard opens.

  1. Enter Salutations in the Name field, and then click Finish.

  1. Click on the Add Value button from the Values section.

  1. Enter Dr in the Code field, and click Finish.

  1. Repeat the same operations to add the following values:

Code

Label

Mr

Mr

Mrs

Mrs

Miss

Miss

  1. In the end, the Values section should look like this:
  2. Save your work.

Add the Salutation attribute

Now it is time to add the Salutation attribute to your entity and set its datatype to the previously created Salutations list of values.

  1. In the Application Builder, go to Entities > Employee, right-click on Attributes and select Add Simple Attribute.
    The wizard opens.

  1. Enter Salutation in the Name field.
  2. For the Type, select Salutations [List of Values], and then click Finish.

Create the Subsidiaries LOV

Create another List of Values named Subsidiaries the same way you did for Salutations, with the following values:

Code

Label

ACME_APAC

ACME APAC

ACME_EU

ACME EU

ACME_US

ACME US

Add the Subsidiaries attribute

You will now add the Subsidiary attribute. Note that this attribute is mandatory.

Create another simple attribute with the following values, then click Finish:

Congratulations!

You have successfully created two lists of values and added them to your model attributes.

Next, you will finalize the Employee entity by adding other attributes.

Add other attributes

It is now time to finalize the Employee entity.

  1. Following the instructions in ③ Create the Employee entity, add the remaining attributes of the Employee entity.

Attribute

Datatype

Mandatory

Notes

Title

String(128)

No

-

HireDate

Date (Built-in Type)

Yes

-

EndDate

Date (Built-in Type)

No

-

IsContractor

Boolean

No

-

Email

String(500)

No

-

Phone

String(128)

No

-

Picture

Binary

No

Will hold the employee picture

  1. Double-click on the Attributes node under Entities > Employee in the Model Design view to review the Employee entity. Check that all attributes have been added and that the datatypes and Mandatory checkbox are correctly configured.

  1. Save your work.

Congratulations!

You have successfully created the main entity of your model.

To summarize:

Next, you will add a second entity and link it with the Employee entity.

You are now ready to create the Department entity.

Attribute

Datatype

Mandatory

Notes

ID

String(20)

Yes

ID is set manually

Name

String(128)

Yes

Name of the department

Description

String(4000)

No

Description of this department

Departments are created and maintained by business users and each employee refers to a single department.

In this section, you will:

  1. Create the entity and add its attributes.
  2. Add a reference to describe the one-to-many relationship between departments and employees.

Create the entity and its attributes

To create the Department entity, follow the same procedure as you did earlier with the Employee entity.

  1. Add a new entity to MainDiagram with the following values, and then click Next:

  1. Set the primary key attribute with the following values and then click Finish:

  1. Add the Name attribute with the following values and then click Finish:

  1. Add the Description attribute with the following values:

Add the Employee-Department reference

On MainDiagram, create a reference relationship named EmployeeDepartment, from the Employee to the Department entity.

  1. Click Add Reference in the Palette.

  1. Click on the Employee entity and drag the line to the Department entity, as shown below.

  1. Configure the reference with the following values and then click Finish:

  1. Review MainDiagram.
    Note that the Department foreign attribute has been added to the Employee entity.

  1. Save your work.

Congratulations!

You have successfully added the Department entity and enforced referential integrity by creating a reference.

Next, you will add the Education entity.

You are now ready to create the Education entity. At the end of the creation process, it should be configured as follows:

Attribute

Datatype

Mandatory

Description

Notes

ID

Sequence

Yes

Automatically generated

FromDate

Date

Yes

Start date of curriculum

ToDate

Date

No

End date of curriculum

DegreeReceived

String(128)

Yes

Freeform name of degree received

Country

String(128)

No

Freeform name of country

School

String(128)

No

Free form text for the school name

This entity tracks an employee's educational background, including dates and attained degrees from schools across various countries. Each employee will possess multiple education records.

In this section you will:

  1. Create the entity and add its attributes.
  2. Add a reference to describe the one-to-many relationship between education records and employees.

Create the entity and its attributes

  1. Create the Education entity the same way you did for Department. Add a new entity to MainDiagram with the following values and then click Next:

  1. Set the primary key attribute with the following values then click Finish:

  1. Following the instructions you used for the attributes of the Department entity, add the attributes below to the Education entity.

Attribute

Datatype

Mandatory

Description

Notes

FromDate

Date

Yes

Start date of curriculum

ToDate

Date

No

End date of curriculum

DegreeReceived

String(128)

Yes

Freeform name of degree received

Country

String(128)

No

Freeform name of country

School

String(128)

No

Freeform text for the school name

Add the Education-Employee reference

From MainDiagram, create the reference relationship named EducationsEmployee, from the Education to the Employee entity.

  1. Click Add Reference in the Palette.

  1. Draw a line from Education to Employee.

  1. Set the reference with the following values and then click Finish:

  1. Review the Main Diagram.

Note that the Employee foreign attribute has been added to the Education entity.

Your diagram should now look like this:

  1. Save your work.

Congratulations!

You have successfully added the Education entity and created a reference to the Employee entity. Your model now contains all the entities that you need.

Next, you will design the user experience for your application. You will learn how to add forms, collections, and more.

Semarchy xDM uses Material Design as the design language for defining a business user interface. The user interface uses multiple application components that you will define in the next sections.

Application components

In Semarchy xDM, data applications rely on several components that you can directly generate and configure in the Application Builder. The following examples are taken from the application created using the Product Retail demo tutorial.

Generate application components

Once you have completed the initial configuration of your data model, you can quickly use the Generate Application Components wizard to automatically generate most of the components you will need to enable user interaction with your data.

To generate application components:

  1. Right-click on the Department entity and select Create Application Components.

  1. Click Next.

  1. Set the following values for the entity's Display Card text expressions, and then click Finish:

  1. Repeat the steps above for the Education entity with the following values:
  1. Repeat the steps above for the Employee entity with the following values:
  1. Save your work.

Explore what was generated

The wizard has generated the following elements for each of your entities:

  1. Expand the Department entity to see the generated components.

  1. Scroll down in the Model Design view and go to Applications > DefaultApplication.

  1. Double-click on Folders and Actions and observe that a default list of menu items was initialized and includes the following actions to browse each entity:

Assign visual icons

Assigning icons to your entities is considered a best practice. These icons will visually guide users across various areas of your application.

  1. From the MainDiagram, select the Employee entity.
  2. In the Properties view below the editor, identify the Icon property within the Name and Description tab, and then click Select Image.

  1. Type account.svg in the search bar and press Enter to filter the images.
  2. Select the mdi/account.svg image.

  1. Repeat the same steps for the Department entity. Search and select domain.svg.

  1. Repeat the same steps for the Education entity. Search and select school.svg.

  1. Save your work.

Customize forms and collections

In this section, you will open the collection and form of the Employee and Education entities and configure the date attributes to use a date picker visual component:

  1. Navigate to Entities > Education > Collections in the Model Design view and double-click on EducationCollection.

  1. Select the FromDate attribute and set the Component Type to Date Picker in the General section of the Properties inspector.

  1. Repeat the same operation for the ToDate attribute.
  2. Expand the Forms node under Entities > Education and then open the EducationForm.
  3. Select the FromDate attribute and make sure the Component Type in the General tab of the Properties inspector is set to Date Picker.

  1. Repeat the same operation for the ToDate attribute.
  2. Repeat the same process for the Employee entity with the attributes HireDate and EndDate in both the EmployeeCollection and the EmployeeForm.
  3. Save your work.

Configure the Global Search feature

The Global Search configuration defines which business views are searched when a search string is entered in the Global Search page, and how they are searched.

  1. Navigate to Applications > Default Application in the Model Design view, and double-click Global Search Configuration.

  1. Click the Add Business View to Search button in the Searched Business Views section.

  1. Enter the following values and then click Finish:

  1. Click again Add Business View to Search, enter the following values, and then click Finish:

Brand your application

  1. Double-click Applications > DefaultApplication in the Model Design view.
  2. Enter the following values:

  1. Save your work.

Validate your model

Before deploying your application, it is a best practice to validate your model.

  1. Right-click on the HRTutorial node in the Model Design view, and then select Validate.

  1. Your model is analyzed and the validation report is displayed in the bottom section of the Application Builder. You should have no errors.

Congratulations!

You have successfully completed the second part of this tutorial by creating a first auto-generated application.

To summarize:

Next, you will learn how to deploy and connect to this application for the first time.

Semarchy xDM allows you to deploy your model into a data location. It creates all the tables and columns in a relational database (Oracle, SQL Server, or PostgreSQL). Additionally, it generates user interfaces for your applications, enhancing the business user experience.

Create a datasource

Before creating a data location and deploying your model, you must create a platform datasource to connect to the SEMARCHY_EMP_TUTORIAL database schema that was created in the Quick Install tutorials.

  1. In the Application Builder toolbar, expand the user menu, and then select Welcome page.

  1. Select Configuration.

  1. Scroll down to the Connections section and click Datasources.

  1. Click the Add datasource floating action button.

  1. Enter the following values and then click Create:

  1. Enter the following connection parameters in the editor:

  1. Enter the password of the database schema:

  1. Click Test this Datasource in the button bar above the editor.

  1. The "Datasource test successful" message should be displayed. Click OK.

If another message is displayed, identify the error and fix the connection parameters.

  1. Click the Save and apply datasource modification button on the datasource editor.

  1. Open the user menu on the top-right corner and then select All applications to go back to the Welcome page.

Create a data location

In this section, you will create the EmployeeTutorial data location and deploy your model into it. To do so:

  1. Open the Application Builder.
  2. Click the Management button in the Application Builder toolbar to access the Management perspective.

  1. Right-click Data Locations and select New Data Location.

  1. Enter the following values, and then click Finish:

Connect to the application

In this section, you will learn how to connect to the Employee Tutorial application that you have just deployed. To do so:

  1. In the Application Builder toolbar, expand the user menu, and then select Welcome page.

  1. Click the Employee Tutorial button to open the application.

  1. If you have not yet completed the profile for the semadmin user in a previous tutorial, a popup appears. Click Next.

  1. Enter the following information for semadmin, and click Continue:

  1. On the next screen, click Get started.
  2. Discover the user interface that was built for your application:

Congratulations!

You have successfully deployed your first application into a data location.

To summarize:

Next, you will learn how to use this application to start entering data and navigate the business user data management interface.

Now that you have deployed your model and application, it is time to start authoring data.

Semarchy xDM has generated all necessary actions and menus to facilitate data authoring, importing from spreadsheets, searching for data, and refining search results to identify data typos.

For more information on application usage, you can consult the Product Retail demo tutorial, which showcases a fully functional product data application.

User profile

As a first-time user, you will need to update your profile information and preferences. To do so:

  1. In the Employee Tutorial application, open the user menu on the upper-right corner and select Profile from the menu.

  1. Basic information about yourself is already set. Hover your mouse over the default profile picture and click the Change profile picture button.

  1. Select on your hard drive the semadmin.jpg picture which is available under the data-consolidation/pictures folder of the tutorial resources you downloaded previously.
  2. Click Upload.

  1. (Optional) Customize your user preferences like date format, language, etc. in the Settings tab, and then save.

Author or import departments' data

Learning outcomes

  1. In the Employee Tutorial application, click the Departments menu item in the navigation drawer.
  2. Select Create from the actions menu above the Departments collection.

  1. Create the first department with the following values, then click Finish:

  1. Wait until the toaster at the bottom left corner of the screen indicates "Changes successfully applied," and then select Click to refresh to view the imported data.

  1. Select Import in the actions menu to load the rest of the departments.

  1. Select the data-authoring\datasets\departments-data.xlsx file from the tutorial resources you downloaded earlier.
  2. Review the import contents and click Continue.

  1. On the Define mappings screen, keep the default mappings and click Continue.

  1. Review the import summary, and then click Finish to import the data.

  1. Review the imported data and click Finish.
    The data will be submitted to the certification process so that all users can access it.

  1. Wait until the toaster on the bottom left corner of the screen indicates "Changes successfully applied," and then select Click to refresh to see the imported data.

  1. The Departments collection is now showing six records.

Import employee records

In this section, you will import employees from an excel spreadsheet.

  1. Click on Employees in the navigation drawer and select Import from the actions menu.

  1. Select the data-authoring\datasets\employees-data.xlsx file from the tutorial resources you downloaded.
  2. Review the import contents and click Continue.

  1. Click Continue on the next page to confirm the mapping.
  2. Click Finish on the Import Summary page.
  3. Review the data to import and click Finish.

  1. When the toaster indicates "Changes successfully applied," select Click to refresh to view the imported data.

  1. Observe that 34 employee records have been imported.

Global Search

Global search allows you to search for records across multiple entities. In this tutorial, we previously configured the Global Search feature to search both the Department and Employee entities.

  1. Select Global Search in the navigation drawer.

  1. Enter sales in the Search text field and click the Search button.

  1. Notice that the application found one department named Sales and several employees that contain the word sales in their title.

Search and edit an employee's data

In this section, you will learn how to use advanced search to refine your results.

Within the employee data supplied by Semarchy, a title is misspelled as Fenior Consultant instead of Senior Consultant. You will now locate this employee record and correct the error.

  1. Select Employees in the navigation drawer and click the Filter button located above the Employees collection.

  1. Enter fenior in the Search Text field, and then click Apply or press Enter to search for the misspelled record.
    The search returns one record.

  1. Click the checkbox next to this record to select it. Open the Options menu and then select Edit.

  1. Fix the Title value by setting it to Senior Consultant, and then click Finish.

  1. Wait for the toaster to display "Changes successfully applied," and then select Click to refresh.

  1. Observe that the search does not return any results.

  1. Click the Filter button again to display the filter panel.
  2. Enter markle in the Search Text field and click Apply to retrieve the record you modified.

  1. On the employee's display card, notice that the title is now correct.

Well done! You have built your first data authoring application with Semarchy xDM.

Learning recap

Next steps

In the next unit, Data quality, you will learn how to enforce data quality within your Employee Tutorial application with enrichers, data validation, and duplicate detection rules.

GO TO TUTORIALS

Thank you for completing this tutorial.