The driver models the Acumatica API as relational tables.

When you connect, the driver connects to Acumatica and gets the list of tables and the metadata for the tables and views.

Since the table definitions are dynamically retrieved, any changes to the remote data are immediately reflected in your queries;.

Generic Inquiries

The driver can discover generic inquiry data as tables and views when the Web Services Endpoint has been extended to expose them.

See Establishing a Connection for a guide to extending the Web Services Endpoint and exposing your generic inquiries.

Generic inquiries can also be configured to support server-side filtering. Server-side Filtering for Generic Inquiries describes this procedure.

Limitations

Limitations describes the limits of the Acumatica REST API and how they affect the operation of the driver.

Tables

Tables shows default table definitions from Acumatica. Your actual tables may differ depending on your customizations. Set the URL connection property to the latest version to get the changes.

The CData JDBC Driver for Acumatica reads table and column metadata dynamically, so it will include both your customizations and any new features that are added to standard Acumatica entities in the future.

Views

Views are read-only tables representing Acumatica entities such as child tables.

Stored Procedures

Stored Procedures are function-like interfaces to Acumatica. They can be used to perform extra tasks that do not fit into the standard operation of directly interacting with a table.