Creating a JDBC Data Source

You can create a JDBC data source to connect from your Java application, based on CData JDBC Driver for Microsoft Dynamics NAV.

Follow these steps:

1. Add the driver JAR file to the classpath. The JAR file is located in the installation directory's lib subfolder. Ensure that the .lic file is located in the same folder as the JAR file.
2. Provide the driver class. For example:
   

   cdata.jdbc.dynamicsnav.DynamicsNAVDriver

3. Provide the JDBC URL. For example:
   

   jdbc:dynamicsnav:URL=http://myserver:7048;User=myserver\Administrator;Password=admin;ServerInstance=DYNAMICSNAV71;

   Or, if there is a conflict in your application between drivers using the same URL format, use this form to ensure that you are using the CData driver:
   

   jdbc:cdata:dynamicsnav:URL=http://myserver:7048;User=myserver\Administrator;Password=admin;ServerInstance=DYNAMICSNAV71;

   Ensure that the URL starts with either jdbc:dynamicsnav: or jdbc:cdata:dynamicsnav:. The URL can include any of the connection properties in name-value pairs separated with semicolons.

Connecting to Microsoft Dynamics NAV

Before the driver can connect with Microsoft Dynamics NAV, OData services need to be enabled on the server. Once OData Services are enabled, the driver will be able to query any services that are published on the server.

In addition, specify a URL to a valid Microsoft Dynamics NAV server organization root (e.g. http://MyServer:7048) and a ServerInstance (e.g. DynamicsNAV71). If there is not a Service Default Company for the server, set the Company (e.g. 'CRONUS Canada, Inc.') as well.

In a multitenant installation, specify the tenant Id in Tenant (e.g. 'Cronus1').

Authenticating to Microsoft Dynamics NAV

To authenticate, set the User and Password properties to valid Microsoft Dynamics NAV logon credentials or Windows user credentials. Select the appropriate authentication method in AuthScheme.

Auth Schemes

The available authentication schemes are configured in IIS where Dynamics NAV is hosted. In IIS you can select to enable or disable Digest, Basic, Windows, or Anonymous authentication. Please consult with your Dynamics NAV admin to determine which authentication scheme is appropriate for you. Set AuthScheme to one of the following:

• NEGOTIATE (default) - It is part of the Windows authentication, also known as Kerberos.
• BASIC - Basic authentication.
• DIGEST - Digest authentication.
• NTLM - Part of the Windows authentication.
• NONE - Anonymous authentication.