SEI PostgreSQL integration
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
- Cloud
- Satellite
- In your Harness Project, select the SEI Module, and go to your Account.
- Select Integrations under Data Settings.
- Select Available Integrations, locate the PostgreSQL integration, and select Install.
- Configure and save the integration.
- Enter your Org Name. This field should not be left empty.
- Provide the IP address or Hostname of your Cloud-based PostgreSQL instance. For example:
"101.152.176.91"
- Username: Enter the username associated with your PostgreSQL database.
- Password: Provide the password corresponding to the username you entered.
- Specify the Name of your PostgreSQL database.
- Finish configuration and Save the integration
To integrate with an on-premises PostgreSQL instance, you must use an Ingestion 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_ID>
api_key: <ACCOUNT_API_KEY>
url: 'https://app.harness.io/gratis/sei/api' # Note that this URL is relative to the Environment of your Harness Account.
integrations:
- id: '<INTEGRATION_ID>'
application: postgres
username: <POSTGRESQL_USERNAME>