We are trying to import HubSpot data to SQL server. We have installed CData provided ODBC driver for HubSpot. The ODBC connection works fine.
But the connectivity is not succeeding on creating a linked server in SQL server management studio (screenshot of the error has been attached). We are receiving a timeout error.
Has anyone tried bringing HubSpot data to SQL server before?