Replicate the Quotes data into SQL server

Developer Support APIs & Integrations
1

Hi All,

The goal is to replicate or migrate the Hubspot data from Hubspot to SQL server.

I have used an application/tool called Skyvia with this, have imported all the data except Quotes.

So is there any way to export the Quotes data into the SQL server?

Will be glad if someone helps me through this.

Thanks in advance.

2

Hey @Kavya

I wonder if @lynton has a nifty solution for this.

3

Are you familiar with the data available through the quotes api? (Documentation here)

Much of the data on a quote is also available from the Deals API, since a quote is associated with a deal.

So first confirm that you want and need the data from the Quotes API. As for solutions: you would need to build a custom API sync into SQL. I’ve seen people do this with custom stored procedures and SSIS packages. I’m not aware of any off-the-shelf integration tools (like Skyvia) that include support for the Quotes object.

4

@Kavya @dennisedson We offer an app in the HubSpot App Marketplace called MS SQL Server for HubSpot . This app does what you are looking for without needing Skyvia or any other tools. A SQL data warehouse in Azure is included.