Hybrid cloud data warehousing
Migrate to the cloud instead of weeks
Every hybrid cloud data warehouse project
must solve these challenges:
Universal data platform for analytics
Lyftrondata is a data layer for Analytics that combines traditional data loading with Logical Data Warehousing to improve collaboration and simplify data management . The SQL interface accepts queries that are routed to legacy Data Warehouses, Cloud Data Warehouse or the data which is executed in real-time at the data source.
Load data to the cloud
Connect 130+ on-premise and cloud data sources and set up continuous data synchronization of selected data to Amazon Redshift, Snowflake, Azure SQL DW or any other database.
One data portal
Lyftrondata is a single place to find and query all possible data. Use standard SQL to query legacy Data Warehouses, data sources in real-time and all Cloud Data Warehouses.
Empower data teams
Let data analysts and data scientists find and manage their data sets. Foster collaboration by creating a global Data Catalog of all valuable data sources.
Migrate a legacy Data Warehouse either as a single Lift-Shift-Modernize operation or as a staged approach. Run dashboards both from the old Data Warehouse and the Cloud DW, switch the target when migration is finished.
Secure data in the cloud
Apply row-access security for data stored in the Cloud, apply dynamic data masking or use pseudonymization of PII data stored in the Cloud.
Support any BI tool
Connect any BI tool using build-in SQL Server drivers through a fully simulated SQL Server protocol. Bridge a connection from SaaS BI tools to on-premise data and the on-premise Enterprise Data Warehouse.
Hybrid data warehouse with Lyftrondata
A Logical Data Warehouse that is put on top of all source and target databases turns the data stack into a real Data Hub, where all data is available. The SQL Interface in Lyftrondata simulates SQL Server wire protocol, so all 130+ may be queried using Transact-SQL and SQL Server drivers (ODBC, JDBC, ADO.NET) that are already provided in all BI tools.
Columnar data pipeline
High-performance modern Data Warehouses are all columnar and efficiently process data in bulk. Lyftrondata extends the columnar processing to the data pipeline, which speeds up data loading and transformation.
Fully simulated Transact-SQL interface (wire compatible with SQL Server) enables bridged queries to any data source or target Data Warehouse. No drivers or new skills are needed to run queries on any data.
Global data catalog
Categorize all data sets stored in the Cloud, essential data sources and valuable data sets defined by data analysts and data scientists.
Target Data Warehouses
Explore all target databases that are managed by Lyftrondata.