Installing the Global Sentry Module 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 Module and Advanced Matching Module databases to use Global Sentry. For instructions, see Installing Data Normalization Module Databases and Installing the Advanced Matching Module 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. To stop the server, right-click the Spectrum™ Technology Platform icon in the Windows system tray (shown below) and select Stop Spectrum™.
  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. Insert the database DVD or download the database from www.g1.com/support.
    Note: If you download the database from the technical support web site, it will be downloaded 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 the Global Sentry Module 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 bySpectrum™ Technology Platform. By default, the HTTP port is 8080.

    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:
      <SpectrumPlatformLocation>/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:
      • user: sa
      • password: <there is no password>
      • host: localhost or <your server name>
      • port: 9001
      • instance: globalsentrydb
    10. Click Test to verify the connection works.
    11. Click OK, then click Save