Connect to AACT

As a cloud-based PostgreSQL database, AACT can be accessed directly using your web browser.

Browser

Click here to run queries on the AACT data from your web browser.

Popular tools are free and straightforward to install and set up. To access AACT, you typically install one of the tools below, configure it to connect to PostgreSQL, and enter your AACT connection credentials.

pgAdmin

Click here for instructions on how to use a standard graphical user interface to query the cloud-based AACT directly with SQL.

R and RStudio

Click here for instructions about how to use R/RStudio to analyze the AACT data directly.

SAS

Click here for instructions about how to use SAS to analyze the AACT data directly.

pSQL

Click here to receive instructions on how to use the command line PostgreSQL tool to query the cloud-based AACT directly with SQL.

Dont forget to whitelist IP address: 174.138.61.222

Create an Account to Access Cloud Database

As of May 2018, you need an AACT account to access the cloud-based database. Creating an account is easy: just click here and enter your name, an email address, and a password. Once you create an account and login, the credentials you need to access the database will be displayed here.

Already Have an Account?

If you already have an AACT account and need a reminder of the access credentials, login and the info you need will appear here.