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.
-
To stop the server, right-click the Spectrum™ Technology Platform icon in the
Windows system tray (shown below) and select Stop Spectrum™.
-
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
-
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.
-
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.
-
In the server/bin directory, source the "setup" bourne
shell script to setup the environment by typing the following command:
. ./setup
-
Execute the script for installing the database by typing the following
command:
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:
-
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.
-
After installing the Global Sentry Module database, you must configure a JDBC
connection in the Spectrum™ Technology Platform Management Console.
-
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
-
Log in to the Management Console and configure the
driver and connection properties using these steps:
-
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.
-
Enter your user name and password to access the
Home page of the Management
Console.
-
On the Main Menu, click to open the Drivers page
-
Click Add
-
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}
-
Add this driver file:
<SpectrumPlatformLocation>/GlobalSentryDatabase/lib/hsqldb.jar
-
To define connection properties, go to .
-
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.
-
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
-
Click Test to verify the connection works.
-
Click OK, then click
Save