Data sources
Introduction to UI Bakery data sources
Start building your app by connecting your data source. UI Bakery allows connecting to a database or any API:
databases (MySQL, PostgreSQL, etc.);
external APIs (Google Sheets, Firebase, etc.);
internal APIs
Data sources in UI Bakery are global, meaning that once set up each data source can be used across different applications. If needed, you can manage data sources' access permissions for different user roles.
Connect a data source
Check out this article and follow the step-by-step instruction to connect a new data source.
Manage access to data sources
By default, admins and editors of your workspace have all permissions needed to manage data sources - they can add new data sources, edit and remove existing ones. Workspace members with a user role have read-only permissions to all data sources. However, you can manage access to data sources for users and users with a custom role.
To manage access to data sources:
On the Data sources page, click the Manage access settings button:
In the window that opens, click the pencil icon next to the role you want to edit.
Navigate to the Data sources tab and select the data sources to which you want to grant access, to use and/or manage them.
Next, click Update role.
By default, all newly created data sources can be used by every role. If you want to restrict their usage, simply clear the Use tick for the specific role.
Enable anonymous access
By default, access to data sources is restricted and managed via roles and permissions. For public apps, you can enable anonymous access to your data source, but be cautious as it allows any user to query your data.
You can enable/disable anonymous access in the Data source settings.
Refer to this section to learn more details on how to safely manage anonymous access.
Whitelist IP address
To be able to connect to your data source in the cloud version, you need to whitelist our IP address:
This process may differ depending on the database. Below you can find whitelisting instructions to a couple of databases:
PostgreSQL (with
.conffiles)
Select the data source outbound region
By default, when UI Bakery proxies data from your database to your end user, it passes through UI Bakery servers located in central US. This may cause performance degradation if both the user and the final data source are located in another region.
To enhance performance and reduce data load time, select the Outbound region that is close to both the data source and the user in the Data source settings. It will ensure data flowing directly from the source to the user interface.
List of available data sources
Databases:
Third-party services & APIs:
Last updated
