Tableau Connector for Acumatica

Build 20.0.7606

OData Data Model

The connector models the Acumatica OData API as relational views. Only read only tables (views) are supported on OData schema.
Any changes to the remote data are immediately reflected in your queries; the table definitions are dynamically retrieved. When you connect, the connector connects to Acumatica and gets the list of views and the metadata for the views by calling the appropriate Web services.

API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

Views

Shows all the Generic Inquires exposed via OData from Acumatica. The CData Tableau Connector for Acumatica reads view 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.

Stored Procedures

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7606