Real-Time Insights Through the Atlas SQL Interface, Now Generally Available with Custom Connectors for Tableau and Power BI

Mayur Nagarsheth and Jad Jarouche
June 26, 2023 | Updated: September 9, 2024

>> Announcement: Some features mentioned below will be deprecated on Sep. 30, 2025. Learn more.

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!

← Previous

MongoDB Simplifies the Partner Ecosystem for Customers and Recognizes Partner Excellence

Organizations today have a clear imperative– building modern applications to prepare their business for the future. At MongoDB, the leading cloud-native developer data platform, we harness the power of our ecosystem to connect our customers with the innovative technology and services needed to build the modern applications end-users love. Every day, tens of thousands of customers and millions of developers rely on our flexible document-data model that can handle any type of data at scale. To keep pace with MongoDB’s growth, the partner ecosystem has also matured, expanding to every vertical, industry, and geography, and delivering MongoDB to tens of thousands of customers. With more than 1,000 partners across the globe, and more than 80% of MongoDB's new business touched by partners, the internal MongoDB Partner organization has quintupled in size since 2019 to support partners and provide global coverage. Alan Chhabra, EVP of WW Partners Now, we’re excited to announce the further evolution of our partner program, which introduces five distinct categories to help customers understand what partners have to offer with MongoDB: Technology, Powered by MongoDB, Cloud, Go-to-Market, and Solutions and Services partners. MongoDB partners are able to fall into multiple categories, as partners can fulfill different roles with many different solutions. MongoDB Technology Partners deliver proven interoperability and technology integrations that solve industry problems, build credibility, and establish trust with our joint customers. Some of our MongoDB Technology partners include Confluent, Vercel, Datadog, and others. Powered by MongoDB Partners offer software solutions, delivered as SaaS or packaged solutions, for technology or industry problems, built on MongoDB technology. Some of our Powered By MongoDB partners include Temenos, Commercetools, Transmit Security, Featurespace, Volante, and others. MongoDB Cloud Partners offer a certified MongoDB cloud service for their customers, backed by MongoDB technology, support and GTM. Examples of these alliances include Microsoft, Rackspace, Digital Ocean, and more. MongoDB Solutions and Services Partners solve customer problems better and faster with certified skills on MongoDB technology. These partners drive innovation and business impact with MongoDB validated professional services, leveraging their certified MongoDB skills, and service practices. Examples of these partnerships include Gravity9, Wekan, Clarity Solutions, PureInsights, TCS, Infosys, Cognizant, HCL, Wipro, Deloitte, and Tech Mahindra. As we update our partner program, we also want to recognize the global partners that helped drive exceptional joint success over the past year. We are proud to announce our 2023 Partner of the Year Awards , which align to our new partner program categories and represent partners from across the ecosystem. Technology Partner of the Year: Databricks We recognize Databricks for our joint Lakehouse and MongoDB Atlas solution, which expertly enables companies to easily build analytics and AI into operational applications in the cloud. This year, we jointly aligned on our product roadmaps and a go-to-market solution, formalizing what many of our customers were already doing and creating an avenue for more users to achieve the same success. Powered by MongoDB Partner of the Year: BigID BigID is a leader in data security, privacy, compliance, and governance. BigID leverages MongoDB to generate data insights at scale, automate advanced discovery & classification, and accommodate complex enterprise requirements. This year, we expanded our partnership internationally, focusing on GTM efforts in markets like the UK, France, and Italy across the Financial Services and Retail industries. Cloud Partner of the Year - Marketplace: AWS AWS Marketplace continues to lead in terms of transactions for MongoDB customers. The launch of the MongoDB Atlas Pay-As-You-Go Listing on AWS Marketplace made it even easier for the customers of MongoDB to procure MongoDB Atlas and start their development on cloud. AWS provides exceptional support to its marketplace partners and MongoDB has seen great benefits across both co-sell and co-marketing initiatives. The collaboration between AWS and MongoDB continues to benefit customers and makes them worthy of our Cloud Partner of the Year - Marketplace award. Cloud Partner of the Year - Hybrid: IBM IBM is a global technology company that provides infrastructure, software, hybrid cloud services, and cognitive computing to global enterprise clients. This year, IBM and MongoDB continued to drive value and performance that empowers our customers to accelerate their digital transformation and hybrid cloud journey. Cloud Partner of the Year - International: Alibaba Cloud Alibaba Cloud and MongoDB have partnered to offer ApsaraDB for MongoDB, a fully managed database service that makes it easy to build and scale modern applications specifically in the APAC and Greater China markets. Since 2019, this partnership has led to 8x growth in customer usage and, over the past year, we’ve seen an increasing number of customers across a variety of industries, including gaming, automotive, and content development. Cloud Partner of the Year - Go-to-Market: Google Cloud Since 2019, Google Cloud and MongoDB have worked together to give businesses the infrastructure, data intelligence, and developer centric tools they need to power modern data-driven applications. This past year, we expanded this partnership by developing a joint go-to-market strategy, increasing the reach of our pay-as-you-go offering and increasing deals driven by marketplace transactions by 260%. Solutions Partner of the Year: Exafluence Exafluence is a leading data and analytics company that focuses on empowering organizations to stay ahead of the curve in their respective industries. Exafluence has pioneered several highly strategic healthcare solutions on MongoDB across regulatory compliance and care quality management. We look forward to continuing to build and expand with Exafluence, our Solutions Partner of the Year. Services Partner of the Year - AMER: Accenture Together, MongoDB and Accenture provide unparalleled expertise to help customers modernize their environments—and adopt a cloud-first approach throughout their organization. As the cloud becomes more critical to managing data at scale, our partnership helps enterprises unlock value from legacy data by building new applications and modernizing existing applications faster. Through a combination of MongoDB's and Accenture’s data-centric tools and technical knowledge we continue to help customers achieve their desired outcomes - the last 12 months has yet again proven the value of our partnership. Services Partner of the Year - International: Capgemini Capgemini is a global leader in cloud, data artificial intelligence, connectivity, software, digital engineering and platforms, with strong focus on environmental impact improvement. Capgemini and MongoDB have been enabling business critical legacy modernization and innovation initiatives in leading enterprise customers across the world, developing unique joint accelerators and industry specific solutions to help our customers differentiate. Services Partner of the Year - Emerging: PeerIslands PeerIslands is a premium consulting firm focused on providing high-velocity digital transformation. PeerIslands developed a suite of tools that allow for easy adoption of MongoDB and seamless modernization of application workloads to MongoDB within enterprises. We are grateful to all of our partners for their hard work and dedication in helping us to deliver the best possible experience to our customers. We look forward to continuing to work with our partners to help customers build and scale their applications on MongoDB. To learn more about the MongoDB Partner Program, please visit our website . Today, we’re thrilled to introduce the MongoDB AI Innovators Program — which provides organizations building AI technology access to credits for MongoDB Atlas, along with accelerated partnership opportunities in the MongoDB Partner Ecosystem. To get started with the MongoDB AI Innovators Program, visit our website .

