SSIS Hubspot Connector Hubpost Connector can be used to integrate Hubspot and your data source, e.g. Microsoft SQL Server, Oracle, Excel, Power BI, etc. Get, write, delete Hubspot data in a few clicks! You can use this connector to integrate REST API data inside SSIS and SQL Server. Let's take a look at the steps below to see how exactly to accomplish that. Download  Help File  Buy  If you are new with SSIS and ZappySys SSIS PowerPack then check below links to get started. How to get started with SSIS and SSIS PowerPack. it covers how to install necessary tools to design/debug SSIS Packages, deploy to SSIS catalog and last Schedule SSIS Package to run using SQL Agent. It will also cover how to secure SSIS package and Parameterize values (e.g. Password, Hostname, etc). SSIS API Source Help File SSIS API Destination Help File

See also Connect Hubspot in SQL Server Connect Hubspot in Power BI Connect Hubspot in SSRS Connect Hubspot in Informatica Connect Hubspot in MS Access Connect Hubspot in MS Excel Connect Hubspot in SSAS Connect Hubspot in C# Connect Hubspot in Python Connect Hubspot in JAVA Connect Hubspot in Tableau Connect Hubspot in SAP Crystal Reports Connect Hubspot in ODBC

Video Tutorial - Read Hubspot data in SSIS

This video covers following and more so watch carefully. After watching this video follow the steps described in this article.

• How to download SSIS PowerPack for Hubspot integration in SSIS
• How to configure connection for Hubspot
• How to Read data from Hubspot
• Features about SSIS API Source
• Using Hubspot Connector in SSIS

Step-By-Step: How to read from Hubspot in SSIS (Export data)

In this section we will learn how to configure and use Hubspot Connector in the API Source to extract data from the Hubspot.

1. Prerequisite: you must have downloaded and installed SSIS PowerPack. Check Getting started section for more information.

2. Begin with opening Visual Studio and creating new SSIS package Project.

3. Now, Drag and Drop SSIS Data Flow Task from SSIS Toolbox.
   

4. Double click on the Data Flow Task to see Data Flow designer.

5. From the SSIS toolbox drag and drop API Source (Predefined Templates) on the data flow designer surface, and double click on it to edit it:
   

6. Select New Connection to create a new connection:
   

7. Use a preinstalled Hubspot Connector from Popular Connector List or press Search Online radio button to download Hubspot Connector. Once downloaded simply use it in the configuration:
   

   Hubspot

   

8. Proceed with selecting the desired Authentication Type. Then select API Base URL (in most cases default one is the right one). Finally, fill in all the required parameters and set optional parameters if needed. You may press a link Steps to Configure which will help set certain parameters. More info is available in Authentication section.

   Steps to get Hubspot Credentials
   

   Just follow this link on how to create an API app: https://developers.hubspot.com/docs/api/creating-an-app

   API Reference (External Site)

   Hubspot

   User Credentials [OAuth]

   https://api.hubapi.com

   Required Parameters
   UseCustomApp	Fill in the parameter...
   Scope	Fill in the parameter...
   Optional Parameters
   Client ID	Fill in the parameter...
   Client Secret	Fill in the parameter...
   ReturnUrl	Fill in the parameter...

   

9. Select the desired endpoint, change/pass the properties values, and click on Preview Data button to make the API call.

   API Source - Hubspot

   Hubpost Connector can be used to integrate Hubspot and your data source, e.g. Microsoft SQL Server, Oracle, Excel, Power BI, etc. Get, write, delete Hubspot data in a few clicks!

   

10. That's it; we are done. In a few clicks we configured the call to Hubspot API using ZappySys Hubspot Connector

Video Tutorial - Write or lookup data to Hubspot using SSIS

This video covers following and more so watch carefully. After watching this video follow the steps described in this article.

• How to download SSIS PowerPack for Hubspot integration in SSIS
• How to configure connection for Hubspot
• How to Write or lookup data to Hubspot
• Features about SSIS API Destination
• Using Hubspot Connector in SSIS

Step-By-Step: How to write to Hubspot in SSIS (Import data)

In upper section we learned how to read data, now in this section we will learn how to configure Hubspot in the API Source to Post data to the Hubspot.

1. Prerequisite: you need to have SSIS ZappySys PowerPack downloaded and installed. Check Getting started section for more information.

2. Firstly, open Visual Studio and create a new SSIS Package Project.

3. Now, drag and drop SSIS Data Flow Task from SSIS Toolbox.
   

4. Double click on the Data Flow Task to see Data Flow Designer view.

5. Read the data from the source, being any desired source component. In example we will use ZappySys Dummy Data Source component.

6. From the SSIS Toolbox drag and drop API Destination (Predefined Templates) on the Data Flow Designer surface and connect source component with it, and double click to edit it.
   

7. Select New Connection to create a new connection:
   

   API Destination - Hubspot

   Hubpost Connector can be used to integrate Hubspot and your data source, e.g. Microsoft SQL Server, Oracle, Excel, Power BI, etc. Get, write, delete Hubspot data in a few clicks!

   

8. Use a preinstalled Hubspot Connector from Popular Connector List or press Search Online radio button to download Hubspot Connector. Once downloaded simply use it in the configuration:
   

   Hubspot

   

9. Proceed with selecting the desired Authentication Type. Then select API Base URL (in most cases default one is the right one). Finally, fill in all the required parameters and set optional parameters if needed. You may press a link Steps to Configure which will help set certain parameters. More info is available in Authentication section.

   Steps to get Hubspot Credentials
   

   Just follow this link on how to create an API app: https://developers.hubspot.com/docs/api/creating-an-app

   API Reference (External Site)

   Hubspot

   User Credentials [OAuth]

   https://api.hubapi.com

   Required Parameters
   UseCustomApp	Fill in the parameter...
   Scope	Fill in the parameter...
   Optional Parameters
   Client ID	Fill in the parameter...
   Client Secret	Fill in the parameter...
   ReturnUrl	Fill in the parameter...

   

10. Select the desired endpoint, change/pass the properties values, and go to the Mappings tab to map the columns.

    API Destination - Hubspot

    Hubpost Connector can be used to integrate Hubspot and your data source, e.g. Microsoft SQL Server, Oracle, Excel, Power BI, etc. Get, write, delete Hubspot data in a few clicks!

    

11. Finally, map the the desired columns:

    API Destination - Hubspot

    Hubpost Connector can be used to integrate Hubspot and your data source, e.g. Microsoft SQL Server, Oracle, Excel, Power BI, etc. Get, write, delete Hubspot data in a few clicks!

    

12. That's it; we successfully configured the POST API Call. In a few clicks we configured the Hubspot API call using ZappySys Hubspot Connector

Conclusion

In this article we discussed how to connect to Hubspot in SSIS and integrate data without any coding. Click here to Download Hubspot Connector for SSIS and try yourself see how easy it is. If you still have any question(s) then ask here or simply click on live chat icon below and ask our expert (see bottom-right corner of this page).

Download Hubspot Connector for SSIS Documentation 

Other App Integration scenarios for Hubspot

Other API Connectors for SSIS

Download Hubspot Connector for SSIS Documentation 

Common Searches: