Adding a Database Resource

To create a GeoComplete database resource:

  1. If you haven't already done so, install the database 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. Click the Add button to create a new database or select an existing database resource then click the Edit button to change it. 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 InternationalGeocoderGeoComplete.
  7. In the Type field, select GeoComplete.
  8. Click the Add button to install a new dataset. In the Name field, specify a name for this dataset. This name can be anything you choose. In the Path field specify the folder that contains the datasets for the country you selected. You can type in a partial path and click the Browse button to drill down into the file structure to locate the datasets you need. When you click OK, the dataset for the country will be visible in the database resource list on the Add Database page.
    The datasets are available in bundles: AMER, APAC and EMEA. The default installation location is: <InstallLocation\AMER\data> where <InstallLocation> is the directory you specified when you installed the datasets. Only specify the location of the datasets you have licensed.
    Note: Do not put datasets on a network drive. Doing so can cause performance problems.
  9. If you have additional datasests to add, click the Add button , otherwise click Save.
  10. Click OK to leave the Add Database page.
  11. If there are any open Enterprise Designer sessions, click the refresh button to see the new stage.