PostgreSQL

Load event data into PostgreSQL for reliable, feature-rich relational database storage.

Configuration

Field	Type	Required	Description
`host`	string	Yes	The PostgreSQL server hostname.
`port`	string	Yes	The PostgreSQL server port. Defaults to `5432`.
`database`	string	Yes	The target database name.
`schema_name`	string	Yes	The schema to write to. Defaults to `public`.
`table_name`	string	Yes	The target table name to insert rows into.
`username`	string	Yes	The database username for authentication.
`password`	secret	Yes	The database password for authentication.
`ssl_mode`	select	No	The SSL mode for the connection. Defaults to `require`.

Quick Setup

Navigate to Integrations in the sidebar.
Open the Integration Library tab.
Find PostgreSQL or filter by Cloud Storage.
Click Install, select a variant if available, and fill in the required fields.
Click Install Integration to create the integration with a ready-to-use default configuration.

API Setup

curl -X POST http://localhost:8084/v1/admin/integration-catalog/postgresql/install \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "PostgreSQL",
    "variant": "default",
    "config": {
      "host": "db.example.com",
      "port": "5432",
      "database": "analytics",
      "schema_name": "public",
      "table_name": "events",
      "username": "datafly",
      "ssl_mode": "require"
    },
    "delivery_mode": "server_side"
  }'

Delivery

Events are delivered server-side from your Datafly Signal infrastructure directly to PostgreSQL. No client-side scripts are loaded for this integration.

Visit PostgreSQL documentation for full API documentation and credential setup instructions.

Mysql Rabbitmq