MSSQL database settings

A typical deployment of NexJ CRM requires the following data sources to be configured with the following properties.

The SessionDatabase is required when using session persistence.

The following data sources are required for a typical deployment with MSSQL database:
  • AuditLogDatabase
  • BI_1_BI_Database
  • call:Call
  • Conversation
  • DefaultRelationalDatabase
  • ecr:ECR
  • flow:Flow
  • LockDatabase
  • msg:Messaging
  • ObjectQueueDatabase
  • rules:Rules
  • SessionDatabase
  • sso:SSO
  • StagingDatabase
  • StatDatabase
  • uicomp:UIComponent

The suggested properties and values are the same for all data sources.

Table 1. Data source settings for a typical MSSQL NexJ CRM deployment
Attribute Value Notes
Data Source datasourcename
Adapter MSSQL Data source adapter.
Host localhost Dababase server host name.
User Database_User_ID The ID used by the application to access the database.
Path jtds-1.2.2-7.jar Name of the JDBC driver JAR file.
Port 1433 Database server port number.
Database Database_Name The name of the database the application will access.
Password Database_Password The password corresponding to the database user ID.