Business Intelligence Connector

Connect your Business Intelligence tools directly to your SuiteProjects Pro list and report data.

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.

  Note:

  Only users authenticating using a SuiteProjects Pro password can access your published list and report data from the data feed in OData V4/JSON format The OData service doesn't support SAML users.

• 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.

  Note:

  When the Business Intelligence Connector feature is enabled, you can access your published report data using calls to the /published-reports/ REST API endpoint, even if API access is not enabled for your account.

See Business Intelligence Connector for more details.

The Business Intelligence Connector feature is a licensed add-on. To enable this feature, contact your SuiteProjects Pro account manager.