PostgreSQL

PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.

Use the SEI PostgreSQL integration to integrate SEI with a Cloud-based PostgreSQL instance.

This SEI integration is under development. It provides limited integration support in its current state.

Configure the integration on cloud

1. In the Company field add the name of your company or organization. This field should not be left empty.

2. Provide the IP address or Hostname of your Cloud-based PostgreSQL instance. For example: "101.152.176.91"

3. Username: Enter the username associated with your PostgreSQL database.

4. Password: Provide the password corresponding to the username you entered.

5. Specify the Name of your PostgreSQL database.

6. Finish configuration and Save the integration.

Configure the integration using satellite

The steps for configuring the integration using satellite is similar to configuring the integration on cloud, with the exception of using satellite to communicate with the PostgreSQL server.

Make sure to select the satellite integration checkbox while configuring the integration. Once you save the integration a satellite.yml file will be automatically generated and downloaded to your computer. Update it following the instructions here.

If you experience any issues while configuring the integration using the Ingestion Satellite, refer to the Ingestion Satellite Troubleshooting and FAQs.

Here’s a sample satellite.yml file:

satellite:
  tenant: <ACCOUNT_NAME>
  api_key: <SEI_API_KEY>
  url: 'https://staging.propelo.ai'
integrations:
  - id: '<INTEGRATION_ID>'
    application: postgres
    username: <POSTGRES_USERNAME>