Activate Database Lookup

Activates the caller lookup in the specified database.

Connection String

Insert a database connection string manually.

Connection...

Select a connection from a list of identified databases.

Load from file...

Loads the database connection string from a .udl file.

SQL Query

Specify the SQL query for retrieving information from the database.

SmartCallMonitor expects the following column names. Only then it is able to map the database information to the caller.

It is crucial that the column names in the query conform to the following column names. To achieve that, use the 'AS' keyword in the query (see example below).

To filter the data by caller number, use the placeholder [$CalledNumber$] in the WHERE clause of the query (see example below). Then, on each query, the placeholder is replaced by the caller number .

The following data can be queried from a database:

Example:

SELECT db.users.Id as CustomerId, db.users.Company as CompanyName, db.users.City as CityName, db.users.Mail as Email FROM users WHERE phonenumber like '[$CalledNumber$]'

Test database query...

Opens the window for testing database connection and query.

Force 32-bit Database Process

If an ODBC driver or OLEDB driver for your database is only available in 32-bit, this setting ensures the compatibility of SmartCallMonitor with the driver.

Connection String

String used for the connection to a database.

SQL Query

SQL query for retrieving information from the database.

Test Number

The phone number used for testing the database query.

Send Query

Sends the query to the database with the given configuration.

Apply Settings

Adopts the test settings to the settings dialog.

Close

Closes the window "Database Test".