Installing the Global Sentry Module Database

The following databases are required to run Global Sentry in real-time mode:
  • globalsentrydb.script
  • globalsentrydb.properties
The following databases are required to run Global Sentry in batch mode:

In addition, you must install the Data Normalization Module databases to use Global Sentry. For instructions, see Installing Data Normalization Module Databases.

  1. Open the Windows services control panel and stop the service Global Sentry Database Server.
  2. Stop Spectrum™ Technology Platform. To do this, right-click the Spectrum™ Technology Platform icon in the Windows task bar and select Stop Server.
  3. Insert the database DVD or download the database from the technical support web site, www.g1.com/support.
    Note: If you download the database from the Pitney Bowes web site, it will be downloaded as a zip file. Unzip the database before proceeding with the installation.
  4. Select Start > Programs > Pitney Bowes > Spectrum™ Technology Platform > Modules > Global Sentry Module > Database Load Utility.
  5. Follow the prompts during the rest of the installation process.
    Note: You may install databases on a mapped drive, but performance will be affected since you will be accessing them on a network rather than accessing them locally.
  6. Start Spectrum™ Technology Platform. To do this, right-click the Spectrum™ Technology Platform icon in the Windows task bar and select Start Server.
  7. Open the Windows services control panel and start the service Global Sentry Database Server.
  8. After installing the Global Sentry Module database, you must add a driver and configure a JDBC connection in the Spectrum™ Technology Platform Management Console. Go to Start > Settings > Control Panel > Administrative Tools > Services to verify that the Global Sentry Database is running.
  9. Open Management Console.
  10. Go to Resources > Data Sources.
  11. Click the Drivers tab and then the Add button .
  12. Type the JDBC properties in the applicable text box:
    • Name: HSQLDB
    • JDBC driver class name: org.hsqldb.jdbcDriver
    • Connection string template: jdbc:hsqldb:hsql://${host}:${port}/${instance}
  13. Click Add in Connection properties and add the following information:
  14. Type "User" in both the Label and the Property Token fields.
  15. Click Add in Driver files and add the following driver file:
    file:<SpectrumPlatformLocation>/GlobalSentryDatabase/lib/hsqldb.jar
  16. Click Save.
  17. Select driver for the type of database you want to connect to in the JDBC driver field.

    Spectrum™ Technology Platform comes with JDBC drivers for SQL Server and Oracle databases. If you want to connect to a different database type, you must define a JDBC driver before configuring the database connection.

  18. In the Host field, enter the host name or IP address of the database server.
  19. In the Port field, enter the network port to use for communication with the database server.
  20. If required by the database, enter the appropriate information in the Instance, Username, and Password fields.
  21. Click Save.
  22. Click the Test button to test the connection.
  23. Under Resources, click Data Sources. Be sure the Connections tab is enabled.
  24. Click Add.
  25. Define the following connection properties:
    • Connection name: Global Sentry
    • JDBC driver: select the HSQLDB Sever driver that you created in the previous steps.
  26. Enter the following values to complete the connection:
    • host: localhost or <your server name>
    • port: 9001
    • instance: globalsentrydb
    • username: sa
  27. Click Test to verify the connection works.
  28. Click Save.