HubSpot

About HubSpot connector

Etlworks HubSpot connector allows fast, real-time access to HubSpot data. The connector supports most of the objects available through the HubSpot API and works just like any other database connector.

Etlworks partnered with CData to provide access to the HubSpot API using industry-standard JDBC protocol. Read about CData HubSpot JDBC connector. 

Prerequisites

Enable HubSpot connector for your Etlworks account. Contact support@etlworks.com to enable connector.

Creating a HubSpot app

To access HubSpot from Etlworks you must create a HubSpot app using HubStop developer account.

1. Log into your HubSpot developer account. If you don't have one go to https://developers.hubspot.com/ and click "Create a developer account".
2. Click Manage Apps.
3. Click Create App.
4. Click the Auth tab.
5. Make note of or copy the Client ID and Client Secret. 
6. Enter localhost:33333 in the Redirect URL field.
7. Add scopes you would like to have access to.
8. Click Save.

Creating a connection

Step 1. In the Connections, window click the + button, type in hubspot.

Step 2. Select HubSpot and enter the following parameters

• OAuth Client ID - the Client ID of the HubSpot app.
• OAuth Client Secret - the Client Secret of the HubSpot app.

Step 3. Obtain the Authorization code.

1. Go to HubSpot app.

2. Select Auth tab.

3. Click Copy Full URL,

4. Open the web browser and paste the URL. Click enter.

5. Select the actual HubSpot account, not the Developer account.

6. Authorize HubSpot app to access your HubSpot data.

7. Copy the code from the redirect URL.

Step 4. Paste the authorization code into OAuth Authorization Code field.

The authorization code is active for a short period of time (a few minutes). If it will expire before you were able to use it, you will need to repeat steps 3-7, starting from "Copy full URL".

Step 5. Test and save the connection.

Connection parameters

Read about available connection string options.

If you need to access a HubSpot via an SSH tunnel, you need to specify additional information in the "Connect over SSH tunnel" section of the connection screen.

• SSH Host - the name or IP address for the host accepting SSH connections.
• SSH Port - the port accepting SSH connections. The default value is 22.
• SSH User  - the user name
• SSH Password - the optional password
• Private Key File - the private key file in the pem or ppk format used for SSH authentication. Click the "Upload/Select ssh key" button to manage SSH keys using GUI. You can also upload the private key file manually and use the token {app.data} as a part of the filename, for example, {app.data}/keys/secret.pem. This parameter is optional.

• SSH Passphrase - the optional passphrase (password) used together with a private key file. 

Working with HubSpot

• Extracting data from HubSpot
• Loading data in HubSpot
• Exploring data in HubSpot