When working with Database Connections it's important to remember that they must be configured before an Audience can be created. Database Connections are the settings and credentials that allow Accelerator to connect to the database that holds the necessary customer data.
|Read more about the Accelerator Admin section here.|
The following step-by-step process will walk you through the creation and management of a New Database Connection:
Step 1: Create Database Connections by Navigating to Admin → Database Connections
Step 2: Check for Existing Database Connections in Accelerator
a. Open Database Connections to view any existing Database Connections within the Accelerator system. Clicking on an existing connection displays the setup of that Database Connection in a side window.
b. Select the three dots to expand the Actions menu. This contains options to Test, Duplicate, Archive, or Delete a connection.
c. Select the Pencil icon beneath the Action Menu to edit the configuration of an existing Database Connection.
To create a new Database Connection, click the Create Connection button in the top right of the screen.
Step 3: Field Data Input
Fill out the following fields:
Name - A descriptive name for the Database Connection. This name will display throughout Accelerator anytime a User can select a Database Connection.
Database Type - Select the type of Database that this connection accesses. Accelerator can connect to any database with a JDBC connector. Selecting a Database Type can display additional configuration options.
Host Name - The host name of the database server.
Port Number - the port number that Accelerator will access the database server.
User Name and Password - The credentials used by Accelerator to access the database.
Purposes - Accessible after selecting a Database Type. The Purposes is a series of checkboxes to control in what situations a Database Connection can be selected. For Example, checking the Audience checkbox allows the Database Connection to be used when creating an Audience.
Advanced Options may be configured by toggling the Enable Defaults & Advanced Options option.
Setting a Database Connection as the default by toggling the Make this my default connection option. Making a connection the default means that it will be automatically selected (when applicable) when creating new items within Accelerator. Users can select different Database Connections from the Default if desired.
After selecting a database type, default columns will display. Please note that the default columns may differ between database types. For example, Redshift will also have a Default Catalog field, which should correspond to the database name.
Use these fields to set default values for customer data. This is especially important when using a database connection for Audience use.
The Channel Defaults fields only need to be populated if the Database Connection is used to contact customers through Push Notifications. Populate the columns that hold the necessary Push values.