Version 3.0 - March 15, 2017

This release comes with the following updates and enhancements:

  • New: We added support for OAuth 2.0 authentication in the HubSpot connection mananger.
  • New: We added a ProxyMode option to HubSpot connection manager, which now supports three types of proxy mode: No Proxy, Auto-detect and Manual. 
  • Update: We updated the service method to get metadata properties of Company, Contact and Deal as the old URLs are deprecated.
  • Update: We have an updated license agreement.
  • Fixed: We fixed the UI diaplay issue under high DPI setting.
  • Fixed: You may get error "Could not determine JSON object type for type Microsoft.SqlServer.Dts.Pipeline.BlobColumn." when sending a DT_NTEXT type column to HubSpot destination component.

Version 2.0 - January 27, 2017

This release comes with the following updates and enhancements:

  • New: We added support for Engagement object in the HubSpot source component.
  • New: We added support for Engagement object in the HubSpot destination component.
  • New: We added options for receiving all records or recent created/modified records for Company and Deal objects in the HubSpot source component.
  • New: We added options for receiving all Contact records or recent Contacts in the HubSpot source component.
  • Update: HubSpot date type property now outputs in SSIS DT_DATE type.
  • Enhancement: Improved handling of retry on intermittent errors.
  • Enhancement: Updated the metadata for Campaign object.
  • Fixed: For some objects, the HubSpot destination component does not direct the defaut output rows.

Version 1.4 - October 24, 2016

This release comes with the following updates and enhancements:

  • Fixed: HubSpot components sends duplicate metadata calls when refreshing the components.
  • Fixed: HubSpot destination component might ignore the batch size setting when using "Upsert" action with Contact object.
  • Update: The license manager now supports co-termed subscription license.
  • Update: We have lowered the minimum requirement of SQL Server editions when using our software.

Version 1.3 - August 10, 2016

This release comes with the following updates and enhancements:

  • New: We added support for Campaign object in the HubSpot source component.
  • New: We added support for Email Campaign object in the HubSpot source component.
  • New: We added a new object called Contact Company Association in HubSpot destination component which can be used to associate/dissociate between contacts and companies.
  • New: We added a new filter parameter called listid in the HubSpot source component which can be used to read all Contact records in the specified list.
  • Fixed: HubSpot destination component might emit duplicate rows in its Default Output when using "Upsert" action with Contact object.
  • Update: We upgraded the JSON library (Newtonsoft.Json.dll) to the latest version (v9.0.1)

Version 1.2 - May 5, 2016

This release comes with the following updates and enhancements:

  • New: We added column/field filtering capabilities in HubSpot source component editor window.
  • Enhancement: Updated support for the latest SQL Server 2016 release candidate builds.
  • Enhancement: Running the 32-bit installation package on a 64-bit operating system is now blocked, as doing so makes our connection manager unrecognizable in 64-bit runtime.
  • Enhancement: We removed the requirement of .NET Framework 3.5 SP1 for SSIS 2012 and later.
  • Fixed: Incorrect data type for HubSpotRecordId column returned by the HubSpot destination component.

Version 1.1 - January 22, 2016

This release comes with the following updates and enhancements:

  • New: We have added support for SQL Server 2016.

Version 1.0 - September 15, 2015

This is our first public release of SSIS Integration Toolkit for HubSpot software.

  • Four main components
    • HubSpot Connection Manager
    • HubSpot Source Component
    • HubSpot Destination Component
    • HubSpot Token Manager
  • Support for SSIS 2016, 2014, 2012, 2008R2, 2008, or 2005
  • Support for the following four actions in HubSpot Destination Component
    • Create
    • Update
    • Upsert
    • Delete
Update: We have an updated license agreement.