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

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. With Database Sync for HubSpot you can connect HubSpot to your database using our self-service app.

The Database Sync 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

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

  • Contacts
  • Companies
  • Deals
  • Engagements (Calls, Communications, Emails, Meetings, Notes, Postal Mail, Tasks)
  • Campaigns
  • Campaign Emails
  • Tickets
  • Ticket History
  • Owners (Users Data)
  • Product Libraries
  • Line Items
  • Form Submissions
  • Form Analytics
  • Deals
  • Deal History
  • Custom Objects
  • Quotes
  • Lists (Contact, Company, Deal, Custom Object)
  • Website Pages
  • Website Page Analytics
  • Contact Web Traffic Data
  • 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
  • Companies
  • Deals
  • Engagements (Calls, Communications, Emails, Meetings, Notes, Postal Mail, Tasks)
  • Campaigns
  • Campaign Emails
  • Tickets
  • Ticket History
  • Owners (Users Data)
  • Products
  • Line Items
  • Form Submissions
  • Form Analytics
  • Deals
  • Deal History
  • Custom Objects
  • Quotes
  • Lists (Contact, Company, Deal, Custom Object)
  • Website Pages
  • Website Page Analytics
  • 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
 

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.

 

 

19+

HubSpot Integrations

8000+

Successful Installs

2 Billion

Records Processed Daily

19+

HubSpot Integrations

8000+

Successful Installs

2 Billion

Records Processed Daily

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

Trusted by