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?

질문됨 일 년 전819회 조회
3개 답변
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?
답변함 6달 전
  • 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
전문가
답변함 일 년 전
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.

답변함 일 년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인