Get Free Trial

Introducing Flexmonster Pivot for Elasticsearch

PLEASE NOTE: Since we update Flexmonster Pivot with new features biweekly, the information might become outdated. Please check our latest news.


Today we are glad to announce that we have released a public version of Flexmonster Pivot Table & Charts that supports Elasticsearch data source. To put it simply, from now you can create insightful reports based on the data from an Elasticsearch index directly in the browser. And, as always, Flexmonster requires minimum efforts to set up the configuration to do that. The whole process is truly time-saving. You can make it sure by personal experience.

What is Elasticsearch and why is it so cool?

Elasticsearch is known as the hottest full-text search engine in the tech world. Furthermore, it’s a free and open-source technology for exploring the structured and unstructured data. It has the capability of scaling out to hundreds of servers, and, as a result, processing huge amounts of data.

Here at Flexmonster, we were really impressed by how fast Elasticsearch executes complex queries with multiple aggregations. That makes it the perfect match if you want to achieve high-performance pivot reports.

How does it work with Flexmonster?

The key feature is that there is no need to load all the raw data into the pivot table to build the cube – a multi-dimensional representation of the data. Flexmonster sends a sequence of queries to get the summarized data from Elasticsearch. It makes possible it to see the insights based on gigabytes of data just in a matter of seconds. Also, there is no need for complex server-side configurations since Elasticsearch has a built-in RESTful API. You only need to connect the Elastic host URL and the index name.

Real-time demo

As the saying goes: a picture is worth a thousand words. Instead of reading about it, it’s better to have the first-hand experience with a live demo to see the component capabilities in action.

Download and try it yourself

Be the first to test and enjoy a new beta version of Flexmonster & Elasticsearch. It is already available for download on our website with a detailed guide inside the package.

Please note, that you need to enable CORS (disabled by default) to be able to connect to the Elasticsearch server directly from the browser. To do that, open elasticsearch.yml and add the following configuration:

http.cors.enabled: true
http.cors.allow-origin: "*"
http.cors.allow-credentials: true
http.cors.allow-headers: "X-Requested-With, Content-Type, Content-Length, Authorization"

Also, if you are going to allow a connection to the Elasticsearch server from outside the localhost, you need to open an appropriate port in the firewall. The default one is 9200, but it may be different depending on the configuration in the elasticsearch.yml file.

We have also prepared blow-by-blow documentation for you to ease your integration process after download.

Let’s give it a try?!