NTLM authentication can be used to authenticate with Dynamics 365.

To configure the driver to use NTLM:

  • Set the ServiceURL property to the base URL of the Dynamics 365 instance to which you want to issue requests. For example, http://myonpreminstance.sso3.dynamics365.net/api/data/v9.1/.
  • Set the AuthenticationMethod property to NTLM.
  • Set the NTLMDomain property to specify the NTLM domain.
  • Set the User property to specify the name of the user connecting to the service.
  • Set the Password property to specify the password for the user connecting to the service.
Note: The User and Password properties are not required to be stored in the connection string. They can also be sent separately by the application.

The following examples show the connection information required to establish a session using NTLM.

Connection URL

Connection conn = DriverManager.getConnection
  ("jdbc:datadirect:dynamics365
    ServiceURL=http://myonpreminstance.sso3.dynamics365.net/api/data/v9.1/;
    AuthenticationMethod=NTLM;NTLMDomain=sso3;User=jsmith;Password=secret;");

Data Source

Dynamics365DataSource mds = new Dynamics365DataSource();
mds.setDescription("My Dynamics 365 Data Source");
mds.setServiceURL("http://myonpreminstance.sso3.dynamics365.net/api/data/v9.1/");
mds.AuthenticationMethod("NTLM");
mds.NTLMDomain("sso3");
mds.User("jsmith");
mds.Password("secret");