Connecting BI Tools to Your OpenAir OData Feed
The functionality described in this topic requires the following feature: Business Intelligence Connector. Contact your account administrator if you are not sure about the features enabled for your OpenAir account.
You can connect any business intelligence (BI) tool or any other application supporting OData v4/JSON to your OpenAir OData feed. After you connect your application to the OpenAir OData feed, you will have access to the list view or report data that you published or that others shared with you.
You must have either the Download Reports or the Publish Reports role permission to access published reports in the OpenAir OData service. Accessing list views published as public in the OpenAir OData service does not require specific role permissions.
Many applications support OData v4. Check the vendor documentation for specific information about connecting your Business intelligence product to an OData feed. This section describes how to connect the following applications to your OpenAir Data feed:
-
Microsoft Excel — see Importing Data from Your OpenAir OData Feed to Microsoft Excel.
-
Microsoft Power BI — see Importing Data from Your OpenAir OData Feed to Microsoft Power BI Desktop.
You will need to provide the URL for your OpenAir OData feed as well as your login information. See Your OpenAir OData Feed URL and Connection Details.
If a published report is refreshed while your BI tool is reading or paging through that published report, the OpenAir OData feed returns a 410 Gone
HTTP status error with the message "Report has been republished. You need to reload the report.
". Whether and how the message is displayed depends on the BI tool you use to consume the published report data.
![410 Gone HTTP error shown in Excel when a published report is refreshed while Excel pages through the published report.](img/BIConnector/410GoneError_Excel.png)
For information about specifications that your BI tool must meet to use the Business Intelligence Connector feature, see Requirements.
Your OpenAir OData Feed URL and Connection Details
To connect a business intelligence tool or any other application to your OpenAir OData feed, you will need the following details:
-
The location of the resource collection or the resource you want to access in your OpenAir OData feed. The URL contains the domain for your OpenAir account followed by the path to the OData resource or resource collection. The resource collection is either all your published reports or all your published list views. A resource is a specific published report or published list view. To form the URL for a specific resource, add the OData resource name
<resource-name>
— for examplereport53
orlistview64
at the end of the URL for the resource collection.Important:Some Business Intelligence product do not support links to OData resource collections. For example, to import your published OpenAir data into Tableau, you must use the URL for a specific resource.
URL for your OData report collection
https://<account-domain>/odata/v4/reports/
URL for a specific OData report
https:
//<account-domain>/odata/v4/reports/<resource-name> URL for your OData list view collection
https://<account-domain>/odata/v4/listviews/
URL for a specific OData list view
https:
//<account-domain>/odata/v4/listviews/<resource-name> Note:The URL for OpenAir services includes the domain name for your OpenAir account
<account-domain>
. For more information about your account-specific domain name, see Your OpenAir Account URLs. -
Your OpenAir OData feed User name and Password:
User Name
The user name contains your OpenAir Company ID and User ID, separated by a back slash (\):
<CompanyID>\<UserID>
(for example, honeycomb\mcollins)
Password
Your OpenAir password