In this blog post, we show how to connect Tableau to MariaDB TX or MariaDB AX and how to create advanced visualizations in Tableau using data in MariaDB.
Learn how Billy Mobile deployed MariaDB ColumnStore for fast, interactive analysis of big data that easily integrates with Tableau for data visualization.
There are many great unique features of MariaDB ColumnStore, one of which is the speed in which you can get data from CSV files into MariaDB ColumnStore using the tool ‘cpimport’. But what if your data is in another format? Or you wish to stream data into MariaDB ColumnStore from another application? This is where MariaDB ColumnStore’s new write API comes into play.
We have learned that the MariaDB ColumnStore prerequisites and install can be complex for multi-node installs so we decided it would help our users to develop a tool to validate for install readiness. This tool will validate the setup whether installing on a single server or a multi-server system. It is called MariaDB ColumnStore Cluster Test Tool. It is part of the MariaDB ColumnStore package and can be run from the installing server once the MariaDB ColumnStore package has been installed.
Today, the market wants an enterprise open source data warehouse for modern analytical workloads. We call it MariaDB AX. It’s for everything from traditional business intelligence/reporting and data mining to modern analytics, including decision support systems and recommendation engines. Learn what it takes to be an enterprise open solution for modern analytics and data warehousing.
In order to have faster time to insight and time to action it’s critical that:
Organizations make data available for analysis as soon as it arrives, and;
Applications stream data from data sources to analytics platform seamlessly.
The new MariaDB AX includes MariaDB ColumnStore Data Adapters, enables easy integration with data from various sources such as web/mobile services, IoT, sensors, social networks, device logs and machine learning model output.
I'm excited that our second major GA release of MariaDB ColumnStore 1.1 is now available for download. In this blog, I review some of the major features that make up this release. Our focus for this release was to enable greater extensibility and to provide some additional features that have come up as we have worked with prospects and customers.
MariaDB ColumnStore 1.0 supports User Defined Functions (UDF) for query extensibility. This allows you to create custom filters and transformations to suit any need. This blog will outline adding support for distributed querying of JSON data.