Azure-hosted SQL Server included
Every plan includes a dedicated Azure-hosted MS SQL Server instance. No server to provision or manage.
HubSpot MS SQL Server Integration
Connect HubSpot to MS SQL Server and sync 100+ data tables automatically — contacts, deals, campaigns, tickets, custom objects, and more. Point-and-click setup.
INCLUDED WITH EVERY PLAN
What is the HubSpot MS SQL Server Integration?
The HubSpot MS SQL Server Integration automatically syncs your HubSpot data into a dedicated database and surfaces it in MS SQL Server — giving your whole team self-service access to CRM dashboards and analytics without writing a line of SQL.
MS SQL Server is the most widely deployed relational database in enterprise environments. With your HubSpot data in SQL Server, your data and BI teams can write T-SQL queries, build SSRS reports, connect any BI tool via ODBC, and blend CRM data with ERP, finance, and operational systems — all from a database they already know.
Every plan includes a dedicated Azure-hosted MS SQL Server instance. No server to provision or manage.
Your SQL Server is compatible with Power BI, Tableau, Excel, SSRS, Metabase, and any ODBC-compatible tool.
Write stored procedures, views, and complex T-SQL queries directly against your HubSpot data.
Prefer to use your own SQL Server instance? See our Database Sync for HubSpot app.
Data coverage
Every MS SQL Server Integration subscription includes the complete HubSpot data model — contacts, deals, marketing campaigns, service tickets, commerce, web analytics, custom objects, and more. All tables include your custom HubSpot properties.
All tables include custom properties. Read the full table definitions here.
How it works
No ETL engineers. No coding. Point-and-click setup that takes under 5 minutes.
Authenticate your HubSpot portal via OAuth. Super Admin access required. Takes under two minutes.
Your SQL Server credentials are available in your user panel. Connect Power BI, Tableau, Excel, or any ODBC tool in minutes. Full setup instructions are available here.
Query your HubSpot data with T-SQL, build reports in your preferred BI tool, or use SSRS for automated enterprise reporting. Your data, your tools.
Your HubSpot data should be in SQL Server — not stuck in the platform. Start your free trial today.
Frequently asked questions
Everything you need to know before getting started.
Datawarehouse.io provisions a dedicated Azure-hosted MS SQL Server instance, creates all tables and schemas, then continuously syncs your HubSpot data on your chosen schedule. Your SQL Server credentials are available in your user panel. Connect Power BI, Tableau, Excel, SSRS, Metabase, or any ODBC-compatible tool — all in under five minutes.
Your sync frequency depends on your plan: Lite syncs every 24 hours, Standard every 6 hours, Advanced every hour, and Max every 15 minutes. Standard, Advanced, and Max users can also set their preferred sync time.
Yes. Datawarehouse.io apps support more than just HubSpot as a data source. Additional sources such as Google Ads and LinkedIn Ads are available and included in your subscription.
Yes. All Datawarehouse.io apps allow you to add other users to your account or database. Users can be added in seconds through our self service user interface.
Yes. SOC 2 certified and GDPR compliant. All data is encrypted in transit and at rest. Only you have read-only access to your Azure SQL database. Data is processed in Azure EU West or North America depending on your billing region.
Yes. Users on the Standard (6-hour), Advanced (1-hour), and Max (15-minute) plans can set their preferred sync time from the user panel.
Yes. Our apps have been independently reviewed by HubSpot and have met their standards for security and technical quality.
Yes. A 14-day free trial is available. A free MS SQL Server dashboard template is also included to help you get started quickly.
Security
Independently audited security controls covering availability, confidentiality, and processing integrity.
All data encrypted in transit and at rest. Only you have read-only access to your Azure SQL database. HubSpot authentication uses OAuth 2.0.
Data processed in Microsoft Azure EU West or North America depending on your billing region.
Independently reviewed by HubSpot for security and technical quality standards.
Join 10,000+ teams who’ve eliminated manual exports.
