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 →

Hanabi Technologies Uses MongoDB to Power AI Assistant, Hana

For all the hype surrounding generative AI, cynics tend to view the few real-world implementations as little more than “fancy chatbots.” But for Abhinav Aggarwal, CEO of Hanabi Technologies, the idea of a generative AI-powered bot that is more than just an assistant was intriguing. “I’d been using ChatGPT since it launched,” said Aggarwal. “That got me thinking: How could we make a chatbot that was like a team member?” And with that concept, Hana was born. The problem with bots “Most generative AI chatbots do not act like people; they wait for a command and give a response,” said Aggarwal. “We wanted to create a human-like chatbot that would proactively help people based on what they wanted—automating reminders, for example, or fetching time zones from your calendar to correctly schedule meetings.” Hanabi’s flagship product, Hana, is an AI assistant designed to enhance team collaboration within Google Chat, working in concert with Google Workspace and its suite of products. “Our target customers are smaller companies of between 10 and 50 people. At this size you’re not going to build your own agent from scratch,” he said. Hana integrates with Google APIs to deliver a human-like assistant that chimes in with helpful interventions, such as automatically setting reminders and making sure meetings are booked in the right time zone for each participant. “Hana is designed to bring AI to smaller companies and help them collaborate in a space where they are already working—Google Workspace,” Aggarwal explained. The MongoDB Atlas solution For Hana to act like a member of the team, Hanabi needed to process massive amounts of data to support advanced features like retrieval-augmented generation (RAG) for better information retrieval across Google Docs and many other sources. And with a rapidly growing user base of over 600 organizations and 17,000+ installs, Hanabi also required a secure, scalable, and high-performing data storage solution. MongoDB Atlas provided a flexible document model, built-in vector database, and scalable cloud-based infrastructure, freeing Hanabi engineers to build new features for Hana rather than focusing on rote tasks like data extract, transform, and load processes or manual scaling and provisioning. Now, MongoDB Atlas handles a variety of responsibilities: Scalability and security: MongoDB Atlas’s auto-scaling and automatic backup features have enabled Hanabi to seamlessly grow its user base without the need for manual database management. RAG: MongoDB Atlas plays a critical role in Hana’s RAG functionality. The platform enables Hanabi to split Google Docs into small sections, create embeddings, and store these sections in Atlas’s vector database. Development Processes: According to Aggarwal, MongoDB’s flexibility in managing changing schemas has been essential to the company’s fast-paced development cycle. Data Visualization: Using MongoDB Atlas Charts has enabled Hanabi to create comprehensive dashboards for real-time data visualization. This has helped the team track usage, set reminders, and optimize performance without needing to build a manual dashboard. Impact and results With MongoDB Atlas, Hanabi can successfully scale Hana to meet the demands of its rapidly expanding user base. The integration is also enabling Hana to offer powerful features like automatic interactions with customers, advanced information retrieval from Google Docs, and manually added memory snippets, making it an essential tool for teams around the world. Next steps Hanabi plans to continue integrating more tools into Hana while expanding its reach to personal Gmail users. The company is also rolling out a new automatic-interaction feature, further enhancing Hana’s ability to proactively assist users without direct commands. MongoDB Atlas remains a key component of Hanabi’s stack, alongside Google Kubernetes Engine, NestJS, and LangChain, enabling Hanabi to focus on innovating to improve the customer experience. Tech Stack MongoDB Atlas Google Kubernetes Engine NestJS LangChain Are you building AI apps? Join the MongoDB AI Innovators Program today! Successful participants gain access to free MongoDB Atlas credits, technical enablement, and invaluable connections within the broader AI ecosystem. If your company is interested in being featured, we’d love to hear from you. Connect with us at ai_adopters@mongodb.com.

November 21, 2024