Skip Navigation Links.

CDRv5 Client – Database Connectivity and Sharing


image for CDRV5 client database connectivity
CDrv5 Client Database Connectivity Overview

The CDRv5 Client must connect to the four modules of the CDRv5 Server and to the MS-SQL database.

Choosing Database Security (Authentication)

The MS-SQL security model supports Database security, Operating System security or mixed mode (both). Your database administrator (perhaps yourself) setup the security model when the MS-SQL Server was installed. The CDRv5 Client software supports all MS-SQL security models.

However, it is important to understand that the application will use a "mirror” username in its own security model. In other words, the CDRv5 Users table will have a user entry with a user name identical to the OS username. This is the name that is used by the CDRv5 application to manage the application privilege and access. The database can also be shared with other users by adding his/her username in the CDRv5 Database Users table. Nevertheless, the actual database access must also be configured to authorize a user to access the database.

In summary, the security is a two-step process: 1) authorize a domain user to access MS-SQL server using its own security configuration and 2) configuring the CDRv5 Database Users table to allow access to its data.

Database Connectivity Configuration

For database connectivity, click on ‘Home |Database’. Under ‘Database Connectivity’ enter the MS-SQL Database name where the CDRv5 Database was installed. If the database is not yet created, the Connectivity Wizards allows you to create an new CDRv5 Database.

Click on “Test and Reconnect’ to test the configuration parameter. The result will be displayed in the memo box below. This function will interrupt the current database connectivity. If the configuration used during the logon sequence (Home | Logon) uses the OS Authentication method, both ‘Database Server Username’ and ‘Database Server Password’ fields are disabled. Otherwise, you will have to provide these values to test the database connectivity.

The ‘Max Queue Size’ defines the number of CDRs and CPMs that will be stored in-memory before being inserted in the database. This queue is useful during burst periods. You can monitor the CDRs/CPMs volume in the ‘Home | Data Recovery’ page. The ‘Peak’ gauge is useful to optimize this value. In case of doubt, keep the default value of 20,000.

Connecting to and existing database that you do not own

If you wish to connect to a CDRv5 Database owned by another computer, you can follow the exact same procedure. Note that you must provide access to that MS-SQL database using the Windows and MS-SQL security procedures. (Refer to Miscrosoft Windows and MS-SQL references.)

Additionally, the database computer owner must add your Windows username in its CDRv5 User table and give you the desired CDRv5 access privileges. Otherwise, you will not be able to logon or query the database.

Sharing your database with another computer

If your computer is the CDRv5 Database owner and you wish to share your database with another user, you must provide Windows / MS-SQL access to the CDRv5 Database using Microsoft security procedures. (Refer to Microsoft Windows and MS-SQL references.)

Additionally, you need to update the CDRv5 User table to add the username of person you will share your database with and give the desired CDRv5 access privileges. User ‘Home | Roles’ and ‘Home | Users’ to complete this configuration.

Tips

When the mouse cursor hover on the status indicator, the status details will provide additional information. A green indicator shows that database connectivity is working. There are two indicators for the database:
  • The operational database indicator. If your computer is the owner of the CDRv5 Database, this indicator is green if the database is updated in real-time. It is yellow if your computer does not own the CDRv5 Database. It is red if there is a connectivity problem with the database itself or with the CDRv5 Server Data Management module.
  • The query database indicator. The database connection used for queried report will show green for a good connection. Otherwise it is red.


© 2020 Trillys Systems - CDRV5 Web Support