It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda RMM (Formerly Managed Workplace)

Connecting to the Data Layer

  • Last updated on

This section provides detailed information about the following topics:

  • How to Connect
  • Using the OData Feed (Cloud)
  • Using SQL Server (On-Premise)
  • Samples

How to Connect

There are two options to connect to the data layer, depending on your edition of Barracuda Managed Workplace. Some common BI tools that can be used to connect are Power BI, Excel and Tableau.
Using the OData Feed (Cloud)

  1. In your BI tool, select the OData data source type
  2. Type the URL to your OData feed, in the form of https://<service center URL>/odata/v1, where <service center URL> is the URL of your Service Center.

    For example, if you are on-premise (self-hosted), and the URL of your Service Center is https://www.company.com/SC , the OData feed URL would be https://www.company.com/OData/v1 . If you are on the Barracuda cloud, and the URL of your Service Center is https://eu02.mw-rmm.barracudamsp.com/SC , the OData feed URL would be https://eu02.mw-rmm.barracudamsp.com/OData/v1.

  3. When you are prompted for credentials, select Basic as the authentication mechanism.
  4. Type your Barracuda Managed Workplace VAR Domain\Username as the username and your password.

The user account must be in the Administrator role.

Using SQL Server (On-Premise)

  1. In your BI tool, select the SQL Server data source type.
  2. When prompted for credentials, use the SCRptUser SQL login that was created for you when you deployed the rpt schema views.

    The password must be reset before it can be used.

Power BI Desktop Samples

Below are a collection of Power BI Destop samples that you can use for inspiration. These samples can be opened with Power BI Desktop only.

To Use a Sample
  1. Open Power BI Desktop.
  2. Open a template.
  3. While the data is loading, click Cancel.
  4. Select Edit Queries > Data Source Settings > Change Source.
  5. Change the connection to your specific data source.
Templates
Barracuda Branded Sample Template

Data Model

To see an interactive graphic of the data model, click here.

 

Last updated on