Help: Contacts

Looking for personalized help?  Schedule a free one-on-one discussion to discuss ActiveCampaign & your marketing strategy!

Using Database Sync With Amazon RDS

You can use our database sync feature to connect to a MySQL or MSSQL database server hosted on Amazon RDS. We have tested and confirmed this works.

Here are the steps involved:

  1. Create your database instance in Amazon RDS
  2. Allow access to your instance from ActiveCampaign’s servers
  3. Connect to your database instance to create tables and add data
  4. Connect to your database instance through ActiveCampaign’s database sync feature

Create your database instance in Amazon RDS

To get started, first create your database instance in Amazon RDS console. Choose any of the database server options that fit your needs. There is only one MySQL option, and we chose “Microsoft SQL Server Express Edition” for our MSSQL test.

MySQL

MSSQL

Below are the additional settings we applied to the test instances (in case you want to compare).

MySQL

MSSQL

Once the instance is created, and the status shows “Available,” you can connect to it from ActiveCampaign.

Allow access to your instance from ActiveCampaign’s servers

First, though, we have to allow access to our database instance from the ActiveCampaign servers. On the Database Sync page of ActiveCampaign, we list the IP’s you need to whitelist:

In the RDS console, click on “DB Security Groups” on the left side, and add in each IP address:

Connect to your database instance to create tables and add data

Next, let’s create some sample data in the MSSQL database so we can fully test it through ActiveCampaign. You can use any tool you’d like to connect to the database, but if you’re looking for something, we used HeidiSQL to connect from a Windows 7 desktop.

Through the HeidiSQL session manager, add your RDS instance details.

MySQL

MSSQL

You can find your database host at the bottom of the RDS page:

In HeidiSQL, I went ahead and created a new database and table (both named “subscribers”), and added some sample data.

MSSQL

Connect to your database instance through ActiveCampaign’s database sync feature

In ActiveCampaign, add a new database sync using the same connection details from the HeidiSQL client:

A successful connection should appear, and show the table you just created:

Map your fields and you’re all set!

You can save this connection to re-import subscribers from your external database instance at any time.

Connect