JDBC Driver Pack
Connect with Your Dynamics 365 NAV/BC Data within Your Java-Based Applications
Enable structured querying for seamless integration with BI, reporting, and ETL solutions.
Retrieve and write data using SQL-based queries while the driver manages API interactions.
Product Features
Seamless Connectivity
JDBC Driver Pack
Reliable connectivity for accessing and managing
Dynamics 365 NAV/BC data.
JDBC Driver Pack
Advanced Capabilities
JDBC Connection Manager
The JDBC Connection Manager in the JDBC Driver Pack provides a user-friendly interface for configuring authentication, API behaviors that help work with various network and deployment settings in order to achieve optimal data access performance.
PurchaseStreamlined
Connectivity
Easy to configure and implement so your development can be completed in minutes and you can quickly leverage insights from your data.
Flexible and
Easy to Use
We make the most flexible integration solution on the market. Our software offers intuitive user interfaces that are flexible and easy to use.
Cost
Effective
With a simplified development experience, and an extremely simple licensing model, our solution offers the best value for your investment.
Unparalleled
Performance
Our software includes purpose-built features that help you achieve optimal performance while ensuring exceptional efficiency and reliability.
More Resources
Download our Data Sheet for
JDBC Driver Pack
More JDBC Connectors
Our JDBC Driver Pack includes a diverse selection of
drivers for seamless connectivity across business applications.
Adobe Commerce/Magento
Crelate
Dataverse
Dynamics 365 AX/FO
Dynamics 365 CE/CRM
GitHub
Google Ads
Google Calendar
Google Classroom
Google Forms
GraphQL
HubSpot
Mailchimp
Microsoft Graph
Monday.com
Salesforce
ServiceNow
Shopify
FAQ
The KingswaySoft JDBC Driver for Dynamics 365 Business Central and Dynamics NAV provides a bridge for Java-based applications to connect to your Business Central or NAV instance. It lets you use standard SQL queries to read, write, update, and delete data, translating these operations into the appropriate API calls for the selected service endpoint (REST or SOAP).
The driver includes a helpful connection management tool. You can run it by executing java -jar kingswaysoft.jdbc.jar. After you enter your connection details, the tool will automatically generate the JDBC connection URL for you to copy and use in your application.
The driver primarily uses OAuth for authentication, with grant types including Authorization Code, Client Credentials, and Certificate. Basic authentication is also available depending on your specific Business Central/NAV setup.
You can execute standard SQL statements like SELECT, INSERT, UPDATE, and DELETE using the Statement or PreparedStatement classes. The driver translates these commands to interact with the Business Central or NAV server's web services.
The UPSERT operation is a powerful feature that lets you either insert a new record or update an existing one in a single call. It uses a specified key to check if a record already exists. If a match is found, it updates the record; if not, it inserts a new one. This is ideal for data synchronization tasks.
You can use the DatabaseMetaData interface in JDBC. Specifically, the getTables() method retrieves a list of available tables, and the getColumns() method provides detailed information about the columns within a specified table.
Get in Touch
If you would like to know more specific details about our solutions, or if you have any suggestions about our product offerings, we are always here to listen and help!