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 10 months ago537 views
3 Answers
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 10 months 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 10 months ago
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 days 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