CDRv5 Client Database Connectivity Overview

The CDRv5 Client must be connected to the Data Management module of the CDRv5 Server and to the MS-SQL database.The Data Management module will create flows of CDRs and CPMs both in real-time and for recovery. The received CDRs and CPMs will flow into the CDRv5 Database.

Choosing Database Security (Authentication)

The MS-SQL security model supports Database security, Operating System security or mixed mode (both). Your database administrator would have 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 their 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 SQL Server Connectivity“ to test SQL Database engine connectivity.

Click on "Test CDRv5 Database Connectivity" to test the existance of the CDRv5 Database on the SQL Database engine. 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.

The database connectivity requires the SQL traffic to flow through the firewalls including the Windows firewall. If you share your database, you may need to setup firewall rules to allow the SQL traffic.

There are two indicators located on the dashboard that reports the status of the connection to the CDRv5 Server DM module and to the SQL database engine.

Connecting to an Existing Database

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. Add the username under "Home > Roles" and "Home > Users" to complete this configuration.

TIP: If you share your CDRv5 Database, consider configuring your CDRv5 Client to "Use Service". Click on "Home > Connectivity > Service" and select "Use Service". If you leave your computer on, even if you exit CDRv5 Client application or logoff, the database will continue to be updated by the background service. This function requires administrative privileges.