Table of Contents

Data Provider Properties

The Data Provider Properties view enables you to view and modify a Data Provider's settings.

To view or modify a Data Provider:

  • From the Explorer view, navigate to the Data Provider you want to view or modify.
  • Right-click and select Properties. The Data Provider Properties View displays.
  • Use the Name text box to specify a unique name.
    Information Click the Auto Generate Auto Generate Name Button button to automatically generate a name. If you click this button after you have set the data provider settings, the generated name reflects the settings you have selected (e.g. Primary Log Database (SQL Server)).
  • Use the Type Drop-Down to select the database type. The following Types are available:
    TypeDescription
    File SystemA proprietary Corner Bowl Software developed binary flat file system.
    SQLiteA self-contained open-source SQL database engine.
    Microsoft SQL ServerMicrosoft SQL Server v2022-2012.
    MySQLOracle MySQL v5.7-8
  • Use the Role Drop-Down to select how you would like to use the database. The following Roles are available:
    RoleDescription
    Log DatabaseContains the latest consolidated log entries. (e.g. log entries less than 15 days old).
    Archive Log DatabaseContains archived consolidated log entries previously saved to the Log Database (e.g. log entries 15 days and older).
    Auxiliary Log DatabaseContains auxiliary or backup consolidated logs. Typically used to view old database backups for auditing purposes.
    History DatabaseOnly available when using the File System. Contains monitor and report execution history (e.g. execution time, state, and results such as the number of entries downloaded).
    NoneThis setting has two purposes. First, to be used for Database Monitoring. Second, to be used to maintaining database connection settings for later use.
  • Use the rest of the controls to set the Type specific settings. For more information see:
  • Click the Save button to save the settings.
    Information When saving a Log Database or Log Archive Database, if the database does not exist, the database and several tables are automatically created.
  • Click Delete to permanently delete this object.
    Alert Log Database and Archive Log Database objects cannot be deleted.

Related Topics

Data Providers

Corner Bowl File System Properties

SQLite Properties

SQL Server Properties

MySQL Properties

Database Monitoring Templates