Sync data from Azure Synapse to HubSpot

Azure Synapse Analytics to HubSpot

‍

1. Setup a Data Warehouse - Go to Data Warehouses Tab add an Azure Synapse Analytics Warehouse.‍

‍

2. Setup a Data Model - Navigate to Data Models tab and click on Create New. Name your Data Model and select your data warehouse from the drop down. Write a SQL query to fetch data from your warehouse. 

(Eg. Select * from Schema_Name.Table_Name)

*A simple “select” statement will work, although you can write complex SQL queries in the data model field itself or use our no-code segment builder to filter your data without writing complex SQL Queries.

‍ ‍You can fetch data directly from any table / view existing in your warehouse if you don’t want to set up a data model. In that case you can skip this step and directly move to configuring your destination.

‍

3. Configure your Data Destination - Navigate to All Destinations Tab inside Reverse ETL and select HubSpot.

• Add Your Credentials using the “+” Button.
• Click on “+Data Sync” to start adding Data Syncs to your account.