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 

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.
    SSIS Data Flow Task - Drag and Drop

  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:
    SSIS API Source (Predefined Templates) - Drag and Drop

  6. Select New Connection to create a new connection:
    API Source - 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
    Hubspot Connector Selection

  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...
    ZappySys OAuth Connection

  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!
    API Source - Select Endpoint

  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.
    SSIS Data Flow Task - Drag and Drop

  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.
    SSIS API Destination (Predefined Templates) - Drag and Drop

  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!
    API Destination - New Connection

  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
    Hubspot Connector Selection

  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...
    ZappySys OAuth Connection

  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!
    API Destination - Select Endpoint

  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!
    API Destination - Columns Mapping

  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).

Documentation 

Other App Integration scenarios for Hubspot

Other API Connectors for SSIS


Documentation 

  • How to connect Hubspot in SSIS?

  • How to get Hubspot data in SSIS?

  • How to read Hubspot data in SSIS?

  • How to load Hubspot data in SSIS?

  • How to import Hubspot data in SSIS?

  • How to pull Hubspot data in SSIS?

  • How to push data to Hubspot in SSIS?

  • How to write data to Hubspot in SSIS?

  • How to POST data to Hubspot in SSIS?

  • Call Hubspot API in SSIS

  • Consume Hubspot API in SSIS

  • Hubspot SSIS Automate

  • Hubspot SSIS Integration

  • Integration Hubspot in SSIS

  • Consume real-time Hubspot data in SSIS

  • Consume realtime Hubspot API data in SSIS

  • Hubspot ODBC Driver | ODBC Driver for Hubspot | ODBC Hubspot Driver | SSIS Hubspot Source | SSIS Hubspot Destination

  • Connect Hubspot in SSIS

  • Load Hubspot in SSIS

  • Load Hubspot data in SSIS

  • Read Hubspot data in SSIS

  • Hubspot API Call in SSIS