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.
Because Enzo Server is a service 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.
Enzo Server allows your team to copy data from any system, including SaaS platforms using pure SQL commands without ODBC Drivers, eliminating complex ETL processes, so that you can extract raw data into a staging database or your 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.
If you are looking for an automatic CDC capability that allows you to extract
only the necessary changes and perform data transformations on the fly,
check out Enzo DataZen, our highly performant hybrid data ingestion solution.
Because Enzo Server 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.
Enzo Server also provides a REST interface (like an HTTP/S 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).
© 2023 - Enzo Unified