The database that holds the billing information is hosted on the same instance that the service is on, so we will need the PublicDNS.

We are using a PostgreSQL and the default connection information is:

  • host: PublicDNS
  • database name: billing
  • username: billing_viewer
  • password will be billing_viewer_password

ODBC

See Setting Up a Microsoft Windows ODBC Connection

JDBC

The driver class is org.postgresql.Driver and the jdbc url will look like jdbc:postgresql://PublicDNS/billing. If you go to http://PublicDNS/rest/v1/connectionInfo it will give the literal jdbc url for the host.

Command Line

Console - user@hostname ~ $

1
psql -h PublicDNS -U billing_viewer billing

Give billing_viewer_password when prompted for the password.