Overview
In this lesson we will explain how to 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 a popup will be displayed on screen.
...
| Info |
|---|
This feature will work only if we associated another existing database to the Project. If we only have the database created for this project, Wayfast won’t retrieve any other database and their tables. |
How to create a new Table in SQL and synchronize it on Wayfast?
Let’s open SQL Server Management Studio and connect to the DB associated to the Project.
...
| Code Block | ||
|---|---|---|
| ||
CREATE TABLE HelloWorld_TransactionsEmployee( Field1FirstName NVARCHAR nvarchar(50) COLLATE DATABASE_DEFAULT NULL, Field2LastName nvarchar(50) COLLATE DATABASE_DEFAULT NULL, Field3 nvarcharNVARCHAR (50) COLLATE DATABASE_DEFAULT NULL, Field4Role nvarcharNVARCHAR(50) COLLATE DATABASE_DEFAULT NULL, Field5Age nvarchar(50) COLLATE DATABASE_DEFAULTINT NULL, Status int NULL ) ) |
| Info |
|---|
Wayfast automatically includes an ID field when creating tables as part of the Database framework. |
Execute the query and verify that the Table is created. Then return to Wayfast and focus on the left navigation bar.
...
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.