Auditor Help: Database Setup

Auditor Professional has the ability to write configuration data directly into a database. An MSDE, Microsoft SQL or Oracle database can be selected (or created) as the data source for the Ecora configuration repository.

To setup / change the database (data source):

  1. Choose File... Settings... from the menu.
  2. Click on the Database tab.
  3. Click in the checkbox for Configuration database output. This writes configuration data into a relational database you select.
  4. Define the Database backend to be utilized by selecting respective radio button in Database backend area, default is Microsoft SQL Server which also includes MSDE.
  5. Choose an existing data source from the drop-down list or press the Manage Data Sources button to define one.
    Settings, Database tab
  6. Click Purge Database to clear the database of configuration data (choose data by module).
  7. Click OK if you selected an existing data source or proceed with data source identification (described below).



If you have chosen to use Oracle as Database backend: 
Database Setup Wizard Oracle

    Warning Warning: Consult the database administrator at your Oracle site to get the information on how to properly install Oracle Client on Auditor system, how to configure a new connection to existing Oracle database, and get the information about Net Service name, utilized protocols and ports, host where Oracle database is installed, and other parameters needed to correcly configure Oracle Client. This must be done before starting Auditor Database configuration procedure.

  1. Specify Oracle Net Service name, as it's stated in installed Oracle client.
  2. Specify correct login name and password to be utilized with defined Oracle Net Service.
  3. Click OK and wait while Auditor database is being initalized.

Helpful Hint Tip: Alternately, click the Advanced... button to use Microsoft's ODBC Data Source Administrator.

Warning Warning: Consult the database administrator at your Oracle site to get the information about correct settings before starting to customize Advanced Settings.



If you have chosen to use Micorosft SQL Server or MSDE as Database backend: 
  1. On the Info tab, click in the radio button to use either an SQL or MSDE database instance.
    Database Setup WizardDatabase Setup Wizard
  2. On the Server tab, enter a server or select one form the drop-down list. This is the server where configuration data will be stored.
    Helpful Hint Tip: Click the Discover Servers button to search the network for available servers. Servers found are added to the drop-down list automatically.
  3. Click in the radio button to use either Windows or SQL authentication methods.
  4. If you chose SQL authentication, enter a login and password.
  5. On the Database tab, click in the radio button to create a new database or use an existing database.
    Database Setup Wizard
  6. If you chose to create a new database, enter a database name and path to the data directory (or use the Browse... button to locate a data directory).
  7. If you chose to use an existing database, select a database from the drop-down list.
  8. Click OK.

Helpful Hint Tip: Alternately, click the Advanced... button to use Microsoft's ODBC Data Source Administrator.

Resource See also Writing (Existing) Data Sets to the Database.

Resource See also this Microsoft article on checking connectivity.