Overview

In this lesson we will explain how to associate existent Tables in our databases and the relation with the different instances depending on the environment that Wayfast users are going to develop the application. Also we will describe how to create a new table in SQL and synchronize it into Wayfast.

How to associate an existent Table from Wayfast?

On Wayfast, make sure that the Project is created and at least, a requirement is in “Active” status.

Click on “Database” icon at the top menu.

On Submenu, click on “Tables” subtab

Wayfast automatically shows the different Transactional, Master data and Business data tables in grid view dashboard.

Click on “Associating Tables” button

Wayfast displays all the Instances and Databases related to the Project. “Object” lookup field retrieves all the “Table” objects that Admin has visibility.

Select any object and click on “Assign” button.

Now we have the “Table” object associated to the Project and we can continue defining the Requirements.

How to create a new Table in SQL and synchronize it on Wayfast?

Turn to SQL Server Management Studio and connect to the DB associated to the Project. In a new query, create a new table with the following data settings: 

CREATE TABLE HWD_Transactions(
Field1  Nvarchar(50)  COLLATE DATABASE_DEFAULT  NULL,
Field2  Nvarchar(50)  COLLATE DATABASE_DEFAULT  NULL,
Field3  Nvarchar(50)  COLLATE DATABASE_DEFAULT  NULL,
Field4  Nvarchar(50)  COLLATE DATABASE_DEFAULT  NULL,
Field5  Nvarchar(50)  COLLATE DATABASE_DEFAULT  NULL,
Status  int NULL)

Execute the query and verify that the Table is created. Then return to Wayfast and focus on the left navigation bar. Click on “End Task” in the “Active” requirement

A popup is displayed but we don’t need to end the task, just click on “Synchronize” button

Return to Database-Table submenu

Automatically the new row is added on the Transactional Tables grid view with the corresponding “Instance” and “Database” values that we create on SQL.

Recap

In this lesson, we learnt how to associate existent tables in our Project’s database. And we observed how the new tables created from the SQL Server Management Studio are synchronized in simple steps into Wayfast.