Connect to Aha! data using JDBC for your Analytics and Reporting

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.

Create Reports using your BI/Analytics tools

  1. Now that you are familiar with the Aha! connector, you can start using the connector with your favorite tools like Tableau, Tibco, Jupyter, IBM Cognos, etc.
  2. Here’s an example of using Progress DataDirect Aha! connector with Tableau to generate some reports.
  3. To get started, copy aha.jar to C:\Program Files\Tableau\Drivers from the install location of the Aha connector as describe in section 2.
  4. Open Tableau and choose your datasource Other Databases (JDBC) as shown below.
  5. In the URL field, paste the connection string you generated in the previous section.

    Choose JDBC datasource

  6. Click on Sign In, now you should see list of schemas and on selection of schema AHA, you should now see list of tables as shown below.

    Table List

  7. You can now start dragging tables into the canvas or create custom queries and start creating reports on your Aha! data.

Reports 1


Reports 2

 

We hope this tutorial helped you to get started with Progress DataDirect Aha! JDBC connector and connect to your data in Aha! Feel free to contact us if you have any questions or issues using the driver, we will be happy to help you.

JDBC TUTORIAL

Connect to Aha! data using JDBC for your Analytics and Reporting

View all Tutorials

Connect any application to any data source anywhere

A product specialist will be glad to get in
touch with you