Author Topic: Connect EA to AWS through SSH  (Read 1898 times)

Moe

  • EA User
  • **
  • Posts: 107
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Connect EA to AWS through SSH
« on: January 09, 2021, 09:58:14 am »
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
PhD Student - Systems Engineering

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 7707
  • Karma: +101/-18
    • View Profile
Re: Connect EA to AWS through SSH
« Reply #1 on: January 11, 2021, 10:47:17 am »
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.
Eve

support@sparxsystems.com

Moe

  • EA User
  • **
  • Posts: 107
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Re: Connect EA to AWS through SSH
« Reply #2 on: January 11, 2021, 05:33:20 pm »
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
PhD Student - Systems Engineering

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 7707
  • Karma: +101/-18
    • View Profile
Re: Connect EA to AWS through SSH
« Reply #3 on: January 12, 2021, 07:49:05 am »
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.
Eve

support@sparxsystems.com

Moe

  • EA User
  • **
  • Posts: 107
  • Karma: +0/-0
  • I'm a lifelong learner
    • View Profile
Re: Connect EA to AWS through SSH
« Reply #4 on: January 12, 2021, 09:15:30 am »
Thank you, Eve.
PhD Student - Systems Engineering