I'm trying to handle data from Amazon RDS (PostgreSQL) as an external object in Salesforce.
I have registered Skyvia's IP in the RDS security group, and I can see the RDS data in "Query SQL" in Skyvia's Connections.
I can successfully "Validate and Sync" with Skyvia in the Salesforce external data source, but I cannot access the RDS data from Salesforce.
If I specify "0.0.0.0/0" instead of Skyvia's IP in the RDS security group, I can see the RDS data from Salesforce.
Please let me know how to configure this.
Salesforce's error massege:
Error received from the external system: 500: { "error":{ "code":"","message":"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond xx.xxx.xxx.xx:5432" } }