PostgreSQL
Notes:
The PostgreSQL connector is currently in feature preview and as such documentation for this feature is still work in progress
Overview
The PostgreSQL connector can be used to load rows from PostgreSQL tables or views into xpna.
This connector is commonly used for operational datasets, warehouse views, or prepared reporting tables.
Connection Requirements
The following details are required:
- Hostname
- Port
- SSL mode
- Database
- Username
- Password
Additional connection properties can be supplied when required by the PostgreSQL environment.
Note:
Credentials are stored encrypted in xpna.
A read-only database user should be used where possible.
Source Items
Tables or views are selected as source items in the configuration.
After the connection is tested, available tables and views can be selected from the configured database. Sample data can then be requested so that columns can be reviewed, typed, and mapped before the configuration is saved.
Refreshing Data
Data can be refreshed manually from the Connections page or by using the configured schedule.
If the selected table or view schema changes, sample data should be refreshed and the column configuration should be reviewed.