AWS RDS to PostgreSQL connection

I am trying to connect my PostgreSQL database into Domo using the recommended connector, but I am a bit confused on the credentials. The PostgreSQL database I made is connected to AWS RDS, so instead of defining a host, port, or SSL, my code has this:

host: process.env.RDS_HOSTNAME
user: process.env.RDS_USERNAME
password: process.env.RDS_PASSWORD
database: process.env.RDS_DB_NAME
port: process.env.RDS_PORT
ssl: process.env.DB_SSL ? {rejectUnauthorized: false} : false

My understanding is that this makes the database run on the values provided by AWS RDS. Can I still connect that database into Domo using the PostgreSQL conncector?

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You need the actual server host name and connection information as domo doesn’t know about your RDS configuration

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You need the actual server host name and connection information as domo doesn’t know about your RDS configuration

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**