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.
View the full entity schema
See every table and column exported to your destination, organized by entity group.
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. PostgreSQL 13 and above is fully supported; PostgreSQL 12 is supported on a best-effort basis. You can find the cluster’s writer endpoint in your RDS console. If your cluster is protected by security groups or other firewall settings, you’ll need Stigg’s static IP (shown in the connect form) to complete the first step below.1
Allow access
Configure your cluster’s security group or firewall to permit:
- Incoming connections to your host and port (usually
5432) from Stigg’s static IP - Outgoing connections from ports
1024–65535to that same IP
If your cluster isn’t accessible from the public internet, SSH tunneling through a bastion host is supported. Allow inbound SSH (port
22) from Stigg’s static egress IP on the bastion host, create an SSH user with Stigg’s public key in ~/.ssh/authorized_keys (contact Stigg support for the key), and grant the bastion host’s IP access to the database port in place of the static egress IP. Provide the bastion host address, port, and username in the connection form.2
Create a writer user
Create the database user Stigg will connect as, and grant it permission to create tables and write to the target database:If you’re pre-creating the schema rather than letting Stigg create it on first sync, also grant:
3
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.
4
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.