Connecting SQL Server to UI Bakery
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.
If you need to be able to override the default data source database with a custom value in an action, you can enable the setting Allow override database name in action:
Once enabled, when configuring the action, you will be able to specify the custom database. In case a database is not specified, the default data source database will be used.