Beta: Reporting SQL Database
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?
- We will provide you with a Read-Only MSSQL Server Connection String.
- Propel Your MSP will sync your data with that distinct database about twice a day.
- 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?
- The feature is still in beta, so the database schema may change / break / etc. without much warning ;)
- You must agree to provide feedback and show us the type of dashboards that you create.
- 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.
- 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:
- Who you are ;)
- 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: ...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 ...