JDBC TUTORIAL

Connect to Aha! from Tableau for your Analytics and Reporting

Updated: 15 Jul 2024

Introduction

Aha! is a SaaS application that helps Product Managers build and share visual roadmaps for their organization. It links key strategic goals and initiatives to releases and features so business objectives can be tracked through product management and development. There area lot of insights that can be discovered but accessing Aha! data from tools like Tableau, Tibco, etc. can be tricky. With the Progress DataDirect Aha! JDBC connector, you can now connect to your data in Aha! as easily as you could with any JDBC driver. In this tutorial, we will walk you through how easily you can connect and access to Aha! data and generate reports on it from any supported JDBC compliant reporting tool.

Download and Install Progress DataDirect Aha! JDBC connector

  1. Download Progress DataDirect Aha! JDBC connector from here.
  2. Installing the Driver
    • If you are on Windows, extract the PROGRESS_DATADIRECT_JDBC_AHA_6.0.0_WIN.zip and run the PROGRESS_DATADIRECT_JDBC_INSTALL.exe to install the JDBC driver.
    • If you are on Linux, extract the PROGRESS_DATADIRECT_JDBC_AHA_6.0.0.zip and run the PROGRESS_DATADIRECT_JDBC_INSTALL.jar to start the installation.
  3. After you have completed the installation, you can find Progress DataDirect Aha! JDBC connector

    • On Windows, you will find it at
      C:\Program Files\Progress\DataDirect\JDBC_60\lib\aha.jar
    • On Linux, you will find it at /home/<username>/Progress/DataDirect/JDBC_60/lib/aha.jar

Gathering Aha! authentication details

Before we get started on Aha! connector configuration, let’s look at supported Aha! authentication methods and the how you can get the details needed for the specific authentication method you want to use.

  1. Progress DataDirect Aha! JDBC connector supports 3 authentication methods – Basic, URL Parameter and OAuth2.
  2. For basic authentication, you will need to have Username and Password for your Aha!.
  3. For URL Parameter authentication
    • Go to Settings -> Personal -> Developer -> API Keys
    • Click on Generate API Key, provide a name in the pop up and generate API Key.


      create api key

    • Copy the API Key that got generated and store it.
  4. For OAuth2 authentication,
    • Go to Settings -> Personal -> Developer -> OAuth applications and click on Register OAuth application
    • Provide a Name for OAuth application and Redirect URI you want to use to get the access token.


      Create OAuth App

      Note: The Redirect URI needs to be https

       

    • Click on Create, on the next screen you should see the OAuth credentials. Copy the Authorize URL and paste it in your browser. You should see the below Authorization screen. Click on Authorize.


      Authorize Aha!

Configure Connection to Aha!

  1. Progress DataDirect Aha! JDBC connector comes with inbuilt JDBC Configuration manager that helps you configure the connection to your Aha! instance easily.
  2. To Launch the Aha! JDBC Configuration Manager, double click the aha.jar or run using java -jar aha.jar
  3. You should now see the below configuration manager launched in your browser

    Aha Configuration Manager

  4. Provide the Server name for your Aha! instance in the Server Name text box.
  5. Next, choose the Authentication Method you want to use from the drop down.
  6. If you are using
    • Basic – Fill in the username and password for your Aha!
    • URL Parameter – Fill in the API Key you generated in step 3 in previous section in the Security Token text box as shown below.


      URL Parameter Authentication

    • OAuth2 – Fill in the Access Token you generated in the Step 4 of previous section and paste it to the Access Token text field as shown below.


      OAuth2 Authentication

  7. Click on Test Connect. Now you should see list of tables exposed by the Progress DataDirect Aha! JDBC driver.

    Test Connect

  8. You can start testing out the queries, and once you are done – you can copy the JDBC connection string so that you can start using the Progress DataDirect Aha! JDBC driver with other applications or in your programs.

Connect any application to any data source anywhere

Explore all DataDirect Connectors

Need additional help with your product?

Get Customer Support