The driver models the Acumatica OData API as relational views, supporting access through the ODataV3 and ODataV4 schemas. These schemas offer read-only access to views, and any changes to the remote data appear immediately in your queries. When you connect, the driver retrieves table definitions dynamically, calling Acumatica's web services to access the list of views and their metadata.

You can specify your schema preference in the Schema connection property. If you set the schema to OData, the driver uses the ODataV3 API to retrieve all available Generic Inquiries (GIs). If you set it to ODataV4, the driver uses the ODataV4 API to access Data Access Class (DAC) objects.

Views

The OData V3 schema exposes Generic Inquiries, which users create as custom queries or reports in Acumatica. These inquiries allow you to customize how data is aggregated and displayed. The CData JDBC Driver for Acumatica reads view and column metadata dynamically, ensuring compatibility with your customizations and new features in Acumatica.

Note: Generic Inquiries do not appear in OData by default, so you may need to enable them by selecting the "Expose via OData" checkbox in the Acumatica Generic Inquiries screen.

The OData V4 schema, on the other hand, focuses on exposing DAC objects, which represent core entities in Acumatica, like Orders, Customers, and other essential data structures. DAC objects may vary depending on your Acumatica instance, version, and applied customizations, making ODataV4 a suitable option if you want a deeper view of Acumatica's core data.

Stored Procedures

Stored Procedures act as function-like interfaces within Acumatica. Use them to perform tasks that extend beyond standard querying of views. They provide flexibility for executing operations not directly tied to querying views, helping you meet specialized requirements.