ENTERPRISE VIEWS & SHARDING
Remove unnecessary data staging tables and ETL jobs,
and place data discovery & analysis directly into the hands of
power users by creating real-time Enterprise Views and Shards of your
hosted platforms, enterprise systems, files,
cloud application data, and relational database. Expose the same views
to both SQL and REST consumers to make them available to reporting tools,
web and mobile applications, and integration tools.
Organizations that operate multiple data sources (such as CRM systems, HR systems, Oracle databases, Files, cloud data...)
face the challenge of providing a consolidated version of their data that can be accessed easily
using REST and SQL commands.
Virtual Data Lake
Using Enzo as the proxy for accessing hosted systems, databases, and flat files, it is possible
to create a virtual Data Lake that simplifies access to information, and allows users to consume
data consistently using REST and SQL commands. Combined with Edge Caching, Auditing, and ACL capabilities,
Enzo delivers a simple yet powerful data platform for the enterprise.
Example 1: Expose a real-time view that combines data from SalesForce, SharePoint and a MySQL database
as a single REST endpoint, and a database view.
Example 2: Allow certain users to update the underlying SalesForce table, and inspect the updated
values in the Enterprise View in real-time.
In addition to working with relational datatabases and semi-structured data sources, Enzo helps
your organization build heterogeneous views that combine data from relational databases,
No-SQL databases, flat files, XML Files, and JSON documents, as a single view, all in real-time.
Combining data from multiple disparate sources at the same time
removes the need to build complex staging databases, unnecessary ETL processes
and accelerates data discovery & analysis by power users.
Example 1: Jane, a power user from the HR department, creates a single view
that merges data from a SharePoint list, an Excel document, and
an Azure Table. The view is now accessible through REST and SQL commands.
Example 2: Joe, a power user, uses Enzo to combine cloud data from an Azure SQL Database,
an Amazon RDS database, and a MySQL database hosted internally to run a
report from SSRS directly.