How do I set up Collaboration in PBRS?

Collaboration enables the ability to "assign" schedules to other PBRS servers.

System - Collaboration

Go to System.

PBRS Home Menu

Select Collaboration.

PBRS Home Menu

Collaboration enables the ability to "assign" schedules to other PBRS machines. Though the management and editing of the schedules will occur on the primary PBRS machine, processing and running of the schedule will occur on the collaborator (the other PBRS installation).

With Collaboration, resource intensive schedules can be processed on more powerful servers. Also, numerous schedules can be spread out across an array of PBRS machines to reduce the overall load and run schedules more efficiently.

PBRS servers/instances that are set up as collaborators only run schedules delegated to them by the Primary Server. Collaborators DO NOT process their own local schedules.
Collaboration

Combined with Multi-threading, each PBRS Collaborator will have up to 4 threads. Therefore, quadrupling the number of concurrent schedules you can run simultaneously with every collaborator added.

In the example picture shown above, there would be 16 available threads.

IMPORTANT

The remainder of this guide will walk you through setting up collaboration with another PBRS server. It is imperative that you follow the steps below carefully. Failure to do so may result in an unsuccessful setup.

Requirements

  • More than one PBRS Installation is required in order to properly set up collaboration. If you currently only have one installation of PBRS, please see the following links for more information regarding installing PBRS on another server:
    • Each PBRS instance must be accessible through your internal network.
    • Each remote server with PBRS installed must have the correct email, database, and system settings in order to ensure proper processing and delivery of the reports/schedules. Each collaborator's settings should match the main scheduler.
    • The Primary Machine's database must be migrated to your own SQL Server instance. Additionally, each collaborator must be connected to the primary scheduler's database.

    Setting up Collaboration

    • Open PBRS on the Primary Scheduling Server.
    • Go to System.
    PBRS Home Menu
    • Select Collaboration.
    PBRS Home Menu
    • Click Enable server Collaboration and click Add.
    PBRS Collaboration Wizard.
    • This will bring up a window that will prompt you to select the PBRS configuration file on the remote machine.
    • Browse through the network and select the PBRS Collaborator machine.
    Power BI and SSRS Reports: Adding a Collaborator machine in PBRS.
    • Click Open.

    Power BI and SSRS Reports: Adding a Collaborator machine in PBRS.

    • Select pbrsconfigshare.

    Power BI and SSRS Reports: Adding a Collaborator machine in PBRS.

    • Select pbrslive.config and click Open.

    Power BI and SSRS Reports: Adding a Collaborator machine in PBRS.

    • Click OK.
    • Enter your windows credentials.
    • Click OK.

    Power BI and SSRS Reports: Adding a Collaborator machine in PBRS.

    Power BI and SSRS Reports: Adding a Collaborator machine in PBRS.

    • PBRS Collaborator machine is now added in the PBRS Primary Scheduling Server Collaboration system.
    • When creating a Schedule you can select which server you want to execute the schedule on.

    Power BI and SSRS Reports: Collaborator machine in PBRS.