Connecting and executing SQL statements

• Connection alias: Type the name to be used when referring to this connection.
• Driver: Select the alias that you provided for your driver from the drop-down menu.

• Database URL: Copy and paste your connection URL into this field. The following examples show how to connect using either URL parameter authentication or OAuth 2.0 authorization grant authentication.
  Note: You can also generate connection strings using Aha! Configuration Manager. For more information, see Generating connection URLs with the Configuration Manager.

  URL parameter (API key) authentication

  jdbc:datadirect:aha://example.org;authenticationMethod=UrlParameter;
  securitytoken=api_key;

  Note: See URL parameter (API key) authentication for details.

  OAuth 2.0 authorization code grant

  jdbc:datadirect:aha://example.org;authenticationMethod=OAuth2;
  oauthCode=auth_code;clientId=client_id;clientSecret=client_secret;
  redirectUri=https://lvh.me/app_callback.html

  Note: See Authorization code grant for details on this and other supported grant types.

• Database Connection: Select connection alias you provided for the connection from the drop-down menu.
• Schema: Select the schema you want to execute queries against from the drop-down menu.

To select all of the rows from the FEATURES table:

SELECT * FROM FEATURES 

SELECT BODY FROM ISSUES WHERE USER_ID = <user_id> 

See "Supported SQL statements and extensions" for the supported syntax used to execute SQL statements.