Registering the HubSpot Connection
Identify if the hubspot jar is available on the application server under $IW_HOME/oem/driver/hubspot
Navigate to the Extensions pane and register the cdata driver by providing appropriate class name by uploading the jar to the server(If it does not exist already on the application server.
Navigate to http://cdn.cdata.com/help/DHF/jdbc/ to identify the data model, jdbc connection string parameters and limitations.
Creating a HubSpot Source in Infoworks
Ensure that the user that will be provided in the source configuration has privileges to all the scopes.
Create a Source with appropriate name and select the source type as the name provided during registering the driver.
Provide the following parameters to establish a connection and perform an ingestion. (Note - Some tables require a filter condition as a mandatory requirement. Please refer to the data model in the cdata link provided above)
Save the details and perform a Test Connection and Crawl the Metadata.