Announcement

  • The live AACT database is temporarily unavailable because the daily update is running.

Connect to AACT

As a cloud-hosted PostgreSQL database, AACT can be directly accessed via standard query & analytic tools. Several popular tools, such as pgAdmin and RStudio, are free and relatively easy to install and configure. Other proprietary tools are popular and provide powerful analytic and/or relational database utility; these tools include SAS, Toad, and Tableau. In many cases, access is a matter of installing the software package, configuring it to use PostgreSQL, and providing AACT connection credentials.

Connecting directly is recommended for users who want to run analyses or queries using the most current, live data.

Credentials

You will need the following information to access the database directly in the cloud.

    

Hostname: aact-prod.cr4nrslb1lw7.us-east-1.rds.amazonaws.com Port: 5432 Database name: aact User name: aact Password: aact