Improving Public Access to Aggregate Content of ClinicalTrials.gov

Database Connection Limits Now in Place

To keep the AACT database stable and available for everyone, we have started limiting the number of simultaneous database connections per account. Some automated tools and scripts were opening multiple connections and not closing them properly. Because this is a shared public resource, we encourage everyone who connects programmatically to make sure connections are closed when no longer in use. The current limit is 10 concurrent connections per user account. This helps ensure fair and uninterrupted access to the AACT database for all users. If you have a special use case and need a higher limit, please reach out to us using the Contact Us form and let us know what you need.

What is AACT?

AACT is a publicly available relational database that contains all information (protocol and result data elements) about every study registered in ClinicalTrials.gov. Content is downloaded from ClinicalTrials.gov daily and loaded into AACT. The Clinical Trials Transformation Initiative (CTTI) enhanced AACT in October, 2016 to include the following features:

  • Database content refreshed daily
  • Database directly accessible in the cloud
  • Static copies of the database available for download
  • Open source tools freely available (postgreSQL, Ruby on Rails, Tableau Public)
  • Source code available via Github