Overview
Stigg’s integration with Amazon Aurora (PostgreSQL-compatible) allows you to export your product catalog, customer, and subscription data directly to your Aurora cluster for custom reporting and analysis.Stigg’s native data export integrations are included in the Scale plan, and are also available as an optional add-on to the Growth plan. See Stigg’s pricing for more details.
Exported entities
When connecting Aurora (PostgreSQL), you can choose which Stigg entity groups to include in the sync. All groups are selected by default. See Exported entities for the full list of entity groups and the tables within each.Entity schema
Setting up the integration
Prerequisites
You’ll need an Aurora PostgreSQL cluster with a database and a user that has permission to create tables and write data in the target schema. You can find the cluster endpoint in your RDS console.Connect Stigg with Aurora (PostgreSQL)
In Stigg, navigate to Integrations > Apps > Amazon Aurora (PostgreSQL).Enter the following information in the connection form:
Click Test & connect.
| Field | Description |
|---|---|
| Host | The Aurora cluster endpoint from your RDS console |
| Port | The port Aurora listens on. Defaults to 5432. |
| Database | The name of the target database |
| Schema | The schema where Stigg will create and sync tables |
| Username | The database user Stigg will authenticate as |
| Password | The password for the database user |
Select entities to export
After entering your connection details, expand the Entities to export section to choose which entity groups to include in the sync. All groups are selected by default.See Exported entities for a description of each group.