openLooKeng vs Virtual Data Platform

openLooKeng is a free, open-source data virtualization engine that lets teams query disparate systems through one SQL interface. It analyzes data where it resides, adding sources through connectors without requiring migration. Listed examples span relational databases, NoSQL systems, Hive, MPP warehouses, MySQL, Oracle, HBase, Elasticsearch, and Kafka. Queries can involve data centers, hybrid clouds, and geographically remote clusters using hierarchical deployment and cross-region plan optimization. Huawei describes interactive, batch, and streaming workloads, while noting that the first version supported interactive queries. Features include front scheduling, cross-source indexing, dynamic filtering, cross-source collaboration, horizontal scaling, and Coordinator active-active availability. The project is based on the open-source Presto SQL engine and uses Apache License 2.0. It is self-hosted, with Linux scripts for single-node, multi-node, and offline installation. Windows clients can connect through an ODBC driver supporting Windows 10 64-bit and Windows Server 2016 64-bit.

Virtual Data Platform (VDP) provides live access to enterprise data across systems, networks, and organizations without copying it into a warehouse or lake. Queries run against source systems, and results are combined in an in-memory sandbox for each user. Its low-code Modeler creates reusable Virtual Datasets from Functions, Code Files, Models, and Value Lists. Users can work with the data through Excel, Power BI, Python, R, and MCP-capable AI assistants. Listed integrations include SAP, Snowflake, Salesforce, Workday, SQL Server, SharePoint, ODBC, OData, Oracle, PostgreSQL, BigQuery, and Dynamics 365. Users sign in with Microsoft Entra ID, and queries apply source-system permissions under the requesting user’s identity. The maker describes outbound-only gateway connections, TLS on every connection, encrypted payloads, and results held in memory rather than saved to disk. It describes the service as GDPR-aligned and hosted in the EU on Microsoft Azure, while making no certification claims today. A Dedicated tier offers a dedicated backend cluster and Azure Private Endpoints.