Overview

In this document we explain how to associate existent Tables in our DBs and the relation with the different instances depending on the environment that Wayfast users are going to develop the application. Also we 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 “Database” icon at the top header.

...

On Submenu, selects “Tables” subtab

...

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

Click “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 “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: 

...

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

...

A popup is displayed but we don’t need to end the task, just click “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 Wayfast admin user creates on SQL.

Recap

In this document, we learn 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 the Wayfast application.