DB Connection

Usage

The DB pane establishes a connection to a database, so that all tools that are subsequently executed will directly modify this database.

Setup

Please ensure that you have python and that all of its packages have been installed properly. To ensure that your packages are present and updated, run pip install -r requirements.txt in the parent directory.

Main and Source Connection

The main connection pane is always required whereas the source connection pane is required when using the Pull Data tab. Information from one data base (source) is 'pulled' to another data base (main). We allow pulls between data bases:

Source	Main
sau_int	sau
sau_geo	sau
sau_geo	sau_int
sau_int	merlin (postgres)
merlin (SQL)	sau

---

Remember to click the "Test Connection" button to make sure you have established a proper connection.

---

Credentials

postgres servers (Port 5432)

• Local instance:

  • Host: 127.0.0.1
  • Host: localhost

• QA instance:

  • Host: sau-db-qa-1.ck24jacu2hmg.us-west-2.rds.amazonaws.com
    • Username (read-access): qc_int
    • Username (write-access): sau_int
    • Databases: sau_int, sau

• Prod instance:

  • Host: sau-db-1.ck24jacu2hmg.us-west-2.rds.amazonaws.com
    • Username (read-access): qc_int
    • Username (write-access): sau_int
    • Databases: sau_int, sau

• Web QA instance:

  • Host: sau-db-qa-1.ck24jacu2hmg.us-west-2.rds.amazonaws.com
    • Username (read-access): sau_reader
    • Username (write-access): sau

• SAU_geo instance (for read-access, use the credentials for QA instance):

  • Host: sau-db-qa-1.ck24jacu2hmg.us-west-2.rds.amazonaws.com
    • Username (write-access): sau_geo
    • Databases: sau_geo

sqlservers (Port 1433)

• Merlin instance:
  • Host: merlin.seaaroundus.org
    • Username (read-access): merlin_reader
    • Username (write-access): merlin
    • Databases: merlin