BYOD For Options Generators
For the BYOD integration to function correctly with your RMM, it is essential that the Database Config Name
is set exactly as Rewst Cache - Database
. Failure to do so will result in caching issues, affecting data retrieval performance.
Overview
RMM customers occasionally face challenges with the speed at which data is returned from RMM's APIs. One efficient workaround is to leverage the Bring Your Own Database (BYOD) integration.
Integrating BYOD with RMM aims to streamline data retrieval and bypass potential lags or slow responses. With BYOD in place, RMM's options generation workflows are optimized, leading to improved performance and reduced wait times.
This document provides specialized steps for integrating BYOD with RMM to address these speed issues.
Setting up the BYOD
If you are integrating with an existing database, you can skip to the section titled "Integration".
Requirements (pre-Rewst)
To ensure the BYOD integration works seamlessly, there are a few requirements that need configuring on your end:
Database Setup via Powershell: You will initially be required to run the database setup Powershell script. Ensure that you're running this script with Powershell 7.
Password and Script Output: During the setup, you'll be prompted to create a password for the DB account designated for the integration. Make sure to safely store this password. Additionally, retaining all of the script's output will be crucial for subsequent steps, so ensure it's accessible.
Integration
Once you've set up the database and have the necessary credentials, follow the below steps to configure a new integration:
Log in to the Rewst platform.
Click on the Integrations menu on the left sidebar.
Click or search for SQL Database.
Complete the form with the details you created from the script.
Click Save.
Post-Integration Steps Specific to Rewst Workflows
Following the database setup, you must attach the [Rewst Master v2] BYOD: Insert Data into Database workflow as a completion listener to the on-prem workflows. If you are missing this workflow, please reach out to the ROC.
Navigate to Automation -> Workflows
Search [Rewst Master v2] BYOD: Insert Data into Database
Click the three dots on the right
Select On Completion
Click Run this workflow when...
Click the Plus button
Select the following settings:
Workflow: [Rewst Master v2] On-Prem: Get all AD OUs
Trigger On Statuses: succeded
Integration Override: SQL Database
Enabled: On
Click Submit
Repeat steps 6-8 with the following workflows
[Rewst] List AD Userโs Group Memberships
[Rewst Master v2] On-Prem: Get All Groups-Actual
[Rewst Master v3] M365: List Mail-Enabled Users-Actual
[Rewst] List AD Users-Actual - Rewst
[Rewst Master] Get On-Prem Exchange Email Domains - Actual - (optional)
[Rewst Master] Get On-Prem Exchange Databases - Actual - (optional)
[Rewst Master] Get On-Prem Exchange Shared Mailbox - Actual - (optional)
[Rewst Master] Get On-Prem Exchange Servers - Actual - (optional)
The [Rewst Master v2] BYOD: Insert Data into Database workflow might not be automatically available to you. It's often necessary to consult with The ROC for specific sync operations. When in doubt, reach out!
Last updated