Shorten data preparation for Dundas BI

Lyftron changes the way how data is prepared for Dundas BI. Data from all data sources is accessible instantly in one place, a virtual data warehouse. Data loading to a target data warehouse is delayed until it is necessary.

Reduce time to insights

Accelerated data preparation for Dundas BI

Lyftron allows you to pick data from any source and migrate it to Dundas BI while allowing you to analyse it instantly. Be rest assured to experience a zero-maintenance, hassle-free data load.

Lyftron precisely organizes data into easy-to-view-and-analyse query tables while connecting you to popular BI Tools like Dundas BI. Lyftron’s simple point-and-click interface enables you to set up a pipeline within minutes while it manages all back-end operations, leaving you with ample time to focus on building value and enhancing other operational tasks.

In a fraction of minutes, your team, from executives to analysts, will have access to insights from real-time data, giving them on-point catalysts to boost your business’ growth and drive more profits.


  • Connect
  • Normalize
  • Analyze
  • Warehouse
  • Visualize
  • Data Sharing

Integrate your data from 150+ sources instantly

Register over 100+ types of data sources in one place. Choose the most valuable data sources and replicate them to the cloud.
Service Now
Google Analytics

Business Analyst

I feel more aligned with the agile process as now I can analyze any data without worrying about any technical know how.

Empower your analytics with simple, codeless, automated API relational data models

We build the best data models around various source API’s, to ensure you will get all of your data and can query the non relational source like API/Json/XML with ANSI Sql.

Data Analyst

I have a better control on the data analysis process as now I can run rapid fast queries against the API’s which I never thought possible.

Built for the agile data culture

We enables any non technical person to analyze the data from API without worrying about any coding. Simple connect your source and run ANSI sql queries.

SELECT o.userid, o.order_id, o.amount, case when p.status="Active" then 1 Else 0 end as status, p.currency, pay.fee FROM [ order ] o INNER JOIN [ payouttransactions ] pay ON = INNER JOIN [ payouts ] p ON p . id =
User-id Order-id Amount Currency Fee
1 187453 $20 $ $123

Data Architect

I am able to do the architecture and requirement gathering by simply writing ANSI Sql queries for the API sources which use to be the taboos for me.

Load your data into Lyftron warehouse or lake instantly or connect with your data warehouse.

Define dataset, apply SQL transformations or simply migrate your SQL data processing logic to any cloud data warehouse.

Amazon Redshift
SQL Synapse
Google Bigquery
Postgres Sql
MS SQL Server

ETL Developer

I am able to build my data pipeline in few clicks and load billions of records to my warehouse and also able to do cross platform joins on the API sources with ease.

Analyze your data from any BI/ML tools

Create a canonical data model that is shared between BI tools. Build a shared data catalog of valuable data sources.

Google Data Studio
Power BI
Periscope Data
AWS Quicksight

BI Analyst

I have a better response from the BI reports and able to connect with API/Json/XML based sources in just fewer clicks.

Data sharing is data caring

Define, categorize and find all data sets in one place. Share these data sets with other experts with zero code and drive better insights and user experience. This data sharing ability is perfect for companies who want to store their data once, share it with other experts and use it multiple times, now and in the future. We build the best data sharing process around your data stack. So say goodbye to the complex API, FTP and Email manual data sharing processes and simple on board your consumers to the Lyftron platform in just few minutes mins.
Health care

Our Agile Team

We are in full control of our data exchange process and easily able to share the data instantly and collaborate with teams with ease without worrying about writing complex API, FTP, Email for data sharing.


Comprehensive Analytics

Access advanced reports for better insights on your Dundas BI data. Get insights across products, channels, customer lifetime value, and more

360-degree Customer View

Know who your customers are, what they buy, and where they come on your store in a beautifully designed dashboard

Continuous Data Integration

Survey, optimize, dispatch and smooth out ongoing information assortment from different streams and drive moment noteworthy bits of knowledge

Get Personalized Data

Remain at the head of your information by removing significant data from Dundas BI and mix it with different sources

Incorporates and Assembles

All your information, every one of your bits of knowledge and all your security that you never thought conceivable at an incorporated spot. Just connect, transform and blend to derive faster analytics.

Real-time Analytics

Query all information sources with simulated Transact-SQL. Get constant information from information distribution centers or source frameworks during prototyping and information demonstrating.

Share Data Sets

Characterize, organize and discover all informational collections in a single spot. Energize cooperation in data management to dodge information change rationale covered up in Periscope.

Prebuilt Transformation templates

Use default templates for common transformations like Star Schema and integration techniques eliminating time spent on tedious tasks.

Information Lineage Tracking

Find all informational collections that will be influenced by a change to a table or a section. Discover which source tables and segments are utilized in any informational index, regardless of whether it depends on numerous other informational collections.

Information Security

Straightforwardly apply column access security and dynamic information veiling to any information source. Validate with Windows Integrated Security (Kerberos) from Dundas BI when utilizing any information source.

Worldwide Data Catalog

Portray all basic information sources and informational indexes in the information list. Utilize oneself assistance interface to locate the correct information.

Brilliant Data Pre-aggregation

