<commit_before><div class="wrap">

  <div class="basicHero">
    <h1>Connect to AACT</h1>
     <p>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.
     </p>
     <p>Connecting directly is recommended for users who want to run analyses or queries using the most current, live data.</p>
  </div>

  <section class="connect">
  <div class="connectionTypes">
    <a href="/pgadmin" class="connectionCard">
      <h4>pgAdmin</h4>
      <p>
      Click here for instructions on how to use a standard graphical user interface to query the cloud-based AACT directly with SQL.
      </p>
      <%= icon("plug") %>
    </a>

    <a href="/r" class="connectionCard">
      <h4>R and RStudio</h4>
      <p>
      Click here for instructions about how to use R/RStudio to analyze the AACT data directly.
      </p>
      <%= icon("plug") %>
    </a>

    <a href="/sas" class="connectionCard">
      <h4>SAS</h4>
      <p>
      Click here for instructions about how to use SAS to analyze the AACT data directly.
      </p>
      <%= icon("plug") %>
    </a>

  </div>

  <div class="connectionTypes">

    <a href="/psql" class="connectionCard">
      <h4>pSQL</h4>
      <p>
      Click here to receive instructions on how to use the command line PostgreSQL tool to query the cloud-based AACT directly with SQL.
      </p>
      <%= icon("plug") %>
    </a>

    <a href="/api_docs" class="connectionCard">
      <h4>Web API (Application Program Interface)</h4>
      <p>
       Users interested in accessing the data via another application or program (in XML or json format), should click here for AACT API syntax.
      </p>
      <%= icon("plug") %>
    </a>
  </div>

    <h2>Credentials</h2>
    <p>You will need the following information to access the database directly in the cloud.</p>
    <%= render 'access/credentials' %>

</div>
</section>
<commit_msg>aact-268:  remove link to API from the Knowledgeable<commit_after><div class="wrap">

  <div class="basicHero">
    <h1>Connect to AACT</h1>
     <p>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.
     </p>
     <p>Connecting directly is recommended for users who want to run analyses or queries using the most current, live data.</p>
  </div>

  <section class="connect">
  <div class="connectionTypes">
    <a href="/pgadmin" class="connectionCard">
      <h4>pgAdmin</h4>
      <p>
      Click here for instructions on how to use a standard graphical user interface to query the cloud-based AACT directly with SQL.
      </p>
      <%= icon("plug") %>
    </a>

    <a href="/r" class="connectionCard">
      <h4>R and RStudio</h4>
      <p>
      Click here for instructions about how to use R/RStudio to analyze the AACT data directly.
      </p>
      <%= icon("plug") %>
    </a>

    <a href="/sas" class="connectionCard">
      <h4>SAS</h4>
      <p>
      Click here for instructions about how to use SAS to analyze the AACT data directly.
      </p>
      <%= icon("plug") %>
    </a>

  </div>

  <div class="connectionTypes">

    <a href="/psql" class="connectionCard">
      <h4>pSQL</h4>
      <p>
      Click here to receive instructions on how to use the command line PostgreSQL tool to query the cloud-based AACT directly with SQL.
      </p>
      <%= icon("plug") %>
    </a>

    <!-- <a href="/api_docs" class="connectionCard">
      <h4>Web API (Application Program Interface)</h4>
      <p>
       Users interested in accessing the data via another application or program (in XML or json format), should click here for AACT API syntax.
      </p>
      <%= icon("plug") %>
    </a> -->
  </div>

    <h2>Credentials</h2>
    <p>You will need the following information to access the database directly in the cloud.</p>
    <%= render 'access/credentials' %>

</div>
</section>

{'fraction_non_alphanumeric': 0.1145610278372591, 'fraction_numerical': 0.006638115631691649, 'mean_word_length': 2.9923076923076923, 'pattern_counts': {'":': 0, '<': 116, '<?xml version=': 0, '>': 116, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6118914', 'n_tokens_mistral': 1407, 'n_tokens_neox': 1335, 'n_words': 549}