PostgreSQL Connector
PostgreSQL Connector
Configure Connection: Enter host, port, database, and credentials
Test Connection: Verify connectivity before saving
Browse Schema: See available tables and views
Create Virtual Entity: Map a table to a Nixa entity
Sync Data: Data flows in automatically on schedule
Connect to databases your way:
Standard Connection — : Host, port, database, username, password
Connection String — : Paste a full PostgreSQL connection URI
SSL/TLS — : Secure connections with certificate validation
Read-Only Mode — : Optional read-only enforcement for safety
The connector reads your database structure:
Automatic Detection — : Discovers tables, views, and columns
Type Mapping — : Maps PostgreSQL types to Nixa field types
Primary Keys — : Identifies primary keys for record matching
Relationships — : Detects foreign key relationships
Keep your data fresh:
Scheduled Sync — : Automatic updates on a schedule
Incremental Sync — : Only sync changed records using timestamps
Full Refresh — : Complete re-sync when needed
Custom Queries — : Write SQL for complex data extraction
Your database credentials are protected:
Encrypted Storage — : Credentials encrypted at rest
IP Whitelisting — : Works with firewall rules
Connection Pooling — : Efficient resource usage
Legacy Integration — : Connect to existing systems
Data Warehousing — : Pull from reporting databases
Cross-System Sync — : Share data between platforms
Analytics — : Use external data in Nixa dashboards



•
Initial release
•
Direct PostgreSQL connection
•
SSL/TLS support with certificate validation
•
Automatic schema discovery
•
Scheduled and incremental sync
•
Custom SQL query support
Install your first app in 30 seconds. No credit card required.