What is the SQL Server App for Procore and how does it integrate with Procore?
The SQL Server App for Procore is a hosted and managed solution provided by CBI. It integrates your Procore data into an Azure SQL database and provides you read-only access to your Procore data.
Why would I want my data in a SQL database?
By integrating your data into a SQL database, you can use any common reporting solution (e.g., Power BI, Tableau, Crystal, Cognos, Domo, Qlik) and build custom reports. You can also use the SQL database as an integration solution to move data out of Procore and into another system. This solution eliminates the time and cost of building custom code against Procore’s APIs.
How do I get started?
Send an email to firstname.lastname@example.org to request a free trial and pricing.
Do I need a SQL Server license for this solution?
No, all SQL database licensing costs are managed by CBI and included in your subscription.
Do I need any infrastructure for this solution?
No, the solution runs on Microsoft Azure SQL and CBI manages the solution.
Can I build my own custom reports?
Yes, you can use any SQL compliant reporting solution and point it to the SQL database.
How frequently does my data get refreshed?
Most datasets can refresh up to 4 times per day. There are some financial datasets that only refresh nightly.
Can you help us build custom reports?
Yes! If you are using Power BI as your reporting solution, CBI can provide consulting services to help build unique custom reports for your organization.
How is the solution licensed?
It is licensed as an annual subscription and pricing is based on your annual Procore construction volume.
How frequently do you release updates?
Updated Power BI content files come out on a monthly release cycle. They include new features, enhancements, and bug fixes.
When Procore releases new features, will it be supported in SQL Server?
Yes, after Procore releases a new feature and makes it available through their developer API’s, CBI will integrate it into a future release.