Connecting to Datasources
Appsmith offers plug-and-play support for many databases and the RESTful API interface for seamless integration with other tools. Whether you're working with a traditional database like MySQL or a more modern tool like S3, Appsmith makes it easy to connect and start working with your data right away. Connecting to a datasource is a necessary step before data can be visualized, transformed, or otherwise utilized.
Appsmith encrypts all your datasource credentials and stores them securely. Appsmith also doesn't store any data returned from your datasources and acts only as a proxy layer to orchestrate the execution of Queries. As Appsmith is an open source framework, you can deploy it on-premise, and audit it to ensure none of your data leaves your VPC. For more information, see Security.
To connect to a datasource,
- Navigate to Explorer
- Click the + icon (next to Datasources)
- Select the datasource.
After creating and configuring a datasource, you can query the datasource and bind the results in the UI to display data.
Datasources configured within an application can be accessed by all the developers who are members of the workspace.