Configuring Authentication

To protect data from unauthorized access, HubSpot data stores require connections to be authenticated with user credentials or an access token. The Simba HubSpot ODBC Driver provides full support for these authentication protocols.

The Simba HubSpot ODBC Driver uses the OAuth 2.0 protocol for authentication and authorization. You can authenticate your connection through OAuth 2.0 by specifying an access token, or by providing your HubSpot credentials so that the connector retrieves and uses the corresponding access token.

Note:

When using the Simba HubSpot ODBC Driver DSN Setup dialog box, do not specify any values in the Refresh Token field. Currently, the connector does not support the use of refresh tokens unless the token is specified in a connection string. For more information, see Using a Connection String.

Configuring Authentication With an Access Token

If you already have a valid access token, specify it in your DSN so that the connector can use it to authenticate the connection.

To configure authentication with an access token:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Access Token field, type or paste your access token.
  3. To save your settings and close the Simba HubSpot ODBC Driver DSN Setup dialog box, click OK.

Configuring Authentication With Your HubSpot Credentials

You can configure the connector to retrieve and use an access token based on your HubSpot credentials.

To retrieve an access token:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Client ID field, type the client ID associated with your HubSpot application.
  3. In the Client Secret field, type the client secret associated with your HubSpot application.
  4. In the Scope field, type a space-separated list of OAuth scopes for the access token.
  5. In the Hub ID field, type the ID of your HubSpot application.
  6. Click Get Access Token.
    A web browser opens.
  7. In the web browser, log in to your HubSpot account with your HubSpot user name and password, and click Sign In to allow the connector to access your HubSpot data store.
  8. Click the account you want to sign in to.
  9. In the DSN setup dialog box, confirm that the Access Token field is populated. Then close the browser window.
  10. To save your settings and close the Simba HubSpot ODBC Driver DSN Setup dialog box, click OK.

Related topics