1. Business Intelligence Connector
  2. Frequently Asked Questions About the Business Intelligence Connector Feature

Frequently Asked Questions About the Business Intelligence Connector Feature

What is the Business Intelligence (BI) Connector feature?

The BI Connector feature is an OData connection point supported by many reporting, business intelligence (BI), workflow, and integration applications. This connection point lets you easily configure any compatible application to use the connection point without the need for programming. OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard. See http://www.odata.org for more details on the OData standard.

What can I do with the BI Connector feature?

The BI Connector feature enables you to publish the content of your saved reports so they can be read by a compatible application. This provides a convenient way to access data presented by reports including calculated values. You can scheduled reports to automatically publish the data when the report runs.

How secure is the BI Connector feature?

The BI Connector feature follows the same security best practices as OpenAir. You access the connector using your OpenAir user credentials and can only see the saved reports available to your OpenAir permissions settings. The BI Connector feature needs to be enabled to be available. Account administrators can control access to the publish feature to users by role permissions.

What applications does the BI Connector feature support?

The BI Connector feature uses the OData V4/JSON standard and supports any compliant application. Applications that use older versions of the OData standard or do not support JSON may not be able to use the connection point.

Can I use the BI Connector feature as an API?

Yes, programmers can write applications that send requests and receive responses as defined in the OData standard. See http://www.odata.org/getting-started/basic-tutorial for more details.

What are the known limitations of the BI Connector feature?

  • You need to run and publish a report to make the data available.

  • Only the $top and $skip system query options are available.

  • The BI Connector feature does not support OData versions prior to V4 and does not support ATOM.