Changing Your Repository Database Type

Spectrum Spatial stores named resources (maps, layers, tables and styles), geographic metadata and configuration in a repository. In the default single server installation an embedded database is used to store these resources on the local server. There are several reasons you may need to use a database other than the embedded Derby database:

  • To create a scalable solution that uses a resilient independent database.
  • To use an in-house database preferred or dictated by your company.

In this release, the supported repository databases are Oracle, PostGreSQL/PostGIS, and Microsoft SQL Server. For instructions, see Setting Up a Common Repository Database.