Data Type Mappings

The connector maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings, which apply to every schema the connector exposes.

HubSpot Field Type	CData Schema
Date picker	date
Dropdown select	string
HubSpot user	string
Multi-line text	string
Multiple checkboxes	string
Number	double or decimal, as described below
Radio select	string
Single checkbox	string
Single-line text	string

Number Fields

HubSpot reports all numeric fields using a single generic number type, so the connector cannot infer the exact numeric type of a field. The schema in use determines how the connector resolves this:

• In the HubSpot schema, number fields are always reported as double.
• In all other schemas, number fields are reported using the type set by NumberColumnMode, which defaults to decimal. Calculated rollup fields defined by HubSpot are an exception: these are always reported as string.