Outside of being a powerful data visualization tool, Tableau is known for its ability to connect to just about anything. This includes a multitude of brand-name databases. But there’s a rising database on the block that’s making waves in the industry called EXASOL.

What Is EXASOL?

EXASOL is a high-performance, in-memory, MPP database specifically designed for in-memory analytics. It’s the world’s fastest in-memory analytic database, built from the ground up to offer the highest performance and scalability for in-memory analytics.

From business-critical data applications to advanced analytics, EXASOL helps organizations to rapidly analyze large volumes of data. This can accelerate your BI and reporting capabilities and rapidly turn data into value. In summary, EXASOL is ideally suited for real-time big data reporting, analysis and advanced analytics.

Speed & Compatibility

Time is money for any kind of business, and sometimes seconds can make the difference between profit and loss in our information age. Companies need fast access to their data. The more complex the query sent to a database, the higher the quality of the results. But the time it takes for a database to put through complicated request processing can go on for hours or even days.

EXASOL is compatible with almost every kind of analysis tool out there and delivers fast results be it for potential analysis, customer data analysis, self-service business intelligence, success measurement, targeting specific groups or evaluating extensive data access. It has the power to provide data analysis on a range of mobile devices allowing you and your colleagues to access your data at any time and from any place.

How EXASOL Ticks

So, how does the world's fastest database work? Well, when you input data, EXASOL distributes the load evenly across several computers. The data stored on their hard drives then creates a computer cluster, giving maximum speed in reading and writing data. The TPC-H benchmark test says EXASOL offers by far the highest performance and the best values, bringing databases into the high-velocity age of performance at speeds 1,000 times faster than before.

Here are some comparisons:

EXASOL speed comparisons

EXASOL performance chart

How Do EXASOL & Tableau Integrate?

This is where the speed and power of EXASOL really shines. When you need to visualize millions of rows of data in a tool like Tableau, the EXASOL connector makes it happen in near real time. That’s impressive in comparison to other databases that often take minutes to connect. Ad hoc analysis of very large datasets (GB of data) is now possible EXASOL and Tableau combines, which means reporting and data discovery go that much faster. Setting up the connection in Tableau is also super easy. Here’s how it works.

Connect to EXASOL server using login credentials:

EXASOL Tableau connection

Select the schema and drag the table that you want to analyze:

Connecting to EXASOL data in Tableau

That’s all there is to it! You can now analyze gigabytes of data in just few seconds.

Want to Learn More About EXASOL?

Interested in learning a bit more about EXASOL’s functionality, specifically it’s compatibility with Tableau? We can help. As both a Tableau Gold Partner and an EXASOL partner, we’re experts in implementing these tools in organizations just like yours. Contact us today with your questions, or have us show you first hand just how fast large-scale data analysis can be.

More from the Author

Archana Chinnaswamy

Data Engineer Intern