Quicken moderate inquiries by materializing their outcomes. Characterize pre-aggregates with joins, groupings and filtering that are 1000x littler then original information. Transform any information distribution center into a virtual OLAP 3D shape.

How we do it

Find all data in one place

Register all data sources in one place. Connect to database or countless business and social platforms. Use a single data source for Dundas BI with all data.

Replicate in few click

Define data pipelines that replicate selected data to cloud and on-premise data warehouse. Replicate whole database without creating ETL data flows.

Share data sets

Define, categorize and find all data sets in one place. Encourage collaboration in data management to avoid data transformation logic hidden in Dundas BI

Reduce dependency on it

Empower data savvy users in data management tasks. Let them manage their own virtual section of the data warehouse and define sets for analytics.

Combine disparate data

Join different data sources in real-time or materialize join data sets. Go beyond limitations of 7Analyse in joining across different sources.

Engage Business early

Do not delay consulting results with stakeholders because a data warehouse must be loaded. Prototype dashboards on real-time data sets and optimize later.

Use Cases

Make smarter decisions and grow your sales with Lyftron Dundas BI Integration


Lyftron automatically connects with Dundas BI database and files, load them in a cloud data warehouse of your choice and makes the data available in your favorite BI or analytics tool. All transformations are defined in standard SQL, which are pushed down to target data warehouse in their native sql for better performance.

Yes. It is meant for it! Get comprehensive analytics and advanced reports on how your Shopify store is doing in beautifully designed dashboards. Know who your customers are, what they buy, and where they come on your store. Moreover, get automated insights across products, channels, customer lifetime value, and more.

Why not! With Lyftron, stay on the top of your meaningful customer data including products, orders, wish lists, reviews, contacts and deliver a personalized Shopify experience. Besides, get ensured that your customers’ data is always up-to-date including email ID, phone number and profile so that you spend more time on growing your store than updating your data.

Analyze any data size in more than 35 visualization tools! The agile-data delivery model could processes trillions of rows, tables and delivers unmatched BI performance and limitless scalability for Shopify users. Run real-time SQL queries on any data source.Create data sets and share them between teams and analytics tools.

Lyftron provides a platform that processes real-time data from multiple marketing streams and empowers Shopify owners to examine which campaign is working best and which needs improvement. Integrate and assemble all your data from more than 30 sources including Salesforce, Marketo, Spreadsheets, Google Analytics, LinkedIn, Facebook, and more.

The whole process right from the integration to producing actionable insights, happens in less than 4 minutes- promising a time optimization by 75%.

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

Yes, Offcourse!
With Lyftron modern data pipeline, you could have an access to all your data points , make analysis simple for all stakeholders, and gain a holistic view of your Shopify store without any technical limitations.

Not at all!

Lyftron prebuilt connectors automatically convert Json, Xml, API to normalized structure and provides ready-to-query schemas and full search on data

Through a governed embeddable data discovery model, users could search, tag, alias, and enrich their Shopify data with ease. The powerful agile-based platform enables enterprises to transforms messy and unstructured data to facilitate and enhance its analysis.

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

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


Lyftron integrates data virtualization, manages the unified Shopify 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 Shopify 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 Snowflake, Redshift, Google Big Query and Azure SQL DW.

Lyftron supports Lyft, Shift and Phase migration approach which enables users to rapidly modernize applications, migrate the right workloads, and securely manage their hybrid environment.

Lyftron speeds up the data preparation process so that the focus is less on cleaning the data and more on gaining insights in shortest time possible. Such self-service data preparation system, a collaborative data modeling and instant logical data warehousing allow different live of functions to work together and deliver fast.

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

No, Lyftron will help you create Data Pipeline automatically and let you analyze the data instantly with ANSI Sql and BI tools.

No, Lyftron will help you connect with Dundas BI and normalize your API Json output automatically so you can focus on your business and Lyftron will take care of the data pipeline.

No problem, Lyftron will help you with Dundas BI data model so you can easily understand your source system and build your new architecture with 75% optimization.

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

Yes, Lyftron will provide pre-built pipelines for Stage as well as Data Warehouse.

Lyftron will provide you with automatic data lineage and tagb 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.

No, Lyftron allows Json parsing function so, you can directly use simple select syntax and have your json data extracted quickly as shown on this query here.

select JSON_PATH(LineAggregate, ‘$.[0].id’) ,JSON_PATH(LineAggregate, ‘$.[0].variant_id’),
LineAggregate from (select top 1  * from [Shopify_GeniusMinds].[Shopify].[Orders]) as orders

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.

No problem, we get you covered. Lyftron has inbuilt data encryption mechanism which let you encrypt your sensitive information with ease.

Lyftron has robust column level security which will help you choose the access based on roles and user and only the users you choose will get the access on pipeline, database, table or column.

Yes Lyftron will sync all your historical data, simply connect and choose your load option.

No, you are fully covered with Lyftron auto sync feature which help you choose delta field, select the frequency and Lyftron will take care of the rest.


Want more information about how to solve your biggest data warehousing challenges? Visit our resource center to explore all of our informative and educational ebooks, case studies, white papers, videos and much more.

Experience the power of the cloud with our modern data ecosystem

Supported data sources


Share on facebook
Share on twitter
Share on linkedin