Tech Blog

Tableau Web Data Connector for Ex Libris Analytics

Many Ex Libris customers use Tableau Software for business intelligence. Tableau provides a way to visualize data from various sources, and offers special pricing for academic institutions, making it an attractive option for many university libraries. In a recent Show & Tell sponsored by the ELUNA/IGELU Interoperability Special Interest Working Group, Joan Kolarik showed a prototype connecting Tableau to Alma Analytics via a Tableau Web Data Connector. In this blog post we’re announcing an open source Ex Libris web data connector for use by all Ex Libris customers. The connector is open source and available for everyone.

Below is a brief description of the connector. For a detailed how-to on using the web data connector, see this presentation.

To use the web data connector, download Tableau Desktop. Open a new workbook, click connect to data source, and select Web Data Connector.

 

When prompted for the URL of the web data connector, enter the following and hit enter:

https://eu-st01.ext.exlibrisgroup.com/delivery/wdc/exl.html

 

You’ll be provided with a form to enter the relevant Ex Libris Analytics details:

 

You’ll need to fill out the following fields:

  1. API Key– retrieve an API key from the Ex Libris Developers Network. The key should have permissions for the analytics APIs. For more information on obtaining an API key, see the Getting Started guide.
  2. Report Path– the path of the analytics report from which you wish to use data. The easiest way to retrieve the path is to open the report in Analytics and then copy the path parameter from the URL, as seen below.
  3. Region– the region of your Alma instance

 

Once you’ve filled in the information, click the “Get data” button. Tableau will fill in the columns from the selected report.

 

To retrieve the data, click “Update Now”. Tableau will retrieve the data from Analytics and present it in the workbook:

 

From here you can work with the data from your Ex Libris products as you would any other data source in Tableau. For more information on how to use Tableau Desktop, you can browse their extensive training videos.The connector is a work in progress. We welcome community participation at this Github repository. Feel free to open an issue or make pull requests.

 

5 Replies to “Tableau Web Data Connector for Ex Libris Analytics”

  1. Has the WDC been updated after the latest changes in Leganto? I was able to update in june, but now it’s not working any more (loading fails)

    By Lars Hansen on August 1, 2018 at 10:33 AM

  2. It’s working great in 2019.2 including publishing to Tableau Server!! However, there is a whitelisting issue that is preventing scheduling a daily data refresh. I have opened a Salesforce ticket (#00703663).

    Thanks so much for building this for us!!

    1. Thanks for your comments Lisa. It appears from Tableau’s website that this is a limitation of Tableau online. See their KB article KB article. They suggest using a “Tableau Bridge” to enable this integration. I don’t have any experience with the Tableau Bridge but if you look into it we’d love to hear what you find.

  3. Thanks for the info, Josh! I really appreciate you taking the time to reply!

    We cannot use Tableau Bridge, however, because we’re not using Tableau Online… We’re using Tableau Server and according to them, as long as the Tableau Server machine can ping/communicate with the server hosting the database, we should be able to establish a live connection.

Leave a Reply