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.