Hybrid cloud data warehousing
Integrate a cloud data warehouse with on-premise and cloud data sources bi-directionally.
Migrate to the cloud instead of weeks
Every hybrid cloud data warehouse project
must solve those challenges:
- How to load on-premise and SaaS data to the Cloud
- How to use the legacy and the cloud data warehouse at the same time
- How to connect SaaS and on-premise BI tools to on-premise and cloud databases
The solution must be both a data loader and a data bridge. The data loading part should be responsible for managing the data pipeline, while the Data Bridge would let BI tools execute SQL queries across the cloud boundary.
Universal data platform for analytics
Lyftron 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, the Cloud Data Warehouse or 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
Lyftron is a single place to find and query all possible data. Use standard SQL to query both 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 step-by-step
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 Lyftron
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 Lyftron 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. Lyftron extends the columnar processing to the data pipeline, which speeds up data loading and transformation.
SQL interface
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.
Data Sources
Explore our 130+ supported data sources that may be loaded, transformed, queried and combined.
You are just one click away from a modern data hub
