POST
/
v1
/
integrations
PostgreSQL Connector
curl --request POST \
  --url https://api.matia.io/v1/integrations
{
  "destinationId": "<string>",
  "destinationSchema": "<string>",
  "replicationFrequency": "<string>",
  "onSchemaUpdate": "<string>",
  "enabled": true,
  "sourceConfig": {
    "type": "postgres",
    "name": "<string>",
    "authMethod": "<string>",
    "connection": {
      "username": "<string>",
      "password": "<string>",
      "hostname": "<string>",
      "port": 123,
      "database": "<string>",
      "slot": "<string>",
      "publication": "<string>"
    },
    "connectionType": "<string>",
    "owners": [
      "<string>"
    ]
  },
  "sourceSettings": {
    "max_clients": 123,
    "incremental_mode": "<string>"
  }
}
This connector uses the common integration parameters as described in the Create Integration endpoint, along with the PostgreSQL-specific parameters below.

​
Additional Resources

Schema Configuration

How to configure which tables and columns to sync

The schema is of type object.