Installing Validate Address Loqate Databases

This procedure describes how to install the databases used by the Validate Address Loqate stage. For instructions on installing databases used by other Universal Addressing Module stages, see the Spectrum Technology Platform Administration Guide.
  1. Download your licensed SPD files (xxx.spd) using the link provided in the Pitney Bowes communication or from the Pitney Bowes Software and Data Marketplace (SDM).
  2. The database SPD files are:
    • LQ0 — Contains a separate lib file for the Windows installation of data in the .spd file format. Irrespective of which Windows and non-Windows platform you are using, there will be a different lq0 file (lib file) for these platforms:
      • Win-LQ0_win
      • Linux- LQ0_Linux
      • AIX7.1-LQ0_AIX7.1
      • AIX7.2- LQ0_AIX7.2
      • Solaris-LQ0_Solaris
      • HPUX-LQ0_hpux
    • LQ0/DB_Setup—Contains general database setup files.
      Note: Regardless of which set of data you use, the files in LQ0 must be installed.
    • LQ1-APAC_AFR_ME—Contains the data for Asia-Pacific, Africa, and Middle East.
    • LQ2-Americas—Contains the data for Americas regions.
    • LQ3-Europe—Contains the data for Europe region.
    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.
    You may install databases on a network share, but performance will be affected since you will be accessing them on a network rather than accessing them locally.
  3. The database is downloaded as a .spd file. Install the SPD file:
    1. Place the SPD files at <SpectrumLocation>/server/import. This is the default location for the SPD files. The Spectrum Technology Platform server monitors this folder and looks for new files in two-second intervals. You can change the location of the data import directory by altering the spectrum.import.dir property in this file: <SpectrumLocation>/server/conf/spectrum-container.properties.
    2. When the server detects new SPD files, the server automatically extracts the SPD files to <SpectrumLocation>/server/ref data. You can change the location of the data storage folder by altering the spectrum.data.manager.storage.dir property in the Data Manager settings section of the <SpectrumLocation>/server/conf/spectrum-container.properties file.
    3. By default, the SPD files will be archived in <SpectrumLocation>/server/archive/ref data.
  4. At this point the data will become available and you can add it as a Spectrum™ database resource in the Spectrum™ Databases section of Management Console.