Business Intelligence Connector Overview

The Business Intelligence (BI) Connector feature gives you point and click access to your SuiteProjects Pro list and report data from BI tools and other reporting, workflow and integration applications.

The BI Connector feature lets you:

• Publish lists and reports as resources accessible from tools outside of SuiteProjects Pro. Each list and report published using the BI Connector feature acts as a custom query against the source data. You can refresh data on-demand in your BI tools to get the latest information available from published resources in the BI Connector.

  • Published list data is updated in real time.

  • Published report data gives a snapshot of your SuiteProjects Pro data at the time of publication. You can set up SuiteProjects Pro to refresh published reports automatically up to two times daily.

• Access your published list and report data from a data feed in an OData V4/JSON format, which is a standard format that can be consumed by BI tools such as Microsoft Excel, Microsoft Power BI, Tableau and many other applications. This format lets you connect your preferred tools to your published resource data without the need to write any code.

• Access you published list and report data from form scripts and scheduled scripts in SuiteProjects Pro.

• Use the SuiteProjects Pro NetSuite integration to export published report data to NetSuite.

• Access your published report data using calls to the /published-reports/ REST API endpoint.

The following help topics give an overview of the BI Connector feature:

• Functionality —BI Connector Functionality

• Benefits — Benefits of BI Connector

• Getting Started — Getting Started with the BI Connector Feature

• Technology — You can connect to your published resource data using the following technology:

  • SuiteProjects Pro OData Service (List and report data)

  • REST API (Report data only)

• Access Control — BI Connector Role Permissions and Data Access Privileges

• Requirements and Limits — BI Connector Requirements and Limits

The following help topics provide detailed procedures for: