Connect to any REST API from Tableau

Download and Install Autonomous REST Connector

  1. Download and install Autonomous REST Connector for ODBC.
  2. Install the connector by running the setup executable file.

HubSpot Authentication

  1. HubSpot offers two means of authentication – OAuth and API Keys. Both mechanisms are supported by Autonomous REST Connector.
  2. For the purpose of the tutorial, we will use the API Keys for Authentication. Here’s an example of the request using the API Key.


Create the ODBC DataSource

  1. Open ODBC Administrator (64-bit) and click on Add to create a new data source.
  2. Choose DataDirect 8.0 Autonomous REST Connector as the driver.

    Choose ARC

  3. On the Configuration Window, provide a name to the data source and under REST Sample Path paste the endpoint you want to connect to. If we want to connect to Get All Companies endpoint, we just paste the endpoint in the REST Sample Path.

    Create Configuration

  4. Go to Authentication Tab and set:
    1. Authentication Method: UrlParameter
    2. Auth Param: hapikey
    3. Security Token: <Your-Hubspot-API-Key>

    Authentication Method configuration

  5. Click on Test Connect to connect to the HubSpot API.

Connect from Tableau

  1. Now connect to HubSpot from Tableau. In Tableau choose Other Databases (ODBC), and choose HubSpot as the DSN you have just created.

    Choose ODBC

  2. Now we see a list of tables made available by Autonomous REST Connector by normalizing the JSON response from HubSpot API.  Access the REST API data like always.


Connecting to Multiple Endpoints

  1. To configure multiple endpoints for Autonomous REST Connector, create a new file called and configure the endpoints as below and save the file.
  2. Open the ODBC Administrator, open the DSN configuration you have created and clear the REST Sample Path.
  3. Under REST Config File, browse to the configuration file as shown below.

    Configure REST File

  4. Click on Test Connect and to connect successfully.
  5. Open Tableau and refresh the connection. You will see more tables that normalized from HubSpot API by Autonomous REST connector.

    Tableau tables

  6. Choose to extract data or use Live Connection to request data from REST API on the fly using Autonomous REST Connector.


Feel free to download and try Progress DataDirect Autonomous REST Connector to connect to any REST API from Tableau. If you have any questions, feel free to talk to us.

Connect to any REST API from Tableau

View all Tutorials for:

Connect any application to any data source anywhere

Explore all DataDirect Connectors

Need additional help with your product?

Get Customer Support