Our tech blogs

If you’re stumped about schemas, perplexed about Python, or simply want no-nonsense technical advice to optimize your data analytics platform, this is the place for you. Each week our team of tech writers will be grappling with all the burning issues around data analytics and finding practical solutions– so you don’t have to.

How to build a convex hull in Tableau

How to build a convex hull in Tableau

How to build a convex hull in Tableau When we think of data analytics in sport, one of the first things to come to mind is measuring physical performance. How much distance did this player cover in a game? How many sprints did they complete and how does this compare...

read more
Never Fear a Billion Again!

Never Fear a Billion Again!

How to visualize large data sets with Exasol Have you ever wanted to explore ALL of your data by creating ad hoc visualizations and drilling down to the lowest level of granularity? Perhaps you feel limited with the data available in Extracts or your team is tired of...

read more
What is Exasol’s cluster architecture?

What is Exasol’s cluster architecture?

This article gives a detailed overview of the Exasol cluster architecture. Exasol cluster nodes: hardware Our clusters are built with commodity Intel servers without particularly expensive components. SAS hard drives and Ethernet cards are sufficient. There’s no need...

read more
How to use Exasol’s Automatic Table Reorganization

How to use Exasol’s Automatic Table Reorganization

One of Exasol’s key features is the low maintenance effort when compared to many other database systems. Automatic Table Reorganization is one example: Exasol offers CREATE OR REPLACE TABLE and the DELETE_PERCENTAGE is zero after the table is created. The...

read more
How to install an Exasol 6.1 Cluster on VirtualBox

How to install an Exasol 6.1 Cluster on VirtualBox

You start by installing the latest version of VirtualBox. Then you need to download an ISO file with the latest Exasol version. The machine hosting VirtualBox should have at least 16 GB RAM and 80 GB free disk space in order to run a 2+1 cluster with 3 data nodes and...

read more
How to get distribution right in our analytics database

How to get distribution right in our analytics database

Our analytics database uses a clustered shared-nothing architecture with many sophisticated internal mechanisms delivering outstanding performance. All without the need for much admin. But getting the distribution of rows between cluster nodes right is one of the few...

read more
Migrating from Netezza

Migrating from Netezza

Migrating from Netezza: an SQL Script to help you import data from Netezza into Exasol’s analytics database Whether you’re planning to migrate away from Netezza and are exploring different migration paths or you’ve already decided to migrate data across to us, we’ve...

read more
How to use DbVisualizer with Oracle, PostgreSQL and Exasol

How to use DbVisualizer with Oracle, PostgreSQL and Exasol

As a database developer or administrator, it’s unlikely that you’ll work with only one platform. It’s quite useful to have one single tool to handle multiple different database platforms –that’s the ambition of DbVisualizer. Let’s assume you’re a database...

read more
Playing in the Champions League of Sports Analytics

Playing in the Champions League of Sports Analytics

If you’re looking to build a system for sports analytics, think about Exasol’s analytics database. With its great performance and analytical capabilities an Exasol database can easily handle huge volumes of event and tracking data. But as my last blog explained,...

read more
Automatic indexes in Exasol

Automatic indexes in Exasol

An Exasol database will automatically create, maintain and drop indexes, following the core idea to deliver great performance without requiring much administrative efforts. Like Exasol’s tables, the indexes are always compressed and users don’t need to configure...

read more
How to build your own Virtual Schema Adapter – Part 1

How to build your own Virtual Schema Adapter – Part 1

Following up on our series about Virtual Schemas, today we’re looking at what it takes to create you own adapter for a database that offers a JDBC driver. And as a word of warning, we’re going to be knee-deep in the code,  so this article’s main...

read more
Building clusters in the sky – Exasol Cloud Wizard

Building clusters in the sky – Exasol Cloud Wizard

In modern day cloud architectures, one of the main priorities for any team is making the configuration and installation as simple and straight forward as possible. The Exasol Cloud Wizard addresses this demand. The Exasol Cloud Wizard is currently available for Amazon...

read more
Next level unit-testing with JUnit5

Next level unit-testing with JUnit5

In our Java-based Open Source repositories we at Exasol use JUnit as our testing framework. Like most organizations we used JUnit4 for a long time. But for all new projects we have switched to JUnit5. We’re also migrating existing tests in established projects...

read more
Don’t let Python slither out of your control

Don’t let Python slither out of your control

Don’t let Python slither out of your control – how to load data science languages in and out of our relational database A recent study of different job listings revealed which data science skills are most in demand for data scientists. It was no surprise that over 70%...

read more
Interactive Text Mining with Exasol and INDREX-MM

Interactive Text Mining with Exasol and INDREX-MM

Text mining work-loads rarely require full scans of all table data, but do often require full scans of a small subset of the columns. Our base table layout from (Kilias et al., 2015) supports such work flows. Summary. Textual data is a core source of information in...

read more

Get in touch

Ready for the next steps or just want to chat about what we can do for you?