Integrating with Postgres

Postgres Setup

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

Required Details

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

2. Username: This is used to authenticate and identify the database user for the connection, please ensure 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 organises 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.