The CData Excel Add-In for SAP Fieldglass models SAP Fieldglass objects as relational tables and views. A SAP Fieldglass object has relationships to other objects; in the tables, these relationships are expressed through foreign keys. The following sections show the available API objects and provide more information on executing SQL to SAP Fieldglass APIs.

Schemas for most database objects are defined in simple, text-based configuration files.

Connectors as Views

SAP Fieldglass Connectors are exposed as views and internally use the default connector names, such as Active Worker Download.

In order to query the connectors as views, they should first be enabled and configured in SAP Fieldglass using the Integration Tools.

Make sure to set the ConnectorDataFormat property based on the configured download data format.

In order to list Connectors that are not part of the exposed views or have custom names, set the ConnectorNames property to a comma-separated list of Connector names. Make sure to correctly write the Connector names including spaces.

Connector Custom Fields

By default, the IncludeCustomFields property is set to false. Set it to true to list custom fields or fields that are not part of the current schemas.

To include the custom fields, the add-in needs to make an individualized request per Connector, which may cause poor performance when listing metadata.