These connection steps are general for Grow's integrations with databases, such as the following:
- SQL Server
- HP Vertica
- Amazon Redshift
How to Connect a Database
Before connecting the database to Grow, you will first need to whitelist Grow's IP Addresses.
Next, you'll need to create a read-only user for your database, and make sure it has the right permissions and access to the tables you want to use in Grow. We only need to read your data; we don't want permissions to edit it. You'll need the username and password for the read-only user later.
To connect the database in Grow, click on the Data tab at the top left of the global navigation. Then click on "Connections" in the Data Library section. Click on the blue "Connect" button and search for the database you want to connect.
In the window that pops up, enter in the following information:
- Connection Name: Can be anything you want to pick in order to help you remember what the connection is. Sometimes this can include the source (for example Amazon) or the type (for example App User Statistics).
- Host: Location of the server you are connected to as a means to access the DB. This is where the DB is located.
- Port: The connection to your DB. We sometimes pre-fill this field with
3306as this is the most commonly used port.
- Database Name: The name was set when you created the database. A lot of people name their original username and database the same.
- Username: Username for the read-only user on your database. You can create this read only user just for Grow.
- Password: This is the password for the read-only user on your database.
(This screenshot shows MySQL, but these are applicable for any database connector in Grow.)
When you've filled the fields in, click the blue "Connect" button.
Keeping Your Data Secure
What we do to increase database security
All of our connections to the app from the browser are forced to HTTPS session with a DigiCert SSL certificate. We use a secure connection (TLS or SSL) when connecting to a database, and the data is encrypted on both ends of the connection.
All of our servers are located on the best-of-class Amazon Web Services.
What you can do to increase database security
- Use a read-only user to connect to Grow. We don’t have anything built into the platform to add or affect data in your database, so there is no reason to have anything more than read-only privileges.
- Only open one port for Grow.
- Whitelist our server IPs so a private database is never left wide open.
- Use a SSH Tunnel to add an extra layer of security.
- Use an identity-based data service.