1. Business Intelligence Connector
  2. Connecting BI Tools to Your OData Feed

Connecting BI Tools to Your OData Feed

Note:

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 SuiteProjects Pro account.

You can connect any business intelligence (BI) tool or any other application supporting OData v4/JSON to your OData feed. After you connect your application to the OData feed, you will have access to the list or report data that you published or that others shared with you.

Note:

You must have either the Download Reports or the Publish Reports role permission to access published reports in the SuiteProjects Pro OData service. Accessing public published lists from the OData service does not require specific role permissions.

Many applications support OData v4. Check the vendor documentation for specific information about connecting your BI product to an OData feed. This section describes how to connect the following applications to your OData feed:

You will need to provide the URL for your OData feed as well as your sign-in information. See Your 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 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.

For information about specifications that your BI tool must meet to use the Business Intelligence (BI) Connector feature, see Requirements.

Your OData Feed URL and Connection Details

To connect a BI tool or any other application to your SuiteProjects Pro OData feed, you will need the following details:

  • The location of the resource collection or the resource you want to access in your OData feed. The URL contains the domain for your SuiteProjects Pro 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 lists. A resource is a specific published report or published list. To form the URL for a specific resource, add the resource name <resource-name> — for example report53 or listview64 at the end of the URL for the resource collection.

    Important:

    Some BI product do not support links to OData resource collections. For example, to import your published report 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 collection

    https://<account-domain>/odata/v4/listviews/

    URL for a specific OData list

    https://<account-domain>/odata/v4/listviews/<resource-name>

    Note:

    The URL for SuiteProjects Pro services includes the domain name for your SuiteProjects Pro account <account-domain>. For more information about your account-specific domain name, see Your Account URLs.

  • Your OData feed User name and Password:

    User Name

    The user name contains your SuiteProjects Pro Company ID and User ID, separated by a back slash (\):

    <CompanyID>\<UserID>

    Password

    Your SuiteProjects Pro password

Related Topics