PostgreSQL

Key Capabilities

Getting Started Quickly

Set Up a Read-Only Database User
Create a dedicated user in PostgreSQL with read-only privileges on the required schemas and tables.

Configure the Data Source via xGen Interface

Advanced Configuration: Change Data Capture (CDC)

When to Opt for CDC
Use CDC when deletion tracking is required, the dataset is very large, or no reliable cursor field exists.

Steps to Set Up CDC

Available Replication Strategies

Securing Connections