Creating new required data sources for version 8.8

If you are upgrading from NexJ Contact version 6.X, you must create three new data sources.

The new required data sources are:
  • AuditLogDatabase
  • LockDatabase
  • ObjectQueueDatabase
Note: While deployment specialists create the databases, developers must be aware of the new data sources before deploy time to avoid issues when testing the system in a local environment.

Before beginning this task, follow the instructions in Adding new connections for version 8.8 to define the new data source connections and new related SOA connections for your deployment.

After you define the data source connections for your deployment, you need to create the tables to store the information in the default relational database. In a production environment, use the Database Schema Tool in NexJ Studio to generate the SQL scripts to create the tables, then provide the scripts to database administrators who have appropriate database access.

In test or development environments, if you have the appropriate access, you might be able to use the Data Load Tool to issue the recreate command directly to the database.

To create new data sources for supporting new NexJ CRM functionality:

  1. In NexJ Studio, click the down arrow beside the Run Tool button and select Database Schema Tool.
  2. Complete the Database Schema Tool dialog as required.
    Ensure you specify the following information:
    • In the Command field, select create - generate an SQL script for creating the schema.
    • In the Data Source field, select AuditLogDatabase.
  3. Click Run.
  4. After the dialog closes and the script file is generated, click the down arrow next to the Run Tool button and select Database Schema Tool.
  5. Repeat steps 2 and 3 for the remaining data sources.
    Issue the create command for the following data sources:
    • AuditLogDatabase
    • LockDatabase
    • ObjectQueueDatabase
  6. Provide the scripts to a database administrator who has appropriate permissions to modify the databases.
    The administrator should run the scripts for the applicable databases.
The new data sources are created. After NexJ CRM is deployed, data related to the new functionality is stored in the tables in the default relational database.