Data Visualization with kdb+ using ODBC: A Tableau case study

18 Jul 2018 | , ,
Share on:

By Michaela Woods

In our latest technical white paper Kx engineer Michaela Woods writes about how to use kdb+ with an ODBC driver for data visualization. Dynamic, custom data visualizations are used for business intelligence (BI) tools across industries. While Kx provides its own visualization tool, Dashboards for Kx, clients may have incumbent solutions they wish to retain and independently connect to kdb+. Alternatively, many organizations may wish to migrate their backend database to kdb+ for increased efficiency and scalability, while at the same time retaining their existing visualization front end. In her paper, Michaela aims to provide guidance on how such integrations may be achieved.

Focusing on Tableau, a widely used BI tool, Michaela shows how it can be used to access kdb+ via ODBC.  Her paper illustrates the flexibility by which kdb+ data can be accessed by Tableau using ODBC and explains how kdb+’s caching feature may be used in this instance to improve performance by optimizing repeated queries. Guidelines on connection, setup, queries and advice on how to maximize performance are discussed throughout the paper. For both new and existing users, this paper aims to reduce the learning curve, boost efficiency and increase usability when combining these two technologies.

You can read the full paper on the Kx Developers’ site here.

SUGGESTED ARTICLES

Kx insights: powering business knowledge with kdb+

Kx Insights: Powering Business Decisions with Bitemporal Data

29 Jun 2017 | , , , ,

In order to be able to gain business insights in today’s rapidly changing business environments, organizations have to represent data from their assets and operations across many dimensions of time. In particular, the ability to go back in history and replay streaming data, like, for instance, trading activity, can materially impact going-forward business decisions. This paper draws on real world examples and how Kx technology has been applied to address them.