How to connect to an external database
In Vero Connect you can connect to your databases and data warehouses, write and run SQL and PostgreSQL queries against them, and then use the results of the query to generate an audience (list of users) to send your newsletter to. Your database connections are referred to as Data Sources in Vero, each data source can be used in different ways depending on the connection type.
Currently supported databases
The following databases are officially supported:
- PostgreSQL (9.6+)
- Amazon AWS Redshift (1.0+)
At the moment we support PostgreSQL-style databases and it’s possible configurations outside of the above may work. That said, we currently only provide support for the databases listed above.
We will be adding support for more database and data stores in the future, please let us know what you would like to see us support on feedback.getvero.com/newsletters.
Adding your database credentials
To add an external database, click Data Sources and Add Data Source. In the menu that appears, choose the database you want to add:
To add a database you will need the following credentials:
- Host. The web or IP address of the database.
- Port. The port that is accepting connections (e.g. typically 5432 for PostgreSQL).
- Database name. The name of the database to connect to.
Vero will only execute
SELECT queries against your database. It is read only by design. That said, we would recommend creating a user login that only has read access to your database. Vero will show users all available tables when using the SQL editor in our UI. Limiting the tables and columns that Vero has access to is good security practice.
Choosing a database connection method
Vero currently only supports direct connections. We are working to add alternative connection methods.
Direct connect with IP whitelisting
Vero will connect directly to your database over the public internet. This approach requires your network and database to be configured to allow Vero’s servers to connect to it.
In order to use Direct Connect, your database must:
- Be publicly accessible over the internet
- Be allowed to accept incoming connections from our IP addresses (listed below)
We would recommend whitelisting access to your database via a single IP address. Vero will always make queries via the following IP address:
Testing your connection
Once you’ve entered your database credentials, select Connect. Vero will automatically test the connection:
If there is a problem connecting to your database, please check your database credentials are correct and try again.
After successfully connecting your first data source, it can be used in any Newsletter to define an audience. Read about using SQL queries to generate an audience.
Vero will show your query results in blocks of 100 in the UI. In order to load an audience you will need to load your entire query (without a
There is no technical limit to the number of rows you can query using Vero’s UI but we have currently tested up to one million rows consistently.
Vero will currently timeout queries after 12 hours.