Data Sources : Overview
Data Sources pull in and push data to any source including databases, external APIs, or services. Once a data source is connected to a workspace, the connection can be shared with any app of that workspace.
Data Source page is available only on ToolJet version 2.3.0 and above.
![Data Sources: Overview](/img/datasource-reference/overview/overview.png)
Connecting data sources
- Create a new app from the dashboard, and Click on the + Add new button from the query panel.
![Data Sources: Overview](/img/datasource-reference/newui/overview/newqpanel.png)
Or you can directly go to the Data Sources page from the left sidebar of the dashboard
![Data Sources: Overview](/img/datasource-reference/newui/overview/newgds.png)
- Within the Data Sources page, you'll find various categories of data sources on the left side, including Databases, APIs, Cloud Storages, and plugins. Click on each category to view the list of accessible data sources. As you hover over the desired data source, an
Add
button will appear. Upon clicking this button, the selected data source will be integrated into the workspace.
![Overview of Data Sources](/img/datasource-reference/newui/overview/gdsadd.gif)
- Once the data source is added, you'll be required to input the configuration details for establishing a connection.
Note: For paid plans, configuration entry and saving are necessary to enable availability across multiple environments.
![Overview of Data Sources](/img/datasource-reference/newui/overview/connectinggds.gif)
- Returning to the dashboard, proceed to generate a new application. The recently added data source will be accessible within the query panel under the Available data sources section. Data Sources that have been added can now be utilized in both existing applications and newly created applications.
![Overview of Data Sources](/img/datasource-reference/newui/overview/gdslist.png)
- At this point, you can create queries to the connected data sources. Within these queries, the option exists to switch between distinct connections associated with the same data source, in cases where multiple connections have been established.
![Overview of Data Sources](/img/datasource-reference/newui/overview/switch1.gif)
Default data sources
By default, 4 data sources will be available on every app on ToolJet:
![Data Sources: Overview](/img/datasource-reference/newui/overview/defds.png)
User Permissions
Changing the Permissions for Data Sources is a privilege reserved for Admins and Super Admins within the workspace.
To configure these permissions, navigate to Workspace Settings -> Groups Settings. Admins and Super Admins have the authority to assign the following permissions to user groups:
Creation and Deletion of data sources within the workspace
Permission | Description |
---|---|
Just Create | Add new data sources and modify existing ones. Delete button will not be visible on hovering over the connected data source. |
Just Delete | Remove connected data sources from the workspace. Delete button will show up on hovering over the connected data source. |
Both Create and Delete | Add new data sources and remove connected data sources from the workspace. |
Niether Create nor Delete | No access to the Data Sources page from the Dashboard. Error toast will popup on trying to access the Data Sources page using URL. |
![Data Sources: Overview](/img/datasource-reference/newui/overview/newpermissions.png)
Authorization to View or Edit permitted data sources from the data source page
Permission | Description |
---|---|
View | Connect to authorized data sources for their user group. Users can't update the credentials of authorized data sources. |
Edit | Users can update the credentials of authorized data sources. |
![Data Sources: Overview](/img/datasource-reference/newui/overview/viewedit.png)