Exponam.Connect vs. the competition

[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

 

 

 

 

 

What Data Platform Companies Don’t Understand About Democratizing Data

TL;DR:

Data platform companies are integrating generative AI into their offerings, believing it will make their products more accessible to non-technical business users. They are mistaken. Most non-technical users will not utilize these platforms.

Instead, data technology companies must meet users where they already work—and overwhelmingly, business users work in Microsoft Excel.

A History of Missed Opportunities

For decades, companies have tried—and failed—to lure business users away from Excel.

  • 1990s: WYSIWYG (What You See Is What You Get) report-building interfaces promised ease of use, but adoption remained low.
  • 2000s: Visual object-based tools gave way to low- and no-code solutions, all designed to entice users to more sophisticated platforms—but business users stayed in Excel.
  • Today: Generative AI and natural language query overlays promise to finally bridge the gap, enticing business users to transition. But history and behavioral studies tell us otherwise.

Generative AI—The Holy Grail?

Data technology companies are convinced that this time will be different.
With generative AI adoption skyrocketing—40% of users already engaging with AI-driven applications—companies believe they can finally pull users into their platforms.

But History Speaks—And We Should Listen

What these companies fail to grasp is where users are embracing AI tools: within the platforms they already use.

Business users will absolutely leverage generative AI—but they will do so in Excel, not in a developer’s platform.  They won’t use an overlay AI on a SQL editor or Python notebook any more than they’d build their own BI reports in Tableau.

Data companies will lure some users to their platforms – but only those who were already technologically savy enough to be adept within BI platforms.  The vast majority of users will remain planted in Excel.

Decades of research confirms a simple truth: users don’t migrate to new data platforms.

Stop trying to force solutions on business users.

True Data Democratization

Tech companies often tout the idea of “democratizing data,” yet repeatedly make the same mistake:
They house data—and the tools to access it—inside platforms most users will never touch.

If you truly want to democratize data, meet users where they live.  And they live in Excel.

Exponam is redefining what it means to make data accessible.  With Exponam.Connect, we bring Databricks data directly into Excel—faster, easier, and at a fraction of the cost of other solutions.

By enabling business users to work seamlessly within their preferred environment, Exponam.Connect and Excel are truly democratizing data.

Exponam Proud to Sponsor Databricks DATA+AI 2025

Exponam is proud to be a sponsor of the Databricks DATA+AI Summit happening June 9-12 in San Francisco.  We will be exhibiting our Exponam.Connect Excel Add-in solution.

Exponam.Connect is the Fastest, Easiest, and Cheapest way to consume Databricks data in Excel.  We are the only solution utilizing Delta Sharing – making us 10x faster than all other solutions AND incurring no Databricks Compute (DBUs)!  Come and see us in the Exhibition Hall to see Exponam.Connect in action and to learn more.

Databricks Model Execution in Excel with Exponam.Connect

24 May 2024:

Today, Exponam announced that Databricks Model Execution from within Excel is in private preview.  Enterprises can now make their models available to the entire organization – analysts, operations, finance, etc. – and anyone can access model generated data in Excel.  This is a milestone in the usage of Databricks Models.  For the first time, Machine Learning models are directly available to end users for business analytical and predictive use.

No Databricks knowledge is required.  No coding is required.

Users are guided via the Exponam.Connect UI to enter the correct input parameters for the model. The UI generates the correct custom function, populates it in Excel, and calls the Databricks model serving endpoint.  The user’s spreadsheet is immediately populated with the results of the model in Excel.

See more about Exponam.Connect

 

Table Discovery in Excel

New Feature Alert! – Enhanced Data Discovery

For Release 5/3/2024:

The Exponam.Connect Excel Add-in for Databricks now includes easy to use data discovery features for non-technical users.  This is in addition to the no-code, fast, and efficient data importing features which have been the products main feature since Databricks’ release of Delta Sharing.

Data table names are often not intuitive or meant for end-user ease-of-use.  Now, instead of seeing just table names and needing to look at the column data to see if it is the desired table, users in Excel see the table description and column information immediately.

“The new table discovery feature in Exponam.Connect further simplifies the business user’s journey in accessing enterprise data,” stated Roger Dunn, Exponam CTO.  “Non-technical users comprise the majority of data users within organizations.  We will continue to enhance features which make accessing and using data easy for non-technical business stakeholders.  Exponam.Connect is the first truly self-service data tool on the market for pulling data out of enterprise data lakes.”

New, Easier Excel Filtering in Exponam.Connect

Databricks partner Exponam now enables the easiest filtering of Databricks Data in Excel.

Right-click and you’re done!  Contextual filtering means filtering is now one step in Exponam.Connect Pro Excel Add-in for Databricks.  Of course, you can still filter by clicking the filter icon and setting your desired filter — but that is soooo 2020.

right-click to filter

Filter by Right-clicking on the data you want.