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
- Open
OutboundEmail.xmllocated by default in the config subdirectory of your Content Manager root location in a plain-text editor or XML editor. - 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> - Specify the following settings:
Element Description 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. Note: You created this database during installation.NameThe name of the database you created, by default tridion_cm_email (for Microsoft SQL Server) or TMSDBUser(for Oracle).UserThe name of the database user you created, by default TMSDBUser. PasswordThe password of the database user you created. For more information, see Encrypting sensitive strings for Audience Manager. 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. TransactionTimeoutThe time, in seconds, a transaction in the database will timeout. If you experience transaction timeouts, increase the default of 1200 (20 minutes).
- Save and close
OutboundEmail.xml.