Information

DATA IS FOR EVERYONE. With the Exponam.Connect Excel Add-in, business users and analysts work with Databricks data in Excel.

It’s Easy:

• If a user can create a filter in Excel, they can work with billions of rows of Databricks data
• Business users work with data where they want it, in Excel. No new applications to install or learn
• There is no complicated set-up.  No ODBC connections or configurations
• Just select a table and start working
• Users can also save millions of rows to a secure file for easy sharing, distribution, and archive

It’s Powerful:

• Create filters to easily pull down the current day’s (or week’s or month’s) data
• Save filters and re-use them whenever needed
• Live updates to data on a schedule or on demand
• PivotTable creation
• All the Excel functions users love –> v-lookups, pivot tables, charts
• Unlock the power of internal and marketplace cloud data

It’s Efficient:

• Cost Effective: Data egress minimized and no server processing.  Cheaper than ODBC or other connections which involve cloud compute fees
• Fast: Intelligent data downloading and synchronous processing
• Guarded: Users are protected against inadvertent large downloads or unanticipated fees.  Maximum Excel import is 10 million rows spread over 10 sheets
• Governance & Permissioning: Unity Catalog manages/audits all user access.  No Databricks accounts or workspaces required
• Secure: Secure data transfer direct from cloud repository to requesting system