Contact us to inquire about licensing options for the Exponam.Connect Excel Add-in.
Licensed versions of Exponam.Connect remove all restrictions from Excel imports* and file downloads. Licensed versions contain additional functionality like ‘Live Table’ views of data.
*Note that Excel imports are limited by Microsoft Excel’s capability to five million rows (spread across five worksheets). Data saved to files is entirely free from limitation. .BIG files are specifically designed to efficiently and securely handle hundreds of millions of rows.
- .BIG files can be opened, no matter how large, directly in the free Exponam Explorer (or with any other Exponam .BIG technologies – APIs, CLIs, JDBC)
- .BIG files are highly compressed, may be secured, are immutable, and contain detailed provenance information
- .BIG files are an excellent option for securely storing and distributing data sets to people both within and outside of your organization.
Non-technical users can create files by saving to .big within the Exponam.Connect Excel Add-in or with the Exponam Builder, freely available from my.exponam.com. Developers and more technical users may generate .BIG files via a host of native Java and C# utilities including APIs and command line interfaces. Data for .BIG files can be extracted directly from databases or come from existing data files. .BIG file generation can be integrated into common off-the-shelf platforms (accounting systems, CRM systems, BI platforms, etc.). Creating .BIG files is as quick as creating any other type of data file (CSV, JSON, etc). .BIG builder applications are available for free from our developer page, or from Maven Central or Nuget (for developer components).
An Exponam License is required to unleash unrestricted builder capabilities, including unlimited data size and data security features. Contact us for more information on the Exponam Builder and licensing.
Passphrases are protected with SHA256 and a randomly generated salt. SHA256 is a National Security Agency (NSA) Type 3 encryption product endorsed by NIST and published as the FIPS 180-2 specification. Files may also be protected with security tokens or multi-factor authentication.
Additional file access entitlements may be assigned and dynamically administered by the organization creating the .BIG file. These additional access rights include user specific rights at the column and function levels. These rights may be turned on or off for any file, even once it has been distributed outside of the organization. Contact us for more information.
Querying data in a .BIG file via JDBC is as fast as querying data within an enterprise database. Alternately, you can extract the data from a .BIG file via Java or C# Reader APIs. Data extraction is orders of magnitude faster than with any other form of delimited file.