HOW ENZO WORKS
Data Virtualization for APIs and SaaS Data
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.
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
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
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