SQL Server
By connecting SQL Server database to Hops, all team members can use the database in their workflows.
Connection Method
Hops uses fixed IP addresses when accessing your database.
If you manage a list of IPs that can access your database through a firewall, please add the following IPs to your allowlist:
34.47.79.49, 34.47.86.94
Log into Hops and click the data source button on the left.
Click the add new data source button at the bottom left.
Select SQL Server from the data source types.
Enter Connection Information
Enter the required information to connect to the SQL Server data source.
Please refer to the table below for detailed descriptions of the required information.
| Property | Description |
|---|---|
| Data Source Alias | Enter an easily recognizable name for other team members. This is the display name in Hops, different from the database name required for connection. |
| Host | The database host information. Enter an IP address or domain name. Make sure not to include special characters like @ or :. |
| Instance | Enter the database instance name. If not specified, connection will be made to the default instance. For more details about instances, refer to: SQL Server Database Engine Instances |
| Port | Enter the database port number. If not specified, port 1433 will be used by default. |
| Database User | Enter the username for database connection. If you want to add a new account, please refer to: SQL Server Create Database User |
| Database Password | Enter the password for database connection. Database connection information is securely encrypted. |
| Database Name | Enter the name of the database you want to connect to. You can check database names through: View a List of Databases in SQL Server |
| SSH Tunneling Host | If you're using SSH tunneling, enter the bastion host address. |
| SSH Public Key | The public key to be added to the bastion's authorized_keys file. |
Having trouble because you don't have the required information to connect to the database?
Contact us by email (contact@hopsoffice.com) and
we'll help you through remote support.
Connection Test
Click the connection test button to verify the connection.
When the connection succeeds, the connection test button changes to a connection success button.
Once you've entered all connection information and the connection test succeeds, you can click the add button to add the data source.
Having trouble with failed database connections?
Contact us by email (contact@hopsoffice.com) and
we'll help you through remote support.
Using in Workflows
After adding the SQL Server data source, all team members can access the added data source in workflows.
