Data sources
Last updated
Last updated
© 2024 UI Bakery
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.
Check out this article and follow the step-by-step instruction to connect a new data source.
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.
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.
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 .conf
files)
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.
You can find the list of all data sources available in UI Bakery here