Delta Sharing to Excel
The Exponam.Connect Excel Add-in brings cloud data directly to Excel
Big data is not just for data professionals. Cloud data is not just for engineers and technologists. BIG DATA IS FOR EVERYONE. With the Exponam.Connect Excel Add-in, business users and analysts can work with Delta data directly in Excel.
- If a user can create a filter in Excel, they can work with billions of rows of Delta Lake 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
- Delta Sharing Tables appear in the table view – Just select a table and start working
- Users can also save millions of rows to a secure file for easy sharing, distribution, and archive
- 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
- All the Excel functions users love –> v-lookups, pivot tables, charts
- Unlock the power of internal and marketplace cloud data
Configuration – just select a .share file
Easy filtering and dynamic ranges
Check out our quick videos on using Exponam.Connect.
1 – Adding a Delta Sharing ServerDownload this article Contact Exponam
Sharing and Exploring Data is a Challenge
What is your analysis missing without detailed data?
Visualization tools and summary reports are great. But, as the saying goes, “the devil is in the …” Sometimes, you need the data for detailed analysis when you’re not connected and to share specifics when you’re back online.
With .BIGTM files, you can securely download millions or even 100s of millions of rows easily – from within your existing tools (ERP, CRM, BI/Visualization platform, Custom Databases).
Unlike other data files, .BIG files download quickly. .BIG files are small – 24x smaller than CSVs (and 3x smaller than zipped CSV files). .BIG files won’t clog your email – making them great for sending to partners.
The Exponam ExplorerTM application enables you to instantly view, filter, and sort .BIG files. You can find data and transfer it seamlessly to MS Excel.
Or, work with .BIG files directly in Microsoft Excel. The Exponam.Connect Add-in for Excel lets you work with millions of rows, directly in Excel.
And best of all, .BIG files are ultra secure – so your data is safe – even outside your office. Send it to colleagues, partners, or vendors – it’s secured with industry leading encryption and access controls.Download this article Contact Exponam Download Exponam
Your Data is Not Secure.
Securing Data Repositories Without Securing Data Files Puts You At Risk.
You protect your data repository. You protect your network. You provide users with visualizations, summaries, and exception analysis. Yet, thousands of data files are extracted and downloaded from your repository. These CSV and XLS files reside on your network drives, on employee machines, in the public cloud, and in employees’ email. These data files are the most vulnerable point of attack for malicious actors.
If you are not securing data files, you are not protecting your data.
Current State of Data Security:
Data security in 2022 is a series of concentric security perimeters which attempt to ensure that access to data is authorized. We secure network and application endpoints. We secure, manage, monitor, and audit access to databases. We attempt to scan and block content from leaving our perimeter.
But data gets out. It gets out intentionally when we distribute to partners, vendors, clients. It gets out for legitimate reasons when managers and analysts drill into the data. It gets out when we are hacked or compromised.
We have thousands of data files that are extracts from our databases. They exist as CSV files, as XLS files, and other delimited file types. They reside on our network drives, on employee machines, in the public cloud, and in employees’ email. These files are all potential security concerns.
We address this massive security concern through training employees on corporate data policies. We instruct how data should be handled, where should it be sent and with whom should it be trusted.
THIS IS INSANE.
The Exponam .BIG Solution:
Exponam .BIG files are an easy to use alternative to downloaded CSV files. .BIG files are fully encrypted, ensuring that data files are completely secure anywhere they reside, at rest, in use, and in transit. Access is controlled via passphrase, token, or multifactor authentication. Dynamic entitlement is available for further control of sensitive GDPR or HIPAA governed data.
Your data is secure anywhere it resides – at rest, in use, and in transit.
.BIG files are highly compressed, enabling easy download, distribution, and sharing – no matter how many rows of data (thousands, millions, 100s of millions of rows).
.BIG files are easily accessed via Excel or the Exponam Explorer spreadsheet viewer for instant filtering, sorting, and finding data. Isolated subsets are moved to Excel with a single click. .BIG data is also accessed via JDBC, Java and Windows libraries.
.BIG files are completely tamper-proof and their provenance is guaranteed. You can be confident that the publisher is genuine, the file properties are accurate, and the data is unaltered.
Download this article Contact Exponam Download Exponam
Unparalleled Data Efficiency
Exponam .BIG is the most significant data innovation of the twenty first century.
Exponam .BIG files enable easy, fast, and secure download, sharing, and access to data unlike anything that has ever existed. Share and access millions of rows of data instantly.
Data File Size:
.BIG files are tiny, making them perfect for sending, distributing, storing, and uploading/ downloading to/from cloud. .BIG files are 1/25th the size of .*SV or JSON data (and 3x better than compressed CSVs).
.BIG files, optimized for data extraction, can slash data file migration times by orders of magnitude*. Migrating large data sets (>100mm rows) from flat files to databases is time consuming. Some data sets can take days to migrate. Data in .BIG files migrates blazingly fast – in minutes rather than hours or days.
Instantly access data in MIcrosoft Excel. Or use the Exponam ExplorerTM spreadsheet viewer. Filter, sort, find, and export data from data sets of any size in a flash.
Or, access data with any tool you wish, via Exponam QueryTM, a JDBC service with full SQL support. Query massive data sets without ever migrating the data to a database or repository. Exponam Query performance is in line with the most highly performant database query engines. Querying data from .BIG files blows away queries of other data files – via services from AWS, Google Cloud,
Azure, Presto, etc.
*Testing creation and extraction times for 200+mm rows of data, 90+gb data. Generation of SQL Extract file vs. .BIG file from MySQL database operating on Windows and Unix platforms. CSV extraction tests attempted but fail due to size of data. Testing executed on consumer-class like-configured hardware.Download this article Contact Exponam Download Exponam