Database

<< Click to Display Table of Contents >>

Navigation:  Settings > Caller Lookup >

Database

 

Activate

Activate Database Lookup

Activates the caller lookup in the specified database.

 

Database Connection

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

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:

Information

Placeholder

first name

FirstName

last name

LastName

company name

CompanyName

customer id

CustomerId

email

Email

phone number

PhoneNumber

street

Street

postal code

PostalCode

city

CityName

country

Country

 

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.

 

Compatibility

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.

 

Window "Database Test"

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".