Postgresql

Postgresql logo

Postgresql

Configuration

PostgreSQL source connector integrates with PostgreSQL databases to extract structured data.

Synchronizes data from database tables.

It uses dynamic schema introspection to create appropriate entity classes and provides comprehensive access to relational data with proper type mapping and relationships.

Authentication

This connector uses a custom authentication configuration.

Authentication Configuration

PostgreSQL authentication configuration.

host
strRequired

The host of the PostgreSQL database

port
intRequired

The port of the PostgreSQL database

database
strRequired

The name of the PostgreSQL database

user
strRequired

The username for the PostgreSQL database

password
strRequired

The password for the PostgreSQL database

schema
strDefaults to public

The schema of the PostgreSQL database

tables
strDefaults to *

Comma separated list of tables to sync. For example, ‘users,orders’. For all tables, use ’*‘

Configuration Options

This connector does not have any additional configuration options.