Articles in this section

Setting up a MySQL Database Connection

This guide will provide you with a basic walkthrough for setting up a standard connection to a MySQL database in order to access your data warehouse. These instructions will apply regardless of which cloud your database is located inside of, as long as your instance has access to that cloud environment.

 

Step 1: Finding Your Database Connections

Step 2: Connecting to your MySQL Database

Step 3: Understanding Connection Parameters

 

Finding your Database Connections

To begin, navigate to the Admin tab in the left panel and select Database Connections from the dropdown under the 'Data' Sub-section:

 

 

Connecting to your MySQL Database

Clicking on 'Create Connection' will bring up the database connection dialog. Select 'MySQL' and fill out the required connection parameters:

 

 

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, 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 Save your Connection or Test  the Connection. Testing the connection will not overwrite or delete the information if it fails, so there is no risk of losing any settings by running a test.

 

You can read more about how MessageGears connects to your data and learn how to enable connection defaults here.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.