Databases

Databases

The database settings dialog helps you add or edit database connection details. LogViewPlus will use the details provided to read and display the log entries contains in the database.

To find out more about how database columns are mapped to LogViewPlus columns, please see Column Mapping.

1

Source Name

1. Source Name

This is a friendly name used to describe this database connection. If not provided, the table name will be used as a default.

2

Friendly Category

2. Friendly Category

A friendly category is a group name where this database connection can be categorized. This field is not required.

If you have previously configured a server with a friendly category, this category will be available as a drop-down option. Alternatively you can type a new name into the category text box.

3

Database Type

3. Database Type

The database connection type. By default, LogViewPlus supports SQL Server, Oracle, My SQL, OLE DB, and ODBC database connections. If you have an additional database you would like to connect to that has a .Net adapter, please contact support for assistance.

4

Allow Tail

4. Allow Tail

By default, tail is disabled for database connections. Tailing a database table is supported, but we do not recommend it. Tailing a database table requires sorting the table by timestamp to find the latest records. This query will need to be executed approximately every second as LogViewPlus continuously checks for new updates. For large database tables, or where the table is not indexed by timestamp, this could lead to a significant performance impact on your database. This performance impact would apply to the entire database which might impact unrelated tables and queries.

5

Connection String

5. Connection String

The connection string contains the details needed to communicate with your database. Creating connection strings can be difficult if you are not familiar with the concept and, unfortunately, this is one area where our support will not be very helpful. If you are having trouble creating a valid connection string, we recommend contacting your database administrator. Alternatively, connectionstrings.com is a great resource.

If you need to encrypt aspects of your connection string, please see the Password field below.

6

Password

6. Password

The password field can be used to encrypt any part of your connection string. To do this, you need to do two things:

1. Take the sensitive string out of your connection string and put it into the password field.

2. Where the string used to exist, add the template: ${Password}

The text in the password field will be stored encrypted by LogViewPlus. When needed, it will be automatically decrypted and used to replace the ${Password} template in the connection string.

7

Table Name

7. Table Name

The name of the table that contains the log entries you want to load.

8

Test

8. Test

The test command can be used to verify the currently configured database connection. To do this, it connection with the database will be established. No other actions will be executed.

9

Save / Cancel

9. Save / Cancel

Once you have configured your database, you can use the save command to persist your changes. Once your changes have been saved the configured database will be immediately available in the folder tree view.

Use the "Cancel" command to return to LogViewPlus without saving your changes.

< >