Installing Data Normalization Databases

Data Normalization provides a load utility to install databases for the Advanced Transformer, Open Parser, and Table Lookup components. The database files that you install depend on the databases you have licensed. Use this list of database tables to determine which files you should download and install. For more information about tables contained in each database, refer to the reference documentation for each component.

Stage Available Databases
Advanced Transformer Data Normalization - Base Tables
Open Parser
  • Data Normalization - Base Tables
  • Core Names Database
  • Company Names Database
  • Arabic Plus Pack
  • Asian Plus Pack
Table Lookup
  • Data Normalization - Base Tables
  • Core Names Database
  • Arabic Plus Pack
  • Asian Plus Pack
  • ZREPLACE (Used by the SAP for French address validation)
Note: To install Data Normalization databases on Windows Server 2008 you need administrator privileges.
  1. Make sure no applications are running.
  2. Stop Spectrum Technology Platform. To do this, right-click the Spectrum Technology Platform icon in the Windows task bar and select Stop Server.
  3. 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.
  4. Select Start > Programs > Precisely > Spectrum Technology Platform > Modules > Data Normalization > Data Normalization Database Load Utility.
  5. 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.
  6. Start Spectrum Technology Platform. To do this, right-click the Spectrum Technology Platform icon in the Windows task bar and select Start Server.