Import Data

Get Started Account and Support File Formats and Data Types Find and Export Data Import Data
Add and manage attachments Connect to a CIFS network share Connect to a PostgreSQL database Connect to a WFS service Connect to an Amazon S3 data source (AWS Web Console method) Connect to an Amazon S3 data source (CloudFormation Template method) Connect to an ArcGIS REST API data source Create a geospatial layer from a table Edit attribute columns during import or update Import data from connected data sources Import multiple items to a data layer Introducing supported data sources Introducing the Data Gateway Manually upload and import data Scan and manage connected data sources Upload and manage documents Upload data via courier Importing Point Cloud
Manage Your Site Plugins Publish Data Query API and Web Services Site Admin APIs Update Data Users and Groups Desktop App Frequently Asked Questions
  1. Home
  2. Import Data
  3. Connect to a PostgreSQL database

Connect to a PostgreSQL database

A PostgreSQL database is an open source database system. With a network link, Koordinates is able to connect to designated PostgreSQL databases, search available data and identify data to make available for import on your site. For databases configured with PostGIS (an extension to PostgreSQL that supports geometry), we can also add geospatial data layers.

Note: PostgreSQL imports are only available on the Business and Enterprise plans. 

Connect to a PostgreSQL database

1. Select 'Manage' from the top navigation menu

2. Click 'Data Sources' and select 'Configure Sources' 

3. Click 'Add a Source' and select 'PostgreSQL'

4. Add connection details

You'll be asked to add: 

  • Host
  • Port
  • Database
  • Schema (leave this blank to scan every schema)
  • Username
  • Password

Give your source a meaningful title and choose an Owning Group

Owning Groups are used to categorise and manage permissions on data. Don't worry if you're not sure—you'll be able to change the Owning Group before importing any data into your data service.

5. Click 'Connect'

If correctly configured, your Koordinates Data Service will immediately connect and scan your data source. 

Manage your PostgreSQL source

1. Click 'Data Sources' and select 'Configure Sources' 

2. Select your source

To locate your source, browse the source list, or add a keyword into the search bar.

3. Edit Connection details for your source

4. Click 'Save'