Announcement

  • Article published in BMJ: How to avoid common problems when using ClinicalTrials.gov in research: 10 issues to consider. https://www.bmj.com/content/361/bmj.k1452
  • Please email ctti-aact@duke.edu if you have questions about creating a database account.
  • The aact/aact database account was deactivated on May 31, 2018. Please use your individual database account to log into the live AACT database.

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.

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.

Create an Account to Access Cloud Database

As of September 2017, 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.