...
...
...
...
...
...
...
...
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.
...
explore and associate existing databases objects including tables, stored procedures and functions. In this lesson we will showcase Tables related features but the same concepts and features apply to SPs and Functions.
How to explore Database Tables?
On Wayfast, make sure that the Project is created and at least, a requirement is in “Active” status.
...
Wayfast automatically shows the different Transactional, Master data and Business data tables in grid view dashboard.
How to associate Tables from other databases?
Click on “Associating Tables” button and this popup will open.
...
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 We need to choose a SQL Server instance and Database to locate the “Object” we want to associate.
Clicking the magnifying glass in the “Object” field will retrieves all the tables available.
Select the desired table an click on the “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 Let’s open 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 on “End Task” in the “Active” requirement
...
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.