.svg?alt=media&token=22229f15-f796-4c11-a928-049c59e13a36)
Data sources
Connecting your data source is an essential step in building your application. 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.
UI Bakery data sources
You can find the full list of all data sources available here 👇
List of Data sourcesConnecting a data source
Check out this article and follow the step-by-step instruction to connect a new data source.
Managing data source access
By default, Admins and Editors of your workspace have all the permissions needed to manage data sources - they can add new data sources, edit and remove existing ones. Workspace members with a User role have a Read-only permission to all data sources. However, you can still manage access to data sources for Users with a custom role.
To manage user access to data sources:
On the Data sources page, click Manage access settings.
On the page 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 which you want to grant access to - Use and/or Edit them.
Next, click Update role.
By default, all newly created data sources are available only to the same roles which the user who created them has.
If you need to, you can also restrict access to data sources - simply clear the Use checkbox for a specific role.
Enabling anonymous access
By default, access to data sources is restricted and managed via roles and permissions. If you have a public app, you can enable anonymous access to your data source, but you should be cautious since it will allow 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.
Whitelisting IP addresses
To be able to connect to your data source in the cloud version, you need to whitelist our IP addresses:
This process may differ depending on the database. Below you can find whitelisting instructions to a couple of databases:
PostgreSQL (with
.conffiles)
Selecting data source outbound region
By default, when UI Bakery proxies data from your database to the 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 other regions.
To enhance performance and reduce data load time, you need to set the Outbound region that is closer 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.
Last updated