June 22, 2023
Next →

MongoDB and Partners: Building the AI Future, Together

If you’re like me, over the past year you’ve closely watched AI’s developments—and the world’s reactions to them. From infectious excitement about AI’s capabilities, to impatience with its cost and return on investment, every day has been filled with AI twists and turns. It’s been quite the roller coaster. During the ride, from time to time I’ve wondered where AI falls on the Gartner hype cycle, which gives "a view of how a technology or application will evolve over time." Have we hit the "peak of inflated expectations" only to fall into the "trough of disillusionment?" Or is the hype cycle an imperfect guide, as The Economist argues? The reality is that it takes time for any new technology—even transformative ones like AI—to take hold. And every advance, no matter how big, has had its detractors. A famous example is that of Picasso (!), who in 1968 said, “Computers are useless. They can only give you answers.” (!!) For our part, MongoDB is convinced that AI is a once-in-a-generation technology that will enhance every future application—a belief that has been reinforced by the incredible work our partners have shared at MongoDB’s 2024 events. Speeding AI development MongoDB is committed to helping organizations of all sizes succeed with AI, and one way we’re doing that is by collaborating with the MongoDB partner ecosystem to create powerful, user-friendly AI development tools and solutions. For example, Fireworks.ai —which is a member of the MongoDB AI Applications Program ecosystem —created an inference solution that hosts gen AI models and supports containerized deployments. This tool makes it easier for developers to build and deploy powerful applications with a range of easy-to-use tools and customization options. They can choose to use state-of-the-art, open-source language, image, and multimodal foundation models off the shelf, or they can customize and fine-tune models to their needs. Jointly, Fireworks.ai and MongoDB provide a solution for developers who want to leverage highly curated and optimized open-source models and combine these with their organization’s own proprietary data—and to do so with unparalleled speed and security. “MongoDB is one of the most sophisticated database providers, and it’s very easy to use,” said Benny Chen , cofounder of Fireworks.ai. "We want developers to be able to use these tools, and we want to work with providers who enable and empower developers." Nomic , another MAAP ecosystem member, also enables developers with best-in-class solutions across the entire unstructured data workflow. Their Embed offering, available through the Nomic API , allows users to vectorize large-scale datasets for use in text, image, and multimodal retrieval applications, including retrieval-augmented generation (RAG), using only their web browser. The Nomic-MongoDB solution is a highly efficient, open-weight model that developers can use to visualize the unstructured datasets they store in MongoDB Atlas . These insights help users quickly discover trends and articulate data-driven value propositions. Nomic also supported the recently announced vector quantization in MongoDB Atlas Vector Search , which reduces vector sizes while preserving performance. Last—but hardly least!—there’s our new reference architecture with MAAP partners AWS and Anthropic. Announced at MongoDB.local London , the reference architecture supports building memory-enhanced AI agents, and is designed to streamline complex processes and develop smarter, more responsive applications. For more—including a link to the code on Github— check out the MongoDB Developer Center . Making AI work for anyone and everyone The companies MongoDB partners with aren’t just making gen AI easier for developers—they’re building tools for everyone. For example, Capgemini has invested $2 billion in gen AI and is training 100,000 of its employees in the technology. GenYoda, a solution that helps insurance professionals with their daily work, is a product of this investment. GenYoda leverages MongoDB Atlas Vector Search to analyze large amounts of customer data, like policy statements, premiums, claims history, and health information. Using GenYoda, insurance professionals can quickly analyze underwriters’ reports to make informed decisions, create longitudinal health summaries, and streamline customer interactions to improve contact center efficiency. GenYoda can ingest 100,000 documents in just a few hours and respond to users’ queries in two to three seconds—a metric on par with the most widely used gen AI models. And it produces results: in one example, by using Capgemini’s solution an insurer was able to increase productivity by 15%, add new reports 25% faster (thus speeding decision-making), and reduce the manual effort of searching PDFs, increasing efficiency by 10%. Building the future of AI together So, what’s next? Honestly, I’m as curious as you are. But I’m also incredibly excited. At MongoDB, we’re active participants in the AI revolution, working to embrace the possibilities that lie ahead. The future of gen AI is bright, and I can’t wait to see what we’ll build together. To learn more about how MongoDB can accelerate your AI journey, explore the MongoDB AI Applications Program .

November 4, 2024