What's New in Atlas Charts: Summer 2023 Release Roundup
Today, we’re excited to announce a series of updates to Atlas Charts . The Charts team is constantly adding enhancements to make visualizing data from MongoDB Atlas collections quick, easy, and powerful. With this summer’s release, we are introducing: Expanded chart customization options in the Charts Embedding SDK An out-of-the-box billing dashboard for easily monitoring your Atlas billing data Support for a new chart type with candlestick charts, and Query execution improvements for more reliable visualization of even your largest datasets. Let’s go through these updates one by one. Expanded charts customization options in the Charts embedding SDK Embedded charts and dashboards can be a useful way to share information across an organization and even with your customers. Over the last year, we have made many improvements to getting started with and implementing embedded charts and dashboards. With this release, we focused on the look and feel of your embedded charts. The Charts Embedding SDK now allows for greater customization across attributes like chart titles, descriptions, axes options, channel options, chart color palette, and conditional formatting options. Providing access to these chart specifications matches many of the customization options that developers rely on when building charts inside Atlas. An out-of-the-box Atlas billing dashboard Next, let’s talk about discovering insights from your Atlas billing data. Over the past two years, MongoDB has made visualizing billing data in Atlas Charts possible . Implementing this dashboard required quite a bit of effort in the past, but we heard from many teams that this dashboard is essential to the monitoring of their Atlas bill. So, we worked to build a more streamlined process for enabling these insights. Enter the new billing dashboard. The new billing dashboard in Atlas Charts is as simple as a button click on our new Ingestions page. Simply click Add and open and you’ll see a billing dashboard ready for exploration. The new billing dashboard allows for customization, adding dashboard filters, and getting new views into your data with the ability to add other charts based on your interests. Support for a new chart type: Candlestick charts The third update in this release is support for candlestick charts. While many developers leverage the wide variety of chart types available in Charts, we are always paying attention to additional chart types that can enable even more use cases for visualizing your Atlas data. This is why we have added candlestick charts with this latest release. Candlestick charts are commonly used for financial data, richly representing financial trading trends and price fluctuations. Query execution improvements for more reliable visualization of even your largest datasets Finally, let’s talk about query execution in Charts. One of the key characteristics of Charts is that it works natively with your Atlas data, requiring no data movement or duplication. Developers can simply select a data source to explore and immediately discover insights about application data. However, that doesn’t mean things are simple on the backend when creating a chart. Charts does a lot of work to efficiently render your visualizations as seamlessly as possible. And depending on your cluster configuration and the complexity of the chart you are creating (and the query driving it), Charts can take some time to render and produce the information you are aiming to visualize. Historically, Charts had a timeout duration of 120 seconds. Queries taking longer than this, would fail and not render the desired visualization. With this update, Charts users will see: Improved rendering of more complex queries as we have extended the timeout duration to 10 minutes, and More helpful in-product notification that lets you know when a query may take additional time to run, so you can continue either creating other visualizations or doing other work, until your query finishes. If you have queries requiring a longer timeout duration than 10 minutes, you can contact the Charts team through support. Note: Query Execution will initially be available through contacting Customer Support, or your existing Customer Success team, to opt-in. The feature will become Generally Available to all accounts in October, 2023. With that, we hope these enhancements make Charts even easier and more powerful to use. Over the coming weeks, we’ll go a level deeper, diving into some of these features with more detail. In the meantime, go build some visualizations in Charts to get hands-on and see for yourself! New to Atlas Charts? Get started today by logging into or signing up for MongoDB Atlas , deploying or selecting a cluster, and activating Charts for free.
Real-Time Insights Through the Atlas SQL Interface, Now Generally Available with Custom Connectors for Tableau and Power BI
We are excited to announce the General Availability of the Atlas SQL Interface , a solution built to help analysts gain insights on live application data in real time! Built with a SQL-92 compatible dialect, mongosql, the Atlas SQL Interface, Connectors, and Drivers make it easy to natively query and visualize Atlas data with SQL-based tools while preserving the flexibility of the document model. Through two custom-built connectors – a Microsoft-certified Power BI Connector and a Tableau Connector built in partnership with Tableau – in addition to new versions of our Atlas JDBC and ODBC Drivers for other SQL-based tools, eliminate the need for complex ETL and data duplication. Use custom SQL and native BI tool functionality right in your tool’s interface to transform, analyze, and report on live application data! How it works With the Atlas SQL Interface enabled, download the appropriate JDBC/ODBC Driver and/or Custom Power BI/Tableau Connector to query and transform your document data in your SQL-based tool. The Atlas SQL Interface also leverages Atlas Data Federation as its query engine, so you can query across multiple Atlas databases and other sources, such as cloud storage buckets and HTTPs endpoints, with efficiency. Certified Atlas Power BI Connector The Power BI Connector for Atlas is an integration built by MongoDB and certified by our partners at Microsoft. This Connector makes it easy to model document data with native Power BI features and data modeling capabilities available in Power Query. Build up-to-date dashboards in Power BI Desktop and scale insights to your organization through Power BI Service with no duplication or delays. Check out the demo below to see it in action: Atlas Tableau Connector Built with the Tableau analyst in mind, this specialized Connector ensures a first-class querying experience of live Atlas data from within Tableau without the need to learn MQL, implement unnecessary data pipelines, or perform complex ETL. Directly interact with MongoDB’s JSON-like document data to quickly visualize, graph, and report on live data using native Tableau Features. Check out the demo below to see it in action: This is a fantastic product offering from the MongoDB team, something that the community has needed for years! I really see this feature as bridging the gap, especially for data science and BI people who talk primarily in SQL Software Solutions Architect, Ampcontrol The Atlas SQL Interface, Connectors, and Drivers enable businesses to fully harness the power of their Atlas data, ensuring that our platform not only serves the developers who build applications to help run your business, but that it also serves the teams finding data-driven insights to help scale the business. Log in today to activate the Atlas SQL Interface and get started. Go to our download center to retrieve your Connector and Driver files, or check out our docs for more information on how to put the Atlas SQL Interface, Connectors, and Drivers to use!
Introducing the Certified MongoDB Atlas Connector for Power BI
This is a collaborative post from MongoDB and Microsoft. We thank Alexi Antonino, Natacha Bagnard, Jad Jarouche from MongoDB, and Bob Zhang, Mahesh Prakriya, and Rajeev Jain from Microsoft for their contributions. Introducing MongoDB Atlas Connector for Power BI, the certified solution that facilitates real-time insights on your Atlas data directly in the Power BI interfaces that analysts know and love! Supporting Microsoft’s Intelligent Data Platform , this integration bridges the gap between Developers and Analytics teams, allowing analysts who rely on Power BI for insights to natively transform, analyze, and share dashboards that incorporate live MongoDB Atlas data. Available in June , the Atlas Power BI Connector empowers companies to harness the full power of their data like never before. Let’s take a deeper look into how the Atlas Power BI Connector can unlock comprehensive, real-time insights on live application data that will help take your business to the next level. Effortlessly model document data with Power Query The Atlas Power BI Connector makes it easy to model document data with native Power BI features and data modeling capabilities. With its SQL-92 compatible dialect, mongosql, you can tailor your data to fit any requirements by transforming heavily nested document data to fit your exact needs, all from your Power Query dashboard. Gain real-time insights on live application data By using the Power BI Connector to connect directly to MongoDB Atlas, you can build up-to-date dashboards in Power BI Desktop and scale insights to your organization through Power BI Service with ease. With no delays caused by data duplication, you can stay ahead of the curve by unlocking real-time insights on Atlas data that are relevant to your business. Empower cross-source data analysis The Power BI Connector's integration with MongoDB Atlas enables you to seamlessly model, analyze, and share insightful dashboards that are built from multiple data sources. By combining Atlas's powerful Data Federation capabilities with Power BI's advanced analytics and visualization tools, you can easily create comprehensive dashboards that offer valuable insights into your data, regardless of where it is stored. See it in action Log in and activate the Atlas SQL Interface to try out the Atlas Power BI Connector ! If you are new to Atlas or Power BI, get started for free today on Azure Marketplace or Power BI Desktop .