Overview

The CData Excel Add-In for Sage 300 models Sage 300 objects as relational tables and views. A Sage 300 object has relationships to other objects; in the tables, these relationships are expressed through foreign keys.

Key Features

• The add-in models Sage 300 entities as relational tables and views, allowing you to write SQL to query Sage 300 data.
• Stored procedures allow you to execute operations to Sage 300.
• Live connectivity to these objects means any changes to your Sage 300 account are immediately reflected when using the add-in.

Tables

Tables are retrieved dynamically from the authenticated Sage 300 account.

Child Tables

Child tables are also retrieved, which contain child objects of their parents. For example, OEOrders has OEOrders_OrderCommentsInstructions and OEOrders_OrderDetails as its child tables. These tables are exposed as aggregate columns while querying their parent table. They also have references to the unique identifier of their parent.

Views

Read-only views are retrieved dynamically from the authenticated Sage 300 account.

Stored Procedures

Stored Procedures are function-like interfaces to Sage 300. Stored procedures allow you to execute operations to Sage 300.

SELECT statements for the main tables are mostly supported server-side. For example:

SELECT * FROM APInvoiceBatches WHERE BatchDate='2019-01-09 01:00:00.0'

will be run server-side.

Note: When executing SELECT statements on child tables, everything is processed client side.