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.”

Pivot Tables from Databricks Data

Just click “Add Pivot Table” and when you import data from Databricks into Excel with the Exponam.Connect Add-in, your pivot table is automatically added!

Exponam.Connect is the Easiest, Fastest, and Cheapest way to pull enterprise cloud Databricks data into Excel.  Thousands of non-technical global users can’t be wrong.  Contact us for a trial enterprise license.

10 Million Rows!

That’s right – Import 10,000,000 rows of Databricks data into Excel!  If you haven’t tried the Exponam.Connect Excel Add-in, now is the time.  This is the fastest, cheapest, and easiest way for ALL users to access Databricks data.

NO CODE.  NO CONFIGURATIONS.  NO REPORT DESIGNER.  Just EASY and FAST imports with NO databricks COMPUTE!

Contact us for a trial.

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.

Databricks to Excel: Exponam.Connect or ODBC?

Recently, we evaluated the new Databricks ODBC driver.  We have compared and contrasted using ODBC vs Delta Sharing & Exponam.Connect for pulling data into Excel.

What we found was that Exponam.Connect is the ideal choice for business and technical users to pull data from Databricks into Excel. ODBC requires more technical expertise, has poorer performance, and lacks the UI and power features demanded in many business use cases.

 

We compared the two approaches across numerous dimensions – from usability to cost. Read the comprehensive comparison here.

Exponam.Connect proud to be a Databricks Gold Sponsor

Join Exponam.Connect at the Data+AI World Tour in New York on November 8th.  We’re proud to be a Gold Sponsor of this event.  Come by and see how easy we make it to empower your organization with your Databricks data.  No special tools.  Nothing but Excel — exactly what the business wants.

Click on the image for the free registration page.  Can’t wait to see you there!
#DataAIWorldTour