Overview
For customers who have a dedicated database connected to XMAP, you can access your data directly in QGIS. This means that both XMAP and QGIS are reading from the same source, so there is no risk of multiple versions of your data existing in your organisation.
Getting Started
For any user needing to access the database, you will need to create a user. You can do this from XMAP, or using a database tool such has DBeaver or pgAdmin.
QGIS Authentication
We recommend using the authentication manager to create a named configuration for XMAP. In QGIS, go to: Settings -> Options -> Authentication
- Click the green + symbol to create a new configuration.
- Enter a name for the configuration
- Click the orange padlock symbol to unlock the 'id' field
- Enter xmapdbu as the ID
- Select Basic Authentication from the drop down
- Enter your username and password for the database user.
Connect to the Database
- Open the datasource manager:

- Select PostgreSQL
- Click New
- Enter a name for the connection
- In the Host field, enter the connection URL. If you do not know this, contact support.
- In the database field, enter the name of the database to connect to.
- Under Authentication, click the drop down and select the configuration you created for XMAP.
- Select 'Also list tables with no geometry'
- Click OK to save
- Click 'Connect' to connect to the database.
- You can then browse the database schemas and tables and select a table to 'Add' to the QGIS view.
Troubleshooting
You must select a table in order to add a layer
If you see this message when trying to add a table, you may need to tell QGIS what the geometry type is of the layer. In the datasource manager, find the table and scroll across to the Spatial Type column. Try selecting a Geometry Type and clicking Add:
I've added my layer to QGIS, but it isn't showing, there's a warning symbol next to the layer or the layer doesn't seem to have a geometry type.
See above. This layer may be using a generic geometry type. You can use the data source manage to tell QGIS the geometry type of the layer, or add a feature to the layer using XMAP and refresh the QGIS connection.