Configuring your AWS Postgres (RDS or Aurora) destination.
Allow write access to a portion of your RDS or Aurora PostgreSQL database.
default
). Note: VPC groups are permissive (vs. restrictive) and for instances with multiple VPC security groups, only one needs to be configured with the new inbound rule.5432
) and a Custom
Source value that includes all of the service IPs. Note: you will need to add /32
to the end of each IP (CIDR notation).For database instances in a VCP
0.0.0.0/0
set to Allow
. (This is a default rule created by AWS. If this rule already exists, skip to Edit outbound rules.)5432
) from the Prequel static IP. Click Save changes.0.0.0.0/0
set to Allow
. (This is a default rule created by AWS. If this rule already exists, skip to the next step.)0.0.0.0/0
.Create a database user to perform the writing of the source data.
create
and temporary
privileges on the database. create
allows the service to create new schemas and temporary
allows the service to create temporary tables.If the schema
already exists:
By default, the service creates a new schema based on the destination configuration (in the next step). If you prefer to create the schema yourself before connecting the destination, you must ensure that the writer user has the proper permissions on the schema, using GRANT ALL ON schema <schema> TO <username>;
Securely share your host name, database name, port, your chosen schema name, username, and password with us to complete the connection.
Configuring your AWS Postgres (RDS or Aurora) destination.
Allow write access to a portion of your RDS or Aurora PostgreSQL database.
default
). Note: VPC groups are permissive (vs. restrictive) and for instances with multiple VPC security groups, only one needs to be configured with the new inbound rule.5432
) and a Custom
Source value that includes all of the service IPs. Note: you will need to add /32
to the end of each IP (CIDR notation).For database instances in a VCP
0.0.0.0/0
set to Allow
. (This is a default rule created by AWS. If this rule already exists, skip to Edit outbound rules.)5432
) from the Prequel static IP. Click Save changes.0.0.0.0/0
set to Allow
. (This is a default rule created by AWS. If this rule already exists, skip to the next step.)0.0.0.0/0
.Create a database user to perform the writing of the source data.
create
and temporary
privileges on the database. create
allows the service to create new schemas and temporary
allows the service to create temporary tables.If the schema
already exists:
By default, the service creates a new schema based on the destination configuration (in the next step). If you prefer to create the schema yourself before connecting the destination, you must ensure that the writer user has the proper permissions on the schema, using GRANT ALL ON schema <schema> TO <username>;
Securely share your host name, database name, port, your chosen schema name, username, and password with us to complete the connection.