Connect EA to AWS through SSH

[Moe]

Hello, EA Experts,

I was working with a developer from the team on connecting EA to AWS to better collaborate and save time by making updates to the database directly based on the updates I make in the EA model.

We reached a step that we could not pass, and I need your help, please.

We have a server hosted on AWS and PostgreSQL runs locally on the server. Is there a way to SSH to the server using a key rather than a user name and password?

https://ibb.co/rZ1pTtN

Thank you,
Mo

[Eve]

I would be asking somewhere on a PostgreSQL specific location if there is a way to configure the PostgreSQL ODBC driver to use an SSH connection. Once it's specified in the ODBC connection it should be completely transparent to EA.

[Moe]

Hello, Eve,

Thank you for your response.

I understood from your response that the PostgreSQL ODBC driver needs to be configured to use an SSH connection. Correct?

Thank you,
Mo

[Eve]

My answer is that if it is possible EA won't even know about it. It has to be a function of the communication between the server and the odbc driver.

Unfortunately, I don't know enough about PostgreSQL to know if that's a feature that it offers.

[Moe]

Thank you, Eve.