Audit Database Settings

When you run the Server Setup wizard, you are offered the opportunity to enable auditing and reporting and configure the connection information. If you chose to do that later or if you want to edit the database information, you can do so on the Logs tab in the Audit Database Settings area.

To enable and configure auditing and reporting

  1. In the administration interface, connect to EFT and click the Server tab.

  2. On the Server tab, click the Server node you want to configure.

  3. In the right pane, click the Logs tab.

  4. In the Audit Database Settings area, select the Enable Auditing and Reporting check box to enable communication with the database; clear the check box to disable auditing and reporting.

  5. In the Database type area, select SQL Server or Oracle. (Oracle is available in EFT Enterprise only.)

  6. In the Database host address[\Instance Name] box, specify the host or database instance name of the database to which you want EFT to connect, or provide a DSN or DSN-less connection string. Refer to Establishing a System Data Source Name (DSN) or Using a DSN-Less Connection with ODBC Authentication, if you are using ODBC Authentication for your Site.

  7. In the Database Name box, provide the name of the database or leave the box empty if you provided a connection string in the Database host address[\Instance Name] box.

  8. For SQL Server databases, in the Authentication box, specify whether the database is to use Windows Authentication or SQL Server Authentication. If the database is using Windows Authentication, the EFT Insight server service needs to run as a Windows user with permission to access the database.

  9. In the Database username and Password boxes, provide the username and password needed to connect to the database or leave the box empty if you provided a connection string in the Database host address[\Instance Name] box or if you are using Windows Authentication.

  10. Next to Diagnostic Logging Settings, click Configure.

  11. In the When a database error occurs area, specify whether you want to audit database errors to a folder:

  12. To automatically try to reconnect after an error occurs, select the Attempt to reconnect every check box and specify the frequency in seconds, from once every 7 seconds to once every 86,400 seconds (once per day).

  13. In the E-mail notification area, select the On disconnect check box and/or the On reconnect check box, and then in Recipient list specify one or more e-mail addresses that you want to receive error notifications in case of database failure. Multiple e-mail addresses must be separated by semicolons (;). When auditing is enabled, this e-mail is sent any time that EFT cannot reach the database.

  14. If you make any changes to the database audit settings, click Apply to save the changes on EFT.

  15. To verify the connection information, click Test Connection. The status of the database connection appears above the Reconnect button. If the database is not connected, click Reconnect to reconnect to the database.