PostgreSQL

Get started with the PostgreSQL source!

Connector Details

NameValue
PlatformPostgres
Auth TypeOAuth
Sync TypeIncremental
DirectionBidirectional
API versionREST API
Testing AccountPostgres Account
Unified SchemaSupported in the Public Schema

Connector Versions

NameVersionStageDescription
Postgresv1GASupports Postgres online accounts

Get your Postgres OAuth Credentials

The first thing you need to do is go ahead and log in to Postgres.

Once you logged in You will see the instance page. You can Crate the new Instance from "Create New Instance" button form top right button.

You can select the Plan and name of DB and then click on "Select Region" button.

You can select the region and click on Review button.

You can Click on Create Instance button to save the changes you made.

Once you created the instance, click in the name of Instance. You will land on the Details page. You can find all the required information i-e Host, Username, Passsword, Database name and port on this page.

And that is it! You have now successfully linked to PostgresSQL!

Supported Data

The PostgresSQL tap currently supports the following objects:

NameDescription
accountPostreSQL under a separate user account. This user account should only own the data that is managed by the server, and should not be shared with other daemons.
accountfilter
accounts
activityPostgreSQL's statistics collector is a subsystem that supports collection and reporting of information about server activity.
balance_records
betapageleads_sheet1
churn
contacts
customers
demolog_sheet1
events
file_metadata
invoice
issues
leadstatus
metric
monitor
output
users