Read and write HubSpot data in SSIS using prebuilt API Source and API Destination components.

Configure HubSpot authentication with Private App tokens or OAuth, select endpoints, preview payloads, and map columns for contacts, companies, deals, and tickets in a guided UI without custom API scripts.
Part of ZappySys SSIS PowerPack (100+ connectors & tasks).

Recommended starting point

View Setup Guide & Get Started →

See features, UI & examples →

Pro Tip: The Visual Studio download installs the VSIX shell. Use the guide above to install and run the full SSIS PowerPack runtime and components.

Compatibility: SQL Server 2012-2025+ (32/64-bit) | Azure Data Factory / Azure-SSIS IR Ready

⚡ Key Benefits

Bi-Directional Integration — Read from and write to HubSpot in one SSIS workflow
Guided Authentication — Configure Private App token or OAuth settings in the connection manager UI
Endpoint-Level Control — Select HubSpot actions and preview responses before execution
Flexible Mapping — Map source fields to HubSpot payload columns for insert, update, and lookup flows
Resilient API Handling — Use retry options for API throttling responses such as 429

📸 Visual Overview & Setup

1. Drag API Source from Toolbox 🔍 View Full Size	2. Drag API Destination from Toolbox 🔍 View Full Size	3. Pick or Create HubSpot Connector 🔍 View Full Size
4. Map the Columns 🔍 View Full Size	5. Select Endpoint and Preview data 🔍 View Full Size	6. Destination Mapping & Execute 🔍 View Full Size

🔧 Key Features

HubSpot Read + Write Flows

Use API Source to export HubSpot records to downstream SSIS components
Use API Destination for insert, update, delete, and lookup-style operations
Build contact, company, deal, and ticket pipelines in one package

Authentication Scenarios

Private app (Static Access Token) configuration in the connection manager
Public app OAuth flow with client settings and token generation support
Optional retry tuning for throttling status codes and transient API failures

Connector Lifecycle

Choose from Popular Connector List or Search Online to download connector files
Load saved connector files from disk for controlled deployments
Modify connection parameters and endpoint inputs per action

Execution Readiness

Preview API responses before finalizing mappings
Map source and target columns using built-in mapping UI
Deploy to SQL Server Catalog and run in Azure-SSIS IR when needed

💡 Common Use Cases

Typical SSIS scenarios powered by SSIS Hubspot Connector:

CRM Sync Pipelines: Extract HubSpot objects and load them into SQL Server or PostgreSQL for reporting and analytics.
Operational Upserts: Push curated records from internal systems into HubSpot using API Destination mapping.
Data Quality Workflows: Read source data, transform in SSIS, then write cleaned records back to HubSpot entities.
Incremental Integrations: Handle throttling-sensitive API workloads with retry options and controlled endpoint calls.
Hybrid Cloud ETL: Build and test locally in Visual Studio, then run scheduled pipelines in SQL Agent or Azure-SSIS IR.

🎯 Summary

SSIS Hubspot Connector gives ETL teams a practical way to read and write HubSpot data in SSIS using guided API Source and Destination setup.
You get endpoint selection, authentication options, and mapping controls in one consistent workflow.

Trusted by Developers & IT Teams Worldwide

Built for SSIS Workflows: Designed for API-driven ETL with source and destination patterns.
Expert Technical Support: Reach ZappySys engineers via support and guided setup resources.
Proven Enterprise Adoption: Used globally across data integration, automation, and reporting teams.

SSIS PowerPack

Includes SSIS Hubspot Connector