I have a remote database I need to access through a VPN connection. The issue is, I find myself repeating the same OpenVPN client connection configuration for multiple EC2 and Fargate instances.
This is entirely outside my area of expertise, so I'm not sure what the best way of solving this issue is. Would creating a dedicated EC2 instance acting as an OpenVPN client to which I can route all traffic to the database be a good approach? The database is hosted off of AWS on a customer's business network, and I'm not permitted to configure that end, so it doesn't look like a Site-to-Site VPN would help me out here.
Any advice would be appreciated.
10