By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Unable to connect Amazon RDS for PostgreSQL to Appflow

1

I get the following error when adding an Amazon RDS for PostgreSQL as a connection in Appflow, following these instructions: https://docs.aws.amazon.com/appflow/latest/userguide/connectors-amazon-rds-postgres-sql.html

"Error while communicating to the connector: Failed to validate Connection while attempting "ValidateCredentials with CustomConnector" with connector failure The request failed because the service Source Amazon RDS returned the following error: Details: Unable to connect to the database., ErrorCode: InvalidArgument. (Service: null; Status Code: 400; Error Code: Client; Request ID: null; Proxy: null)"

I can connect to the RDS instance pgAdmin, but for some reason I get this error when connecting on Appflow. The security group has All traffic set to anywhere for both inbound and outbound rules.

Are there additional requirements to connect to Appflow?

Topics
DatabaseApplication Integration
Tags
PostgreSQLAmazon AppFlow
Language
English
olaytrack23
asked a year ago789 views
3 Answers
0

I am stuck on this same error as well. Haven't come across any solutions, only reports of this InvalidArgument error. Would be nice to know which argument is invalid.

The AWS docs are lacking on some details here:

  • does the database have to be publicly accessible (assigned a public IP)? It hasn't worked for me either way.
  • is there some security group configuration required to allow AppFlow to write to RDS?
  • what is the database name? is it 'postgres'? just the username? the "DB name" property in the database's configuration tab, which is set by some buried setting when creating the database?
dorviedev
answered 5 months ago
  • dorviedev
    23 days ago

    I finally got RDS Postgres working as an AppFlow sync destination. The database visibility had to be public, plus I had to add an inbound rule to its Security Group to allow AppFlow. Its IP address range came from this list, for my region: https://docs.aws.amazon.com/vpc/latest/userguide/aws-ip-ranges.html

    Then had to connect to the RDS db with pgadmin and create a table under the public schema to fill in the next two inputs it asked for: Object is the schema and Subobject is the table. Also modify table to add columns to map the incoming data to.

0

Hi,

Can you confirm that you are not configuring Amazon RDS for PostgreSQL as data source? According to AWS documentation, you can use Amazon AppFlow to transfer data to Amazon RDS for PostgreSQL, but not to read it.

profile picture
EXPERT
Mikel Del Tio
answered a year ago
0

Yes, it is the destination. Google Analytics 4 is the source. I am working with this documentation: Google Analytics 4 connector for Amazon AppFlow.

olaytrack23
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content