Get Started Today

Database Sync for HubSpot

*Please note it may take up to 24 hours for your export to complete depending on the size of your HubSpot database and your position in que.
*You must be a “Super Admin” in HubSpot in order for the export to function.
*Individual campaign email records are currently unavailable for export with this service.

Refresh Rate
Subscription Interval

With just a few clicks, Datawarehouse.io can help you integrate your HubSpot’s portal with your own hosted compatible database, so you can take control of your company’s data. Database Sync for HubSpot enables you to connect HubSpot to your database of choice using our self-service app.

Sync your HubSpot data into MS SQL Server, PostgreSQL, Big Query, and other database formats using an ETL service built by HubSpot experts. The Datawarehouse.io data pipeline process’ more than 2 billion records a day and services thousands of HubSpot customers globally. The Database Sync app for HubSpot enables you to access over 100+ data tables and an unlimited amount of your data for a fixed price. 

Don’t want to pay for HubSpot’s Ops Hub Enterprise just to get your data out of HubSpot? No problem. When using Database Sync our ETL service is available to you on all versions of HubSpot.

The app connects HubSpot to your data warehouse and syncs data at a regular interval. Our ETL service for HubSpot automatically creates all the necessary tables and keys to import your HubSpot data into your database. It is a point and click solution that has been purpose designed to ETL data out of HubSpot and into your data warehouse or data lake of your choosing. 

The following data is synced from HubSpot into your Database. You can read the descriptions of the data tables in detail here.

  • Contacts
  • Leads
  • Companies
  • Deals
  • Deal Splits
  • Engagements (Calls, Communications, Emails, Meetings, Notes, Postal Mail, Tasks)
  • Campaigns
  • Campaign Emails
  • Tickets
  • Owners (Users Data)
  • Teams
  • Product Libraries
  • Line Items
  • Form Submissions
  • Form Analytics
  • Deal History
  • Ticket History
  • Contact Lifecycle History
  • Custom Objects
  • Custom Properties for all Objects
  • Quotes
  • Payments
  • Invoices
  • Subscriptions
  • Orders
  • Lists (Contact, Company, Deal, Custom Object)
  • Website Pages
  • Website Page Analytics
  • Chatflows
  • Contact Web Traffic Data
  • Custom Events
  • Workflows
  • Feedback Survey Submissions
  • Goals
  • Property Change History (Companies, Contacts, Deals, Engagements, Tickets, Products)
  • Associations between all records

The following data is synced from HubSpot into your Database. You can read the descriptions of the data tables in detail here.

  • Contacts
  • Leads
  • Companies
  • Deals
  • Deal Splits
  • Engagements (Calls, Communications, Emails, Meetings, Notes, Postal Mail, Tasks)
  • Campaigns
  • Campaign Emails
  • Tickets
  • Owners (Users Data)
  • Teams
  • Product Libraries
  • Line Items
  • Form Submissions
  • Form Analytics
  • Deal History
  • Ticket History
  • Contact Lifecycle History
  • Custom Objects
  • Custom Properties for all Objects
  • Quotes
  • Payments
  • Invoices
  • Subscriptions
  • Orders
  • Lists (Contact, Company, Deal, Custom Object)
  • Website Pages
  • Website Page Analytics
  • Chatflows
  • Contact Web Traffic Data
  • Custom Events
  • Workflows
  • Feedback Survey Submissions
  • Goals
  • Property Change History (Companies, Contacts, Deals, Engagements, Tickets, Products)
  • Associations between all records

This app currently supports the following database formats with more coming in the future.

  • Azure SQL Database
  • Azure Synapse Analytics
  • Azure Data Warehouse
  • Standalone Microsoft SQL Server
  • AWS RDS MS SQL
  • Google Cloud SQL for SQL Server
  • Google BigQuery
  • Standalone PostgreSQL
  • AWS RDS PostgreSQL
  • Azure Database for PostgreSQL
  • Google Cloud for PostgreSQL
  • MySQL
 

For questions about upcoming database compatibly please visit our Help Desk and submit an inquiry.

The following information is only applicable if you are connecting to the following database types. If you are connecting to a database type not listed below please follow this guide.

  • Azure SQL Database
  • Standalone Microsoft SQL Server
  • AWS RDS MS SQL
  • Google Cloud SQL for SQL Server

To complete the app installation process for any of the above database types you will need the following information prepared.

  1. Server Address
  2. Database Name
  3. Database Username
  4. Password
 

(The username must not be the servers username. It must be a database user for the database you create for us to sync data to)

 

The following permissions must be granted to the Database User used to run this application.

db_datareader
db_datawriter
db_ddladmin
GRANT VIEW SERVER STATE TO <user_name>

 

Depending on how you have set up your security you may also need to whitelist our App Services’ IP address range. Please visit the Help Desk to retrieve this information. 

Once you are prepared click the Get Started button on the product page.

This app is GDPR compatible and is hosted entirely in the EU if your business requires that. Simply select the location as EU or US Depending on your preferences and it will dynamically change where the app is hosted and processed.

Our services use (SSL/TLS) encryption at all times while data is “in transit” from HubSpot, so the data remains secure. We also utilize transparent data encryption which encrypts your connector information at rest. You can read more about our security here.

 

 

20+

HubSpot Integrations

9000+

Active Installs

2 Billion

Records Processed Daily

20+

HubSpot Integrations

9000+

Active Installs

2 Billion

Records Processed Daily

See why the World’s Best Companies use Datawarehouse.io to Become Truly Data-Driven

Trusted by