How you can analyze all your data by simply using SQL

 

SQL is usually taken for granted. Structured Query Language was originally created in 1974 and is one of the longest-standing witnesses of breakthroughs and progresses in database technology. Certified by both ANSI and ISO, it is the standard of database query language that powers many well-known database applications in the internet today.

 

Where is SQL now?

For the past 5 years, SQL has been among the top 2 most popular programming languages by Stack Overflow Developer Surveys. Coding Dojo also lists SQL as the most in-demand programming language in 2017. And SQL is technically not even a programming language! However, despite such popularity among professionals, SQL’s steady and consistent presence tends to blend itself quietly into the backdrop of the world of big data while the rest of us chase after new hypes.

 

 

The past decade saw the rise of Hadoop and NoSQL, which complement tasks and functions that SQL was not designed for. While these developments are very important for the course of progress in big data, some people mistakenly confused NoSQL for “No SQL” and claim that SQL is dead or no longer relevant. But with the growing popularity of cloud-based databases and the increasing number of SQL interfaces among Hadoop and NoSQL projects, it is clear now that the ever-evolving SQL isn’t going anywhere anytime soon.

When Mode and DataVirtuality discovered each other, we noticed our shared commonality right away: Mode and DataVirtuality both believe in the philosophy and technology behind SQL. In fact, we count on SQL in the era of big data.

A powerful SQL based BI stack with Mode + DataVirtuality

Mode Analytics is a collaborative platform for data-informed business, powered by SQL. Whether you reach for SQL and Python or prefer drag-and-drop exploration, Mode helps everyone to find answers in data. It is very versatile and you can use it for ad-hoc analysis, interactive reporting, data visualization, and dashboards.

 

 

 

DataVirtuality is a next-generation data integration platform that accesses, models, and moves data for analytics and process automation purposes, powered by SQL. DataVirtuality can analyze data from any databases with over 150 connectors. DataVirtuality sets up your data infrastructure in under 5 minutes, accesses data silos, and uses SQL to query raw data for insights. The DataVirtuality SQL processor works even for Hadoop and NoSQL databases that do not support SQL natively.

 

 

So why do both DataVirtuality and Mode choose SQL as an essential part of their products? We list some of the advantages of SQL below:

  • SQL is semantically simple and intuitive to understand
  • SQL is easy to learn but powerful when utilized
  • SQL queries retrieve large amount of data from a database quickly and efficiently
  • SQL databases use industry standard adopted by ANSI and ISO for relational models
  • SQL is popular with adopters to open source languages like Python and R 

Because of these advantages, SQL is everywhere. Even the disruptive Hadoop and NoSQL products are now actively adding SQL-like syntax for their query and analysis languages, such as HiveQL (for Hadoop) and UnQL (for NoSQL). Such recent trends of SQL on Hadoop and on NoSQL demonstrates SQL’s strengths and importance in the age of big data. SQL’s easy-to-use, power, and flexibility is exactly why we choose it for our products.

The shared choice of SQL also makes the combination of DataVirtuality and Mode a powerful tool set for data-driven businesses. On the backend, DataVirtuality can connect to any data source with its various connectors and to any data warehouses like PostgreSQL, Amazon Redshift, MySQL, SQL Server, and BigQuery for data integration. On the frontend, DataVirtuality connects to the powerful Mode and allows its users to query data directly through DataVirtuality with SQL commands and perform analysis to explore insights.

 

 

As it combines the best features of both ELT and data virtualization, DataVirtuality integrates data from multiple sources into one virtual layer without the need to physically relocate data storage, and executes queries instantly. Furthermore, it optimizes distributed queries while eliminating bottlenecks by intelligently creating and managing data structures in data warehouse  like PostgreSQL, Amazon Redshift, MySQL, SQL Server, BigQuery, Snowflake and many more to keep the data up-to-date. 

With DataVirtuality doing the magic behind the scene, Mode users can now easily connect to any data sources from Twitter to MongoDB with DataVirtuality and query data for analysis using SQL. Leave the heavy lifting work to DataVirtuality and just focus on enjoying data analysis and exploration with Mode.

Choose your use case: Integrate your data and run ad-hoc queries on them

 You could simply bring all your data sources together query them ad-hoc in just a couple of clicks:

 

 

In our example the BI Stack would be: 

Data sources:

  • Google Analytics,
  • Facebook,
  • Adobe Analytics

Data warehouse:

  • PostgreSQL 

BI tool:

  • Mode

 Data integration platform:

  • DataVirtuality

 … and we can also handle your specific use case. Just by using SQL and few clicks. 

The combination of DataVirtuality and Mode provides you with a versatile front-end data analysis and a powerful back-end data integration, powered by one SQL language. NoSQL does not mean “No SQL” but simply that it’s “Not SQL” and borrows the powerful features from SQL to tap the insights in unstructured data. At DataVirtuality and Mode, we truly believe SQL has stood the test of time and evolves flexibly with technological progress. SQL does not just belong to the past, but also unlocks the future of big data.

Do you share our passion for SQL? Are you curious about DataVirtuality’s products and solutions in combination with Mode? See all data sources that you can get into Mode right here.