[Download this article as a pdf]
TL;DR
Exponam.Connect is the ideal choice for business and technical users to pull data from a Databricks Lakehouse into Excel. Exponam.Connect is the only option which accesses data via Delta Sharing. All other solutions on the market pull data via ODBC – with varying UI skins on top. As a result, Exponam.Connect is much faster (at least 10x) and much cheaper than all other options. And client testing routinely affirms that the Exponam.Connect experience is much easier and more intuitive than all others.
Summary Comparison
Introduction
Accessing Databricks data in Excel is a powerful and efficient way to extend the value of the Databricks platform. Pairing the power of the Databricks with Excel – the world’s most universal data platform – is required for many business solutions.
Users can connect to Excel via Delta Sharing and the Exponam.Connect Excel Add-in or an ODBC-based connector and Databricks SQL cluster compute. Which approach is best? It depends on who will be using the data and how.
Considerations
