Configuring the Audience Manager database

The <Database> section of the configuration file OutboundEmail.xml allows you to specify database connection properties. Note that when you run the installer, you are prompted to provide database details to set these configurations automatically.

Procedure

  1. Open OutboundEmail.xml located by default in the config subdirectory of your Content Manager root location in a plain-text editor or XML editor.
  2. Locate the <Database> section, for example:
    <Database>
    	<Type>Oracle</Type>
    	<Server>orcl11g</Server>
    	<Name>tridion_cm_email</Name>
    	<User>tmsdbuser</User>
    	<Password>tridion</Password>
    	<Timeout>30</Timeout>
    	<GetContactsTimeout>30</GetContactsTimeout>
    	<LongQueryTimeout>120</LongQueryTimeout>
    	<ImportTimeout>300</ImportTimeout>
    	<QueueMailingTimeout>300</QueueMailingTimeout>
    	<TransactionTimeout>1200</TransactionTimeout>
    </Database>
  3. Specify the following settings:
    ElementDescription
    TypeThe type of Outbound E-mail database you installed. Specify one of the following values:
    • mssql
    • oracle
    ServerThe server where the database is located. Specify (local) if the database is running on the same machine as the Outbound E-mail Web site.
    NameThe name of the database you created, by default tridion_cm_email.
    UserThe name of the database user you created, by default TMSDBUser. For more information, see Encrypting sensitive strings for Audience Manager
    PasswordThe password of the database user you created.
    TimeoutThe default time, in seconds, a database connection is allowed to be open for general database requests and all other timeouts if not configured. If this time is exceeded, the connection is closed.
    GetContactsTimeout(Optional) The time, in seconds, a database connection is allowed to be open when getting lists of Contacts.
    LongQueryTimeout(Optional) The time, in seconds, a database connection is allowed to be open when performing miscellaneous heavy operations such as deleting an Address Book, copying Contacts to a Static Distribution List, refreshing statistics, and so on. If this time is exceeded, the connection is closed.
    ImportTimeout(Optional) The time, in seconds, a database connection is allowed to be open when importing Contacts or Keywords. If the time limit is exceeded and the connection is closed, import fails.
    QueueMailingTimeout(Optional) The time, in seconds, a database connection is allowed to be open when queuing a Mailing and getting the number count of Contacts to queue for a Mailing. If the time limit is exceeded and the connection is closed, the Mailing is not sent.
    TransactionTimeout

    The time, in seconds, a transaction in the database will timeout. If you experience transaction timeouts, increase the default of 1200 (20 minutes).

  4. Save and close OutboundEmail.xml.