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.
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.
-
Insert the database DVD or download the database from the technical support web
site.
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.
-
Select .
-
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.
-
Start Spectrum™ Technology Platform. To do this, right-click the Spectrum™ Technology Platform icon in the Windows task bar and select
Start Server.
-
After installing the Global Sentry Module database, you must configure a JDBC
connection in the Spectrum™ Technology Platform Management Console. Go to to verify that the Global Sentry Database is
running.
-
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:
- host: localhost or <your server name>
- port: 9001
- instance: globalsentrydb
-
Click Test to verify the connection works.
-
Click OK, then click
Save