JDBC Driver for Microsoft Dynamics NAV

Build 22.0.8462


The driver models the data in Microsoft Dynamics NAV into a list of tables that can be queried using standard SQL statements.

Generally, querying Microsoft Dynamics NAV tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

CData JDBC Driver for Microsoft Dynamics NAV Tables

Name Description
Company The DynamicsNAV table Company.
Country The DynamicsNAV table Country.
Currency The DynamicsNAV table Currency.
Customer The DynamicsNAV table Customer.
GeneralProductPosting The DynamicsNAV table GeneralProductPosting.
PurchaseLines The DynamicsNAV table PurchaseLines.
PurchaseOrder The DynamicsNAV table PurchaseOrder.
PurchaseOrderPurchLines The DynamicsNAV table PurchaseOrderPurchLines.
PurchaseOrders The DynamicsNAV table PurchaseOrders.
ResourceCard The DynamicsNAV table ResourceCard.
SalesOrder The DynamicsNAV table SalesOrder.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462