Database Configuration

Ecora Auditor Professional requires an external database source, in which all datasets collected are written. Both Windows SQL Server (including MSDE) and Oracle can be configured and used as external database sources. This section of the User Manual describes the setup, creation and configuration of the database source used by Auditor Professional. For more information regarding database archiving and migration, please consult the corresponding sections of this guide.

1. Go to File -> Settings and click on the Database tab.

2. Activate the checkbox if you want to enable the data output Enable Configuration Database output. This writes configuration data into a relational database you select.

3. If you Enable Configuration Database, choose an existing Data Source from the drop-down list or press the Manage Data Sources button to define one.

• You can download MSDE by clicking the Download button. Please be advice that MSDE has a limit of 2Gigs.
  

4. Switch to the Server tab.

• Click the Discovery button and Auditor Pro will scan the network for all available Server Instances. Select the one Auditor Pro will use from the drop-down menu Server Instance.
• Authentication: by default Windows Authentication is enabled. If you want Auditor Pro to connect to the SQL Server using Login and Password please select SQL Server Authentication.

5. Switch to the Database tab.

• Select Create database(default) and specify the database name Auditor Pro will create.

OR

• Select Use existing database if you already have a database created for Auditor Pro to use.
  

6. Click OK to proceed. Auditor Pro will initialize the database and configure it automatically.