Overview
In this document lesson we will explain how to associate existent Tables in our DBs 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 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 headermenu.
...
On Submenu, selects “Tables” subtab
...
Wayfast automatically shows the different Transactional, Master data and Business data tables in grid view dashboard.
Click on “Associating Tables” button
...
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:
...
| Code Block | ||
|---|---|---|
| ||
CREATE TABLE Hello_World_Table(
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 Wayfast admin user creates we create on SQL.
Recap
In this documentlesson, we learn 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 the Wayfast application.