Lyftron supports Lyft, Shift and Phase migration approach which enables enterprises to migrate from legacy platforms to Vertica with ease and allows point existing database connection to Lyftron. Thereby, Lyftron acts as an intermediate layer until the migration is fully complete.

Lyftron Data Pipeline manages connections to data sources and load data to Vertica . All transformations are defined in standard SQL and pushed down to data sources and Vertica.

Lyftron connectors automatically convert any source into normalized, ready-to-query relational format and provide search capability on your enterprise data catalog.

Lyftron takes a unique approach to load data into Vertica by utilizing the new data streaming API available in Vertica. Data is loaded from the data source, data transformations are applied on the fly as SQL expressions and the transformed data is streamed directly to Vertica. The data is loaded without any delays and without the need to manage any space for temporary files.

Additionally, Lyftron may push down selected SQL transformation directly to data sources to reduce the amount of data that must be transferred

Not at all! Lyftron pre built connectors automatically convert JSON, XML, API to normalized structure and provides ready-to-query schemas and
full search on data catalog.

Lyftron enables enterprise-level security with a built-in security model and support for standard security frameworks and protocols. Its embedded security system allows data masking, field-level restrictions and architecture that automatically scales up and down.

Lyftron modern data hub offers logical data warehouse where data is stored once and utilize the memory compute for transformation, loading and standardization.

Data virtualization offer store users a single interface — often based on SQL — to access data in multiple places or formats.

Lyftron integrates data virtualization, manages the unified data for centralized security, and delivers real-time data for best class performance. Lyftron provides a common abstraction over any data source type, shielding users from its complexity and back-end technologies it operates on. It relies on views that allow Vertica users to integrate data on the fly.

Lyftron supports all the high performing big data warehouse like Hadoop, Spark, EMR, Azure, HDInsights, Databricks, etc and next-gen cloud data warehouse like Redshift, Google Big Query and Azure SQL DW.

Please write to us at [email protected] for details related to pricing.

Lyftron is providing out of the box data warehouse star schema design, and BI dashboard for the consumers. So, you can just use our Vertica express solution to build your new analytics platform in no time.

Lyftron will provide you with automatic data lineage and tag based search which will populate our data catalog engine. So, anybody like business users, data analysts or engineers can search all their objects with ease.

Lyftron will help you automatically create the schema, will do auto merging, auto sync for your files and auto ingest into your target data warehouse automatically. There’s no need of any manual looping process, Lyftron will read the files from subdirectories automatically.