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.
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.
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.
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.
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
port in the firewall. The default one is
9200, but it may be different depending on the configuration in
Let’s give it a try?!