Establishing a Connection
Creating a JDBC Data Source
You can create a JDBC data source to connect from your Java application. Creating a JDBC data source based on the CData JDBC Driver for Microsoft Dynamics NAV consists of three basic steps:
- Add the driver JAR file to the classpath. The JAR file is located in the lib subfolder of the installation directory. Note that the .lic file must be located in the same folder as the JAR file.
- Provide the driver class. For example:
- Provide the JDBC URL. For example:
jdbc:dynamicsnav:URL=http://myserver:7048;User=myserver\Administrator;Password=admin;ServerInstance=DYNAMICSNAV71; or jdbc:cdata:dynamicsnav:URL=http://myserver:7048;User=myserver\Administrator;Password=admin;ServerInstance=DYNAMICSNAV71;
The second format above can be used whenever there is a conflict in your application between drivers using the same URL format to ensure you are using the CData driver. The URL must start with either "jdbc:dynamicsnav:" or "jdbc:cdata:dynamicsnav:" and 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.
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.