Installing Global Sentry Database

These databases are required to run Global Sentry in real-time mode:
  • ofac.db
  • pep.db
  • sanctions.db
These files are required to run Global Sentry in batch mode:
  • globalsentrydb.addresses-ofac.csv
  • globalsentrydb.fullNames-ofac.csv
  • globalsentrydb.ids-ofac.csv
  • globalsentrydb.names-ofac.csv
  • globalsentrydb.addresses-pep.csv
  • globalsentrydb.fullNames-pep.csv
  • globalsentrydb.ids-pep.csv
  • globalsentrydb.names-pep.csv
  • globalsentrydb.addresses-sanctions.csv
  • globalsentrydb.fullNames-sanctions.csv
  • globalsentrydb.ids-sanctions.csv
  • globalsentrydb.names-sanctions.csv

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

If you have Oracle environment variables set in your profile, these environment variables may interfere with DVD database loading processes. If you experience database loading problems and are using Oracle, check that the Oracle environment variables are not active when you perform the DVD database loads.

Ensure the Global Sentry Database Server is in up and running. In case it is not, use the option in the utility to start it before you begin data loading.
Note: You need to perform data loading after every upgrade of Spectrum Technology Platform.
  1. Stop the Spectrum Technology Platform server.
  2. Make sure that Spectrum Technology Platform is stopped. To stop Spectrum Technology Platform, change the working directory to the bin directory of where Spectrum Technology Platform is installed, then type the following command:
    ./server.stop
  3. Download your Spectrum Product Database (SPD) format files from Precisely using the link provided in the Precisely communication.
    Note: The data downloads as a zip file. Unzip the database before proceeding with the installation.
  4. If you are installing from DVD and your system does not auto-mount, issue the appropriate mount command to indicate that the DVD device is a file system. If necessary, issue the /etc/filesystem command to update your system so that it recognizes this file system. Specify the correct device name for the DVD device on your system.
    Note: Your system must allow DVDs created under the ISO 9660 format to be mounted as a file system.
  5. In the server/bin directory, source the "setup" bourne shell script to setup the environment by typing the following command:
    . ./setup
  6. Execute the script for installing the database by typing the following command:

    ./installdb_ois

    Note: It is mandatory to maintain all the CSV and DB files in a correct folder structure. The ofac, pep, and sanctions folder should have their respective DB and four CSV files, and all these should be in one root folder (which you can name according to your convention and convenience). An example of the folder hierarchy is depicted below with GlobalSentryDatabaseFiles as the root folder:

  7. Follow the prompts as the script verifies your environment and database location.
    Note: You may install databases on a network drive, but performance will be affected since you will be accessing them on a network rather than accessing them locally.
  8. After installing Global Sentry database, you must configure a JDBC connection in the Spectrum Technology Platform Management Console.
  9. Start Spectrum Technology Platform. To start Spectrum Technology Platform, change the working directory to the bin directory of where Spectrum Technology Platform is installed, then type the following command:
    ./server.start
  10. Log in to the Management Console and configure the driver and connection properties using these steps:
    1. In a web browser go to this URL:

      http://server:port/managementconsole

      Where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port used by Spectrum Technology Platform. By default, the HTTP port is 8080 and the HTTPS port is 8443.

    2. Enter your user name and password to access the Home page of the Management Console.
    3. On the Main Menu, click Systems > Drivers to open the Drivers page
    4. Click Add
    5. Type these JDBC properties in the applicable text boxes:
      • JDBC driver configuration name: HSQLDB
      • JDBC driver class name: org.hsqldb.jdbcDriver
      • Connection string template: jdbc:hsqldb:hsql://${host}:${port}/${instance}
    6. Add this driver file:
      SpectrumDirectory/GlobalSentryDatabase/lib/hsqldb.jar
    7. To define connection properties, go to Resources > Data Sources.
    8. Click Add, and define these connection properties:
      • Connection name: Global Sentry
      • Database driver: select the HSQLDB JDBC driver that you created in the previous steps.
    9. Enter these values in the Connection Properties dialog box:
      • host: localhost or server name
      • port: 9001
      • instance: globalsentrydb
    10. Click Test to verify the connection works.
    11. Click OK, then click Save