We are trying to build an application within SAC, using a direct connection to AWS's Aurora database.
One of the requirements is that this connection is secure, but this is where we are unable to properly configure the application.
For simple access, we added a JDBC driver for PostgreSQL, and within SAC we configured a connection type 'SQL Database', within our Location, with type 'PostgreSQL'. In the next step, we correctly configured the host (our endpoint within AWS Aurora), port and credentials (username and password). And this gave us a connection, making it possible to use it as a data source.
However, we haven't found a way to set this connection to be authenticated with an SSL certificate, for example.
How can we establish this connection with these security requirements?
Is there any configuration to be carried out within the Cloud Connector?
When you are connecting via the PostgreSQL driver you are using the Cloud Agent to connect to the AWS Aurora endpoint. Which part of the communication is not secured with an SSL certificate? Because the AWS Aurora endpoint must have SSL configured and the Cloud Connector has an SSL tunnel as well? Do you want to add SSL between Cloud Connector and Cloud Agent?
Martijn van Foeken | Interdobs