HOW ENZO WORKS




Data Virtualization for APIs and SaaS Data







PLATFORM OVERVIEW




At a high level Enzo Server behaves like a SQL Server database. Any client application that can connect to SQL Server can also connect to Enzo directly, such as SSIS, SSRS, PowerBI, Cognos, Excel and custom .NET applications.

In addition to responding to SQL commands, Enzo also understands native HTTP/S REST commands, making it the first Data Virtualization platform that can be used by anyone in an organization out of the box, from business analysts to developers.

Because Enzo is a server technology, it offers many cross-concern benefits such as stronger security and access control, auditing & logging, edge caching and more.

CloudImage






LIKE A SQL SERVER




Enzo allows you to send SQL requests to access remote systems such as SharePoint, SalesForce, Twilio, Twitter, FTP, WMI and more. This means that business analysts can access data directly without the need to code against complex APIs.

See the list of systems you can access here

Because Enzo is a server product that understands SQL commands natively, there is no need to install client-side ODBC drivers. And because Enzo also understands Linked Server, it is possible to directly access a large number of services directly from within SQL Server stored procedures, triggers, views and functions.

See the differences between Enzo and ODBC Drivers

SQLImage






DATA INGESTION




SQLImage1

Enzo allows your team to move data using pure SQL commands without ODBC Drivers, eliminating complex ETL processes, so that you can extract data into a Data Warehouse quickly and easily. The ability to extract data from any system using SQL commands drastically simplifies SSIS packages, and removes custom programming logic from ETL jobs.

Read more about ODBC-Free Data Access

The Change Data Capture (CDC) feature of Enzo helps you automatically replicate hosted SaaS data into a database, such as SharePoint lists, SalesForce tables and Twitter feeds.

Learn more about CDC here







RAPID DEVELOPMENT




Since Enzo supports Linked Server, you can build solutions that integrate with SQL Server at the lowest level possible: the database. For example you can send messages into MSMQ or RabbitMQ directly from a Trigger in SQL Server, or read messages from an Azure Bus Queue or Topic.

Read more about Native SQL Server Access

Enzo also provides a REST interface (like a webhook) allowing you to access a large number of services using pure HTTP requests. This helps accelerate development cycles regardless of the programming language (C#, C++, Python...), platform (web, IoT, Mobile) or component (windows app, add-ins).

Learn more about Rapid Development with Enzo

HTTPImage