Adding a Spectrum Enterprise Tax Database Resource

Whenever you install a new database resource or modify an existing database resource you must define it in Management Console in order for it to become available on your system. This procedure describes how to add or modify Spectrum Enterprise Tax database resources.

  1. If you haven't already done so, install the dataset files on your system. For instructions on installing databases, see the Spectrum Technology Platform Installation Guide.
  2. In Management Console, under Resources, choose Spectrum Databases.
  3. To create a new database resource, click the Add button . To make changes to an existing database resource, select it, then click the Edit button . To delete a database resource, select it, then click the Delete button . You can also create a new database resource by copying an existing one, by clicking the Copy button .
  4. If you are creating a new database, enter a name for the database resource in the Name field. The name can be anything you choose. If you are creating a new database by copying an existing one, rename the default name as needed. You cannot modify the name of an existing database resource, because any services or jobs that reference the database resource by its original name would fail.
  5. In the Pool size field, specify the maximum number of concurrent requests you want this database to handle.

    The optimal pool size varies by module. You will generally see the best results by setting the pool size between one-half to twice the number of CPUs on the server, with the optimal pool size for most modules being the same as the number of CPUs. For example, if your server has four CPUs you may want to experiment with a pool size between 2 (one-half the number of CPUs) and 8 (twice the number of CPUs) with the optimal size possibly being 4 (the number of CPUs).

  6. In the Module field, select Spectrum Enterprise Tax.
  7. Under Required Databases, specify the folder that contains the GeoTAX master files. You can either type in the path or click the Browse button to locate and select the top-level folder containing the dataset folders and files.
  8. If you have Optional Databases, select the associated database field and either specify the path to the folder that contains the dataset files or click the Browse button to locate and select the top-level folder containing the dataset folders and files.
    Under Enhanced Accuracy, specify the folder that contains your point level files. To allow sharing your point level data with other Spectrum Technology Platform modules or services, the folder containing your point level files may be in a directory other than the default Spectrum Enterprise Tax database install location.
    For a state-supplied file or sales tax cross-reference file, use the dropdown menu to the left of the database input field to select the type of file, then enter the path to the top-level folder containing the dataset folders and files.
  9. When you are done with your changes, click Save.