The fastest way to get the most out of Count is to connect your SQL database. This article walks through everything you'll need to set-up your database connection.
What you'll need
Before you set up your database integration, there are a few things you'll need to gather:
- database credentials and connection details
- the ability to specify white-listed IP addresses, or create a user account with the appropriate permissions
We recommend you invite a member of your team that has access to these details if you do not.
When creating in integration you are creating a connection between Count and your database. When the data is first imported, and again whenever it is refreshed, the tables you have selected will be updated in the Count system as the latest snapshot of that data.
All queries created in Count are run on our servers and therefore you will not be charged any additional query fees for what you create in Count.
We do not currently support running Count remotely on your database.
Create an Integration
- From your Project homepage, navigate to the Data tab
- Click "Add Data"
- Click Database/API
- Click the type of database you want to connect
- Follow the on-screen instructions
We require that all connected databases use SSL to ensure encrypted communication between client (Count) and server (your database). For some managed databases, e.g. RDS on AWS, this is taken care of for you and you'll be able to connect using SSL by default. For other managed databases and manually deployed database servers, you'll need to upload the root certificate or certificate authority (CA) yourself. Please refer to your database documentation for how to obtain this file.
For BigQuery please use the roles
bigquery.dataViewer when creating the service account.
Specify your Integration Details
Once the connection to your database has been established, you can:
- Chose the tables you want to import by clicking the Table tab
- Set the refresh frequency
See our Data Security page for more details.