Installing Data Normalization Module Databases

The Data Normalization Module 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 Module - Base Tables
Open Parser
  • Data Normalization Module - Base Tables
  • Core Names Database
  • Company Names Database
  • Arabic Plus Pack
  • Asian Plus Pack
Table Lookup
  • Data Normalization Module - Base Tables
  • Core Names Database
  • Arabic Plus Pack
  • Asian Plus Pack
  • ZREPLACE (Used by the SAP Module for French address validation)
Note: To install the Data Normalization Module 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. Insert the database DVD or download the database from the the Pitney Bowes eStore. You received a download link with your product release announcement.
    Note: If you download the database from the web site, it will be downloaded as a zip file. Unzip the database before proceeding with the installation.
  4. Select Start > Programs > Pitney Bowes > Spectrum™ Technology Platform > Modules > Data Normalization Module > 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.