Setting up a MySQL Database Connection

This guide is a basic walkthrough for setting up a standard connection to a MySQL database to access your data warehouse. These instructions apply regardless of which cloud environment is hosting your database, as long as your Accelerator instance has access to that cloud environment.

1. Finding Your Database Connections
2. Connecting to your MySQL Database
3. Understanding Connection Parameters

1. Finding your Database Connections

To start, navigate to Admin > Data > Database Connections:

2. Connecting to your MySQL Database

To create a new database connection, select Create Connection. Then in Database Type, select MySQL and fill out the required connection parameters:

3. Database Connection Definitions

• Name: The name you want to give your new connection, referenced within the MessageGears UI.
• Database Type: Database Types include: MySQL, Oracle, PostgreSQL, Amazon Redshift, Amazon Redshift (Native), SQL Server, Vertica, Teradata, Salesforce.com, Snowflake, Snowflake (Native), Hadoop (via Hive Driver), Hadoop (via Impala Driver), Google BigQuery, Google BigQuery (Native), and DynamoDB.
• Host Name: The URL/data source that your data will be pulled from.
• Port: The Port number this Database will connect to. The standard MySQL port is 3306. 
• User Name: The username for this database connection. We suggest creating a new user for this connection to your data, to better monitor how MessageGears is querying and interacting with your database
• Password: The password for this connection
• Purposes: The way that MessageGears is going to make use of this connection. These include: Audience, Supplemental (formerly Context) Data, Campaign Trigger, Real-Time Data Feed, and Audience Recording
  Saving and Testing the Connection

Once you've filled out all connection parameters, you can either select Create to save the connection or Test Connection. Testing the connection does not overwrite or delete the information if it fails, so there is no risk of losing any settings by running a test.

For more information about how MessageGears connects to your data and to learn how to enable connection defaults, see Adding and Managing Database Connections.