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.
- Stop the Spectrum Technology Platform server.
-
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
-
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.
-
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
-
Run 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: -
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 Global Sentry 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: