1 800-610-2521

ENTERPRISE VIEWS & SHARDING

Enzo Enterprise Views and 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.



The Challenge


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.


Enzo Solution


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.

Heterogeneous Sharding

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.