To add a SQL Connection, go to the Connections page which is accessed via Menu -> Connected Data -> Connections.
NOTE: SQL connections are only available on Premium accounts.
You must be an Administrator level user to see this option.
- Click the ADD CONNECTION button on the top right of the page to add a new connection.
This will bring up a list of connections that you can choose from.
- Click on SQL Server
- Add the SQL Server Connection String to be used by connectors to access your database.
Learn more about SQL Server Connection Strings here
NOTE: Windows Authentication is NOT supported; you must include username and password credentials in the string.
The SQL user specified MUST have at least db_ddladmin and db_datawriter database-level rolesassigned.
For simplest configuration, grant db_owner role to the user.
IMPORTANT: You must configure your database firewall to accept connections from our cloud servers
- For Amazon RDS, see this article on how to add our cloud IPs to your RDS firewall
- For Microsoft Azure, you can follow this article to configure your Azure SQL firewall
Click the SAVE button on the top right of the page to store your configuration.