Use SQL Server Integration Services to Add HubSpot Contacts to MailChimp Lists

SSIS stands for SQL Server Integration Services and is a solution for building data integrations and workflow applications that integrate with SQL Server databases. As data integration processes increase in importance, organizations are looking for ways to simplify integration and manage workflows. 

In this article, we’ll walk you through how to design a data flow that adds new HubSpot contacts to a MailChimp list using CData SSIS Components for HubSpot and MailChimp. 

Connecting to HubSpot and MailChimp 

The email address of the HubSpot contact and the ID of the MailChimp list are required when adding HubSpot contacts to a MailChimp list. To get the information you need, use a CData MailChimp Source component and a CData HubSpot Source component. 

Getting the MailChimp List ID 

To get started,