I am submitting this request as a follow up to a recent support ticket. The ask is for a method to support IAM Authentication with a dynamically generated token as the password for RDS and Aurora connectors. See https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAMDBAuth.Connecting.html
My initial query: "Our Dev and DevOps teams will be implementing an auth token policy for our databases in the future. This will mean that instead of having a static password, we will need to log-in with an AWS IAM authentication token which is generated dynamically and valid for 15 minutes.
Is there a way to do this with Fivetran (for an Aurora PostgreSQL instance to start with, but eventually other RDS PostgreSQL instances as well)? I can't tell if this could be handled by using a proxy server that always has the correct password, or something else. Have you had other customers who have needed to deal with this security constraint?...."
The response from Fivetran: "Regarding the request here, I actually see a task with our engineering team where they are planning to support IAM Authentication when connection to AWS RDS and Aurora Instances. But this is still in the investigation stage where our devs are exploring if it is possible to use IAM with our current JDBC connections. Once they determine the feasibility they will design and implement a solution, so we don't have any ETA on this at this stage.
Also, Can you please file a feature request in our feature request portal with your use case..."