Excel Add-In for Acumatica

Build 24.0.9060

Schema

This section provides a complete list of the Schema properties you can configure in the connection settings for this provider.


PropertyDescription
LocationA path to the directory that contains the schema files defining tables, views, and stored procedures.
BrowsableSchemasThis property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
TablesThis property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
ViewsRestricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.
SchemaSpecifies which Acumatica API to use. By default, it is set to the Contract-Based REST API. When set to OData, the driver uses the OData API to dynamically retrieve all Generic Inquiries available through OData. If set to ODataV4, the driver uses OData 4.0 to query Data Access Class (DAC) objects.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060