Data Import From a private PostgreSQL RDS Instance

Data Import From a private PostgreSQL RDS Instance

Hello All,

I feel like the problem I am experiencing has been seen before; however, I am having a difficult time finding any solutions. Hoping the community has some insights.

I am trying to import data from a PostgreSQL RDS instance that is behind an EC2 SSH tunnel protected by a .pem file. Zoho Anaytics and Data Prep do not support this level of security to make a direct connection using an RDS connector. However, it looks like the Zoho Databridge would be a better solution as I do not need to degrade the level of security to my database by allowing password-based authentication for our SSH tunnel.

The problem I am facing with that is I do not see any official documentation on how to install Databridge on a headless EC2 linux server. All the examples I've seen so far assume a GUI is available to work through the installation wizard. 

Any solutions?