Beta: Reporting SQL Database

Beta: Reporting SQL Database

Info
A new feature is currently in beta and we are seeking beta users that will provide feedback

Reporting SQL Database to Connect to Reporting Solutions

If you ever wanted to connect your data in Propel to BrightGauge or Power BI, this feature is for you!

How does it work?

  1. We will provide you with a Read-Only MSSQL Server Connection String.
  2. Propel Your MSP will sync your data with that distinct database about twice a day.
  3. You will be able to make any (SELECT) SQL query you wish to play with your data

Why are we doing this?

MSPs looooooovvvve integrated dashboards and many have asked to pull data out of Propel in a more "automated" way than an Excel or Word report. With this feature, you will be able to pull just about anything from your data.

What's the catch?

  1. The feature is still in beta, so the database schema may change / break / etc. without much warning ;)
  2. You must agree to provide feedback and show us the type of dashboards that you create.
  3. The data is a "rawer" than what the Propel Your MSP application shows you, so you may have a recalculate a few things on your end.
  4. Once the feature makes it to production, the provided DB credentials will change.

How do I opt-in?

Just open a ticket with Support or send us an email with the following information and we'll set you up:
  1. Who you are ;)
  2. List of IP Address(es) that will connect the SQL Database

    • Related Articles

    • Changelog - Release notes

      Propel Your MSP is updated frequently. When updates are deployed, a new entry is added to this changelog here. You can subscribe to the RSS feed to receive using your preferred RSS reader to receive notifications: ...

    • PropelLive: a Web Presentation View

      We are excited to announce "PropelLive": our new Web Presentation View. This new feature offers a more virtual-meeting-friendly alternative to the traditional MS Word document generation for your IT Plan presentations. Here's what you can expect: ...

    • Changelog - Release Notes - Archives 2021 - 2023

      Fixes: Company Audit report "Group by Risk" option + beta announcements Fixes When using the "Group by risk" option, if all questions pass for a specific risk, "Low risk" is still displayed When using the "Group by risk" option, the column is too ...

    • How to create a ConnectWise Manage API Member Key?

      Connect your ConnectWise Manage Instance to Propel Your MSP To connect your ConnectWise Manage instance to Propel Your MSP, you will need the following information: Your instance's domain name (typically connect.yourcompany.com) The Company ID ...

    • ConnectWise Manage: Error when pushing a Project Opportunity to a PSA Sales Opportunity

      When pushing a Project Opportunity to a ConnectWise Manage Sales Opportunity, you may run into a situation where the following, non-descriptive error, is returned by ConnectWise Manage. The Sales Opportunity would still be created, but not its ...