SSIS Components for Acumatica

Build 20.0.7587

OData Data Model

The component 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 component 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.


Shows all the Generic Inquires exposed via OData from Acumatica. The CData SSIS Components 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.7587