Setting up SPD databases for Spectrum 2019.1 or greater

  • You must be a Spectrum Technology Platform administrator (admin) to perform this task.
  • The Spectrum Technology Platform has Command Line Interface (CLI) commands to install Spectrum data without having to download the data to the Spectrum server or having to connect your Spectrum server to the internet. The CLI commands copy data to the Spectrum server.
Follow this procedure to extract and configure SPD datasets that have not been set up previously.
Note: We recommend setting a location for your Spectrum Product Data (SPD) that is separate from the Spectrum Technology Platform installation folder.

To set up and configure an SPD database:

  1. Update your Spectrum installation with all product updates (patches) available for your release.
  2. Verify the Spectrum Technology Platform server is running before you begin.
  3. Download your Spectrum Product Database (SPD) files from Precisely using the link provided in the Precisely communication or from the Precisely Data Experience (PDX).
  4. In the Administration Utility, open the command-line interface. If you are not familiar with this tool, see "Getting Started with the Administration Utility".
  5. Connect to the Spectrum Technology Platform server by typing this command:
    connect --h servername:port --u username --p password --s SSLtrueFalse
    For example,
    connect --h myserver:8080 --u admin --p myPassword1 --s false
  6. Optionally list the locations of extracted Spectrum Product Data (SPD) files based on product name by typing:
    productdata extract list
    The command output shows the directory where files are located for each product.
  7. Install the data to the Spectrum server by typing:
    productdata install --f fileOrDirectory --w waitOrReturn
    For example,
    productdata install --f E:/Geocoding/filename.spd --w
    If you're installing multiple .spd files, then use the folder path to the files. The command installs the data files that are in the folder and subfolders. For example:
    productdata install --f E:/folderpath/Geocoding --w
  8. Define a database resource for the data in the Management Console; see Creating a Database Resource for more information.