Connecting to ElasticSearch with MicroStrategy

ElasticSearch is an open-source search engine based on Lucene that provides multitenant-capable full-text search capabilities. The main open-source visualization tool, Kibana, that is used to connect to ElasticSearch is fairly limited in its visualization capabilities. Strategy’s new Gateway connector can enable analysts to derive new insight from ElasticSearch.
 
2 minute ElasticSearch video:

1. Navigate to Kibana (open source tool that takes minutes to install) and show the limited functionality
2. Preview Data
3. Publish cube (Theater Company Analysis)
4. Build a visualization with expanded visualization and reporting capabilities

• Leverage an expanded set of visualizations
• Create metrics at multiple levels
• Visualizations that filter one another for enhanced discovery

1. Set up cubes to be published on a schedule and share dashboard with others

 
More in-depth video: (7 minutes)
Directly query elastic search server

1. Navigate to Kibana (open source tool that takes minutes to install) and show the limited functionality
2. Install node.js
3. Install elastic search connector and start the service
4. Verify parameters have been set in elasticsearch.yml (additional parameters: https://www.elastic.co/guide/en/elasticsearch/reference/current/modules-http.html)
5. Preview Data
6. Publish cube (Theater Company Analysis)
7. Build a visualization with expanded visualization and reporting capabilities​

• Create metrics at multiple levels
• Leverage an expanded set of visualizations
• Visualizations that filter one another

1. Set up cubes to be published on a schedule and share dashboard with others