These connection steps are general for Grow's integrations with databases, such as the following:
- SQL Server
- HP Vertica
- Amazon Redshift
So if your database is hosted on one of these platforms, you've come to the right place!
To connect to your database in Grow, you'll first need to go through two steps and then collect some information.
First, you will need to whitelist Grow's IP Addresses, which are found here.
Next, you'll need to create a read-only user for your database. We only want 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.
Once you have done these two steps, you need to collect the following information:
- Connection Nickname: 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.
Once you have this info, we can connect the database.
Go ahead and log into your Grow account, then press Add Metric.
Select your data source and press "Connect" or "Add New Auth," depending on which builder you are using.
Go ahead and fill in the fields for your database connector. (This screenshot shows MySQL, but these are applicable for any database connector in Grow.)
When you've filled the fields in, go ahead and press the blue Submit button.
And that's it! You're good to build metrics.
If you want to use SSH (Secure Shell) there are a few extra steps which can be found here -> How to connect to your DB via SSH.
We know that your data and database are vital to your business. If you have questions about security, read the Security Overview, and check out this article for more database security information.