Publishing Layers from a Remote Database

Publishing Layers from a Remote Database

Overview

XMAP supports connections to any PostGIS database of version 9.6 or greater. This database can be hosted and managed by us or you. If you have a remote database you can use this to connect to many software applications to improve access to data across your organisation.

Connecting XMAP to your database

Contact support if you wish to connect XMAP to your database. You will need to provide:
  1. Host
  2. Username
  3. Password
  4. Database Name

Publishing Layers from your database

  1. From the XMAP Admin Panel access the Data -> Layers option on the left hand side. 
  2. Click the + button to add a new layer
  3. Click the 'Layer Type' drop down and select 'Remote PostGIS Connection'
  4. On the right hand side follow the prompts via the drop downs to select the Database, Schema and Table you want to publish. 
  5. Once a table is selected you can add a Title on the left.
  6. If the geometry of the table is of type 'geometry' you will be prompted to select a simple geometry type on the left.

Best Practices

To ensure compatibility across multiple systems and follow best practice for database management we recommend:

Always use lower case, alphanumeric, snake_case names for relations (schemas, tables, columns, constraints etc) in your database, e.g:
  1. Instead of calling your schema Building Control, call it building_control.
  2. Instead of calling your table Building Control Applications, call it building_control_applications.
  3. Instead of calling your column Application Reference (refval), call it application_refval.
XMAP may reject names if they do not follow this guidance. 

Notes
  1. Tables and Columns must:
    1. be in lower case, and camel_case
    2. start with a letter
  2. Where possible use text, integer and Date column types. If you find a different column type is not working please let us know.