Updating a Spectrum Database - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
How Do I
Reference
Overview
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552

Spectrum databases contain reference data that some modules use to validate or enhance your data. Examples of Spectrum databases include the postal database used by Spectrum Universal Addressing and the geocoding databases used by Spectrum Geocoding modules. Spectrum databases need to be updated on a regular basis to ensure that you have the latest reference data. When it comes time to update a Spectrum database, you want to be confident that the update will go smoothly and not disrupt your operations.

To accomplish a smooth update, you need to know which processes are using the old database. If you know which processes are using the old database, you can:

  • Update them to use the new database
  • Test them with the new database to ensure you continue to get the expected results

The Data Flow Analysis tool provides the visibility you need to achieve a smooth update of a Spectrum database. It shows the services and flows that use a Spectrum database so that you can update them to point to the new database and test them to ensure that they continue to produce the expected results after the update.

  1. In a web browser, go to:

    http://server:port/discovery

    Where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port. By default, the HTTP port is 8080.

  2. Click Data Flow Analysis.
  3. Click the Select Entity button .
  4. Click Spectrum Databases.
  5. Click the button next to the module name to select the module then click OK. This will display all the Spectrum databases for the selected module.
    Tip: Even though you can click the module name itself to view the individual databases that are used by the module, we recommend viewing all the module's databases first so that you have a complete picture of all the Spectrum databases in use for the module.

The resulting diagram shows the entities that rely on each Spectrum database for the module you selected.

Example

You use Spectrum Universal Addressing to validate addresses in your customer database. You are currently using outdated postal database and want to update your system to use the latest database. You have installed the database and defined a Spectrum database for it in Management Console. Now you need to find out where the old database is used so that you can update everything to use the database, and test all affected processes to ensure they are producing the expected results using the new database.

To do this, open Spectrum Discovery, navigate to Data Flow Analysis, and open the entity browser. Click Spectrum Databases. Since you want to view all database resources for Spectrum Universal Addressing, you select the button next to Universal Addressing Module and click OK. The resulting diagram is:

The diagram shows that there are two Spectrum databases on the system, the old one (UAM-US-April-2016) and the new one that you just created in Management Console (UAM-US-March-2017). There are two entities using the old database: a flow named CustomAddressService and a flow named ValidateCustomerAddresses. There are no entities using the new database.

You update the default service options for Validate Address to use the new database. After refreshing the diagram, you now see this:

As you can see, the default service options for Validate Address are now using the new database (UAM-US-March-2017) but the flow CustomAddressService is still using the old database (UAM-US-April-2016). You open the flow CustomAddressService in Enterprise Designer and change the Validate Address stage to use the new database. When you refresh the diagram you now see this:

Now you are certain that all entities are using the new data. You can now perform tests on CustomAddressService and ValidateCustomerAddresses to verify that the update has not adversely impacted the results. By taking these actions as indicated by Data Flow Analysis, you can be confident that the update to the new postal data has gone smoothly.