DLHDLH.io Documentation
Databases

PostgreSQL (Aiven.io)

DLH.io documentation for PostgreSQL (Aiven.io)

As a leader in open source platform service management Aiven.io provides a number of management features to simplify the scalability of an enterprise architecture, primarily with open source database technologies. One of aiven.io's primary open source database technologies is PostgreSQL.

Aiven.io PostgreSQL Image Aiven.io PostgreSQL

In order to start syncing data from Aiven.io PostgreSQL to your target/destination warehouse to begin providing democratized access to other systems and users without interrupting your core database performance use the DLH.io Aiven.io PostgreSQL connector and synchronizing to a target warehouse today!

Aiven.io: PostgreSQL Setup

Logical Replication Setup (Aiven.io)

Setup Instructions

Follow the setup steps guide for configuring your PostgreSQL (Aiven.io) connection to enable data to flow into your destination via DLH.

Supported Features

Here are key features supported for this connector.

Sync FeatureSupportedDetails
Custom Data and DevelopmentAbility to enhance connector upon request
Historical Re-Load/Load
Incremental/Delta LoadGets most recent records and changes
Column Selection
Column Hashing
Re-Sync Table/EntitySelect at the table level to reload data
history (on next Sync Bridge run)
Custom QueriesUtilizing SQL Data Query Connector
Custom Data
Captures Deleted RowsOn all supported tables
API Sync Bridge Initiation
Priority Scheduling
Private VPC/Link
DLH Data Model Available-

If you have any questions about these supported features please reach out to our Customer Support team.

Details on Sync Processing

For this connector, we believe the sync processing is straightforward. We've provided a number of details, steps, and other guidance here and in the setup steps guide. Be sure to also check the change log and notes page from time to time for any changes.