Introduction

We are thrilled to announce an exciting and transformative collaboration between Explo, a top-tier data visualization tool, and Cube, the industry's leading semantic layer for all data apps. This collaboration equips users with the ability to unify schemas across data sources and leverage advanced caching/pre-aggregation functionality to deliver near real-time speed to Explo’s embedded analytics offering.

By integrating Cube's adaptable querying interface into Explo, we have made it possible for users to query NoSQL databases as if they were SQL. This development broadens the array of data sources that can be visualized, all while utilizing the powerful, user-friendly interface provided by Explo. Envision the ease of querying a MongoDB database, just like you would with a SQL database, and then visualizing it using Explo's robust suite of data visualization tools. This collaboration signifies a game-changing enhancement to the capabilities of Explo. To demonstrate the power of the Explo and Cube collaboration, we present a quick tutorial on creating an embedded analytics experience using MongoDB, Explo, and Cube.

Step 1: Install and Set up Cube and Explo

Before integrating, you need to have both Cube and Explo installed and set up. To sign up for an account with Cube's cloud offering, you may go here. To sign up for an Explo account, go here.

‍

Step 2: Setup Cube with MongoDB

‍

First, login to Cube

Click 'Create Deployment'

Select deployment options and click "Next'

Click 'Create'

Select MongoDB

Navigate to MongoDB Atlas and click 'Create'

‍

Select a minimum M10 cluster

Enable Business Intelligence Connector and set the Sample Refresh Interval

Create a user with both Atlas admin and dbAminAnyDatabase privileges, set with username and password.

Go to your newly created deployment and click "Connect"

Navigate to BI Connector

Get your MongoDB credentials

Navigate back to Cube and input your credentials. Toggle on SSL.

‍

Go back to MongoDB and add the IPs from Cube.

‍

Go through the steps to Select Tables, Measures and Dimensions, set Primary Keys, and Joins.

Finally, navigate to BI Integrations and grab the Cube credentials

‍

‍

Step 3: Establish a Connection from Cube to Explo

Once both platforms are set up, you can establish a connection from Cube to Explo. In the Explo dashboard, go to the 'Data' tab and choose 'Connect Datasource'. Choose 'Cube' as your database, fill in your Cube credentials and establish the connection.

‍

‍

Step 4: Create Cube Dashboard

Once your data is imported, you can start creating dashboards. Navigate to the 'Dashboards' tab and click 'Create Dashboard'.

Step 5: Write SQL

In the dashboard, write SQL to access your data. Click 'Save and Run' to see a sample of your data.

Step 6: Create a Chart

Visualize your data via a chart in Explo. Drag on a chart, select the dataset to create a visualization from, define the x-axis and y-axis for the chart, then watch as you created your first visual from raw warehouse data!

‍

Step 7: Embed in Your Application

Conclusion

In conclusion, the partnership between Explo and Cube transcends a mere collaboration between two leading data solutions - it opens up new use cases for the customer-facing analytics industry. By erasing the boundaries between SQL and NoSQL databases, we are creating new pathways for extracting valuable insights from data. Additionally, with Cube’s transformational semantic layer, users can now save significant development time by ensuring data consistency across sources. Coupled with Cube’s advanced caching/pre-aggregation capabilities, users can now be assured that their customer-facing analytics offerings will perform at lightning speed with minimal maintenance requirements within their applications.

We are confident that this collaboration will enrich your experience and broaden your capabilities as a data professional. We invite you to delve into this new integration and elevate your data visualization and analytics game.

This announcement signifies the next chapter in Explo’s commitment to providing cutting-edge data solutions, and we are thrilled to embark on this journey with all of you

‍