The CData ADO.NET Provider for Sage Intacct models Sage Intacct data as an easy-to-use SQL database with tables, views, and stored procedures.

The provider exposes two data models, which you select in Schema:

• XML Data Model exposes Sage Intacct data using the Sage Intacct XML API. This data model is dynamic and reflects changes you make in the Sage Intacct UI.
• REST Data Model exposes Sage Intacct data as a set of tables and views using the Sage Intacct REST API. Document headers and their associated line items are available as separate tables (for example, Bill and BillLine).

Stored Procedures

Stored Procedures are scripts that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including exposing Sage Intacct reports as tables, approving vendors, and creating attachments.