The CData SSIS Components for Microsoft Dynamics NAV models Microsoft Dynamics NAV entities in relational tables and stored procedures. The table definitions are dynamically obtained from the OData service you connect to.

Tables

Only Pages that are published as Web Services in Dynamics NAV will be available as tables. The Data Model shows the tables available in the demonstration database; the actual tables available will depend on your Microsoft Dynamics NAV instance.

Stored Procedures

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