Postgres

Creating Postgres Connection

Postgres connection helps to connect Postgres database for accessing and managing your relational data directly from Infoveave.

Adding a Postgres Connection

To create a new Postgres connection:

1. Go to Administration > Connections
2. Click New Connection and select Postgres from the available connectors
3. In the New Postgres Connection form, provide the required configuration details

Connection Parameters

When setting up a Postgres connection, you need to provide the following details:

Field	Description
Name	A unique name to identify your Postgres connection
Server	The Postgres Server host address or instance name
Port	The Postgres Server port (default: 5432)
Username	Your Postgres authentication username
Password	Your Postgres authentication password
Database	The specific database name to connect to
Schema	The database schema (optional)
Attributes	Additional connection attributes and parameters

Steps to Validate and Save

1. After configuring your Postgres connection parameters, click Validate to verify the connection
2. If validation succeeds, click Save to store the connection
3. You can now use Postgres Server as a datasource in your Infoveave workspace

Example Use Cases

With a Postgres connection configured, you can:

• Query and analyze relational data directly from Postgres databases
• Create real-time dashboards with data from multiple Postgres tables
• Build automated workflows that trigger on database changes and events
• Perform complex data joins and transformations using advanced SQL queries
• Leverage Postgres’s JSONB capabilities for semi-structured data analysis
• Schedule regular data extracts from Postgres for reporting and analytics
• Integrate Postgres data with other data sources in Infoveave
• Monitor database performance metrics and query optimization
• Set up data synchronization between Postgres and other systems
• Create advanced analytics using Postgres functions and stored procedures
• Generate business intelligence reports from enterprise application data
• Analyze geospatial data using Postgres’s PostGIS extension
• Process and visualize time-series data with Postgres’s temporal features