Enterprise Enabler vs Presto

Enterprise Enabler 10 is data integration middleware for connecting IT and business users to data held across different sources. Its transformation engine can federate live data from multiple systems and transform it without staging it in a physical or virtual database. A data catalog provides another way to search within the product, and lineage traces a dataset’s origin, destination, formulas, business rules, and intervening steps. Fast Virtualization uses drag and drop to create virtual models for BI reports, web services, and applications. Data masking and obfuscation control partial or full user views; the product page says these features support GDPR compliance, row-level security, and column-level security. Listed relational integrations include Oracle RDBMS, Microsoft SQL Server, IBM DB2, MySQL, and PostgreSQL. Deployment options include on-premise, cloud, hybrid, and a cloud edition designed to run without extra installation and setup. Stone Bond Technologies offers a no-cost trial, with setup instructions sent by email. AWS Marketplace bundles are billed per hour: EE 10 Bundle A is $2.17 a month for 3 data sources, and Bundle B is $8.50 a month for 12.

Presto is an open-source distributed SQL query engine for working with large datasets across different data sources. Its ANSI SQL interface can query information where it is stored and combine data from multiple sources in one query, for both interactive and batch workloads. The project lists ad hoc queries, reporting and dashboards, and open lakehouse workloads among its uses. Documented connectors include BigQuery, Cassandra, Delta Lake, Elasticsearch, Hive, Iceberg, Kafka, MongoDB, MySQL, PostgreSQL, and Redis. Presto can be installed from a server tarball or deployed with Homebrew, Docker, or Helm. Security options include Kerberos, LDAP, password-file authentication, access controls, secure internal communication, and OAuth 2.0. Users can work through its CLI or Console, connect with DBeaver or Tableau, use Java, Python, Go, or JavaScript clients, or access the REST API. The project is free and open source, overseen by the Presto Foundation, which describes it as independent of any single company. The documentation identifies release 0.299, while the getting-started page still refers to version 0 from June 2022.