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 NTLM authentication or OAuth 2.0 refresh token grant authentication.

  NTLM

  jdbc:datadirect:dynamics365
  ServiceURL=http://myonpreminstance.sso3.dynamics365.net/api/data/v9.1;
  AuthenticationMethod=NTLM;NTLMDomain=sso3;User=jsmith;Password=secret;

  Note: See NTLM authentication for details.

  OAuth 2.0 refresh token grant

  jdbc:datadirect:dynamics365:
  ServiceURL=https://mywebinstance.api.crm.dynamics.com/api/data/v9.1/;
  AuthenticationMethod=OAuth2;ClientID=client_id;
  ClientSecret=client_secret;TokenURI=token_uri;
  RefreshToken=refresh_token;

  Note: See OAuth 2.0 authentication for details on this and other supported grant types.
• Database Userid: If required by the authentication method being used, enter the user name. Alternatively, this value can be specified with the User property in the connection string.
• Database Password: If required by the authentication method being used, enter the password. Alternatively, this value can be specified with the Password property in the connection string.

• 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 BOARDS table:

SELECT * FROM BOARDS 

SELECT SELF FROM ISSUES WHERE ID = <issue_number> 

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