Using uploadcdh with multiple systems

The uploadcdh program can be used to upload CDH data from multiple systems into a single database. The uploadcdh is called from the croncdh cron job. To use uploadcdh this way, do the following:

1. If the CDH database is from a CONVERSANT system, do the following to adjust the table in preparation for upload:
   • Create a backup of the database.
   • Drop all of the CDH tables from the database. The uploadcdh script will create the tables with the correct fields before it uploads the CDH data.
2. For each system that will connect to the database, create a user for the database and grant the user the following permissions:
   • Connect
   • Create tables
   • Create an index
   • Insert records
3. For each system that will connect to the database, set up the File CDH or the Database CDH configuration with the newly created username and password, as described in the following steps.
4. If you are using File CDH:
   • From the JDBC Administration - Main screen, click the name of the DBDIP you want to use for uploading.
   • On the JDBC Administration - Edit screen, configure the DBDIP and specify the newly created username and password.
   • From the JDBC Administration - Main screen, click File CDH.
   • On the JDBC Administration - Edit screen, select the DBDIP to use for uploading and specify the datapath for writing CDH data.
   • See Configuring File CDH for a local text file, Configuring File CDH for a local Oracle database, or Configuring File CDH for a remote database for more information.
5. If you are using Database CDH:
   • Supply the new user and password information in the Web admin screen.
   • Restart the Database CDH.
   • See Configuring Database CDH for a local Oracle database for more information.

© 2006 Avaya Inc. All Rights Reserved.