PostgreSQL

Overview

You can create a Destination PostgreSQL Connector to write to a PostgreSQL table using your PostgreSQL username and password.
The schema for this Connector is defined by the PostgreSQL table schema. The schema cannot be changed after saving the Connector.

Prerequisites

Information needed:
  • Host
  • Port
  • Username
  • Password
  • Database
  • Table

Creating an PostgreSQL Destination Connector

Step 1: Click New Connector.
Step 2: Under the System prompt, click PostgreSQL.
Step 3: Provide a Connector Name.
Step 4: Select Destination Connector.
Step 5: Provide the Host Name.
Step 6: Provide the Port Number.
Step 7: Provide your Username.
Step 8: Provide your Password.
Step 9: Provide the name of the Database that contains the table you want to write to.
If you are trying to access a database that is behind a firewall, please ensure that the following Osmos IP addresses are allowed to access the database. Osmos uses these fixed IP addresses to access your sources and destinations.
  • 35.222.106.198/32
  • 35.232.180.174/32
Step 10: Provide the name of the Table that you want to write to.
Note: the schema for this Connector is defined by the PostgreSQL table schema. The schema cannot be changed after saving the Connector, so please confirm it is accurate before proceeding.
Note: for any fields that have primary key, foreign key or other constraints, you may either (1) ensure that the source data mapped to the field satisfies those constraints or (2) leave the field empty and ensure that your database is set up to auto populate those fields with appropriate constraint-satisfying data.
Last modified 3mo ago