Working with data from different sources can quickly become messy and inaccurate. Many businesses, especially enterprises, collect and store significant amounts of data. However, they struggle to integrate their data into strategy and decision-making. Using data as a meaningful input into the decision-making process requires finding the correct data, analyzing it, and then sharing it with colleagues and leaders.
This is why we are excited to expand our data integration capabilities by adding support for Databricks and MongoDB. These new integrations make it faster and easier for users to connect to external databases using Observable’s data connector or the self-hosted database proxy. As a result, users can uncover insights faster by securely querying databases from Observable and using query results to build visualizations.
Let’s explore these two new integrations in more detail.
Databricks’s platform is good at helping data practitioners extract, transform, and load data, but it’s not as conducive to data visualization. That’s where Observable comes in!
By using our integration with Databricks, you can connect to a Databricks cluster or SQL warehouse from an Observable notebook. This allows you to simply and quickly retrieve data from Databricks using SQL within an Observable notebook. From there, you can leverage query results to conduct interactive analysis, explore your data, and create visualizations that your entire team can understand.
Our new integration with MongoDB takes advantage of MongoDB Connector for BI and allows you to use the SQL interface in Observable to query your MongoDB cluster. The MongoDB Connector for BI doesn’t store any data — it just bridges your MongoDB cluster and your Observable notebooks.
Observable compliments MongoDB by providing the tools developers need to analyze, visualize, and collaborate around data. By querying your MongoDB cluster directly from your Observable notebook, you can more easily import data into Observable. This means you can quickly build visualizations and start discovering insights.
Using data to drive decision-making and increase shared understanding across teammates doesn’t have to be challenging and time consuming. These integrations make it easier for you to tap into the data you need and use it to create powerful visualizations that everyone on your team can grok. As a result, you can work more efficiently and effectively.
To get started with Databricks or MongoDB in Observable, visit our docs to learn more about connecting to databases and our self-hosted database proxy. Not yet an Observable user? Get started by creating an account here.