The CData Excel Add-In for Exact Online models entities from the Exact Online API as relational tables and stored procedures. The CData Excel Add-In for Exact Online dynamically retrieves the table definitions. When you connect, the add-in gets the list of tables and the metadata for the tables by calling the appropriate Web services.

Tables

Tables allow access to the data from the data source.

Stored Procedures

Stored Procedures are function-like interfaces to Exact Online. They can be used to search, update, and modify information in Exact Online.