Integrating with Postgres

Postgres setup

Drivetrain connects to Postgres using a secure TCP/IP connection over the standard PostgreSQL port. To get started, share the following details with us.

Required details

1. Hostname & Port: We need this detail to locate your Postgres server and port to use for the connection. For example: your-db.company.com:5432

2. Username: This is used to authenticate and identify the database user for the connection. Make sure the user has read access to the schema and tables you intend to share.

3. Password: Used along with the username to securely authenticate the connection to your database.

4. Schema Name: PostgreSQL organizes data into schemas. This tells us which specific part of your database to look into.

5. Table Names: This helps us identify the specific tables within the schema from which data should be extracted.

Best practices

1. We recommend creating a dedicated read-only user for this integration to ensure access is limited and controlled.

2. If needed, we can provide our static IP address to allowlist in your firewall for secure connectivity.