The Audience > Database Connections page is where the foundations for managing audiences are established. Database Administrators can establish, test, change, or delete database server connections as needed, and all connected databases will be listed on the Connections page. Database Connections are used to retrieve and build recipient mailing lists, extract relevant context data to include with your templates, and map event results directly back to your database.
You can define as many connections as needed, create read or write connections based on user permissions, indicate a default database for the Account, and connect to a variety of database types.
Selecting the Add Connection button opens a page to fill out with details and credentials related to the database. Accelerator supports any database with a JDBC connector, including, but not limited to, the following: DB2, MySQL, Oracle, PostgreSQL, Amazon Redshift, Microsoft SQL Server, Google BigQuery, Apache Hadoop, Snowflake, and Teradata. Additionally, Salesforce integration is also supported.
To add a database connection:
- Enter a unique and meaningful Name for the new data warehouse.
- Select the appropriate Database Type.
- Enter the Host Name of the database server.
- Enter the Port number associated with the server.
- (optional) Enter the name of default database.
- (optional) Enter the User ID and Password.
- (optional) Click Add Property to indicate property names and values that you want to automatically associate with this connection.
- Click Save.
Clicking the name of a particular database from the Database Connections list opens the details of that connection, including the properties in place for that database as well as all queries using that database.
Using the Actions menu, it’s possible to Duplicate, Archive, Edit, or Delete a Database Connection.