Starter Guide
Basics
Data sources
On-premise
Tutorials
SQL Server
Connecting SQL Server to UI Bakery
Prerequisites
If your database is hosted behind the Firewall, add the following IP addresses to the Firewall whitelist:
1
23.99.134.30
2
40.122.170.142
3
104.43.136.75
4
104.43.140.0
5
23.99.128.183
Copied!
Configuration
Go to the Data sources page –> Connect –> Choose SQL Server. Enter your credentials and click Test connection.
Adding SQL Server as a data source
When the connection is successful, click Connect Data source. UI Bakery will extract the database structure and store column types. This data will be used to suggest the proper table columns and form field types.
Usage
Once you have the connection between UI Bakery and SQL Server, you can interact with its data.
- 1.Add and configure a new Action, e.g. write a SQL query to retrieve the data
- 2.Run the Action. Take a look at the Result tab to make sure the data is loaded.
Checking Result tab
Last modified 22d ago
Copy link