• Have HubSpot ADO.NET Provider Downloaded and Installed
• Create a Login to hubspot.com if you don't already have an account

1. Using Microsoft Word, Excel, or PowerPoint, navigate to Windward > Data Sources drop down > Data Sources. This will open the Connection Editor. 

2. In the Connection Editor Navigate to the "New" Tab and under Apps click HubSpot(CData)

3. Enter a Name for your data source connection

4. Enter the Name of the file authorization (After authorization, tokens will be saved in a file with this Name)

5. Click the Authorize Access to HubSpot button. You will be redirected to HubSpot login page in the browser

6. Login to HubSpot and choose your account, you will receive a successful notification.

7. Click Add, and then Test your connection. If all parameters and credentials are correct and a connection is made, you will receive a successful notification.

8. Click on Close to save your information