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.