Building the Connection URL

Use the connection URL to supply connection information to the data store that you are accessing. The following is the format of the connection URL for the Simba HubSpot JDBC Connector:

jdbc:hubspot://localhost;Host=[InstanceURL];Auth_Type=[AuthenticationMethod];[Property1]=[Value];[Property2]=[Value];...

The variables are defined as follows:

  • [InstanceURL] is the URL of the HubSpot instance that you are connecting to.
  • [AuthenticationMethod] is the authentication method used to connect to the HubSpot instance.
  • [Property] is any one of the other connection properties supported by the connector. At minimum, you must set the properties that provide your credentials for authentication. For more information about configuring authentication, see Configuring Authentication.

For example, to connect to HubSpot and authenticate the connection using an access token, you would use the following connection URL:

jdbc:hubspot://localhost;Host=https://api.hubapi.com;Auth_Type=Access Token;Auth_AccessToken=f357a49a-c75c-417c-b002-2f81242df409;

Important:

Do not duplicate properties in the connection URL.

Related topics