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 these 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, 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

Lyftron 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 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.

Target Data Warehouses

Explore all target databases that are managed by Lyftron.

You are just one click away from a modern data hub