Version 5.1 - August 17, 2018

This release comes with the following updates and enhancements:

  • Enhancement: We have updated the license manager program to now report details of distinct connections in use.
  • Fixed: Our software may report a connection metering related error during runtime for some specific system environments.

Version 5.0 - April 26, 2018

This release comes with the following updates and enhancements:

  • New: We added support for reading Contact's form submission information in HubSpot Source component.
  • New: HubSpot Source component now outputs enumeration label values along with the internal values when reading from Deal, Company and Contact objects.
  • New: We added support of returning lastupdatetime when reading recent Campaigns in HubSpot Source component.
  • New: We added support for Azure-SSIS Integration Runtime (IR) deployment and licensing.
  • New: Standard use licensing model, this limits the number of distinct connections to 8 per connection type within a 24 hour period at runtime.
  • Enhancement: We added command line support for HubSpot Token Manager program.
  • Update: We have an updated version of License Agreement that covers the new Azure-SSIS IR licensing model along with many other revisions - the new agreement becomes effective as of today (April 26, 2018).
  • Fixed: Parameterizing sinceDateTime in HubSpot Source component may not work properly.
  • Fixed: You may run into "Unrecognized Guid format" error when reading from Form object.
  • Fixed: You may get error "System.FormatException" when reading from EmailEvent in some unique situations.
  • Fixed: HubSpot Source component might crash if an invalid sinceDateTime is provided.

Version 4.2 - December 14, 2017

This release comes with the following updates and enhancements:

  • New: We added support for retrieving recently modified Engagement objects in HubSpot Source component.
  • Update: Update of licensing component to better support servers within a clustered environment to minimize potential false licensing errors.

Version 4.1 - October 6, 2017

This release comes with the following updates and enhancements:

  • New: We added support of reading recent Created contacts in HubSpot Source component.
  • New: We added a sinceDateTime filter parameter in HubSpot Source component, which can be used to retrieve contacts records relative to a given date when the Recently Created Only or Recently Modified Only option is enabled.
  • New: We added support for reading and writing Associated Deals.
  • New: We added a documentation generation button to all SSIS components that can be used to generate a Word document which describes the component's metadata including relevant mapping, and so on.
  • New: Connections to HubSpot are now made with the latest and greatest TLS protocol whenever possible.
  • Fixed: API Throtting Rate in HubSpot Connection Manager may not work properly for some particular timezones.
  • Fixed: "Auth In App" option in HubSpot Connection Manager does not include all scopes during the authorization.
  • Update: Some updates to the licensing component.

Version 4.0 - July 7, 2017

This release comes with the following updates and enhancements:

  • New: We added support for SQL Server 2017.
  • New: HubSpot connection manager now support listing existing tokens.
  • New: We added an expression button in HubSpot source components.
  • New: We added an expression button in HubSpot destination components.
  • Fixed: You may get error "Bad Request" when importing token in HubSpot Token Manager.
  • Enhancement: Improved high-DPI support.
  • Enhancement: Some minor GUI improvements.
  • Enhancement: We added command line support for License Manager program.
  • Update: We no longer deploy Newtonsoft.Json.dll assembly to Windows GAC.
  • Fixed: If you have an Ultimate trial license, it may still report as not licensed.

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 manager.
  • 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 display 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.