Business Intelligence Connector

Connect your Business Intelligence tools directly to OpenAir with OData.

Getting data from OData feed in Microsoft Excel.

The Business Intelligence Connector feature gives you point and click access to OpenAir data from existing reporting, business intelligence, workflow, and integration applications.

The Business Intelligence Connector provides the following features:

Publish reports and provide access to the report data from OData.
Publish list views giving users real-time access to OpenAir data with OData. User access rights configured in OpenAir are enforced preventing access to data the user does not have permission to see. All essential OpenAir list views are supported.
Role permissions are supported to give administrators control over who can publish data.
Access to published reports are available using the NSOA.report.list and NSOA.report.data user scripting functions.
Use published list views like custom queries and read the latest list view data in your OpenAir form and scheduled scripts with the NSOA.listview.list and NSOA.listview.data user scripting functions.

See the OpenAir Business Intelligence Guide for more details.

Note:

The Business Intelligence Connector only supports the latest version of OData V4 / JSON (Open Data Protocol).

To enable this feature, contact your OpenAir account manager. This feature does not support SAML users.