ATLAS

Atlas SQL Interface, Connectors, and Drivers

Easily query, analyze, and visualize Atlas data with SQL-based tools.

Tableau logo image
Power BI logo image
JDBC & ODBC Drivers image

Atlas SQL Interface

Through MongoDB’s Atlas SQL Interface, you can leverage existing SQL knowledge and familiar tools to query and analyze Atlas data. It uses MongoSQL, a SQL-92 compatible dialect that’s designed for the document model, and leverages Atlas Data Federation under-the-hood so you can query across Atlas clusters and cloud storage, like S3, with simplified sql schema management in Atlas to enhance data analytic workflows.

Illustration that represent query and gather insight with Atlas SQL.
Illustration of a gear and a power cord connecting to an outlet.

Atlas SQL Connectors & Drivers

Atlas SQL Connectors and Drivers allow you to easily connect your SQL-based business intelligence and analytics tools to Atlas, enabling you to find insights faster on live application data. Built by MongoDB, they provide a first-class querying experience of Atlas data through your preferred tool.

Select a SQL-based tool

PowerBI Connector

Certified by Microsoft, the PowerBI Connector for MongoDB Atlas supports DirectQuery for real-time data access and Import Query for in-memory analytics, enabling querying of live Atlas data and access to native PowerBI features. This includes full Power Query, Power BI Desktop, and Service functionality.

Learn more

Tableau Connector

The Tableau Connector for MongoDB Atlas enables querying live Atlas data with access to native Tableau features, such as custom SQL, calculated columns and raw SQL pass-through, and split columns.

Learn more

ODBC Driver

Leverage the Atlas SQL ODBC driver to connect your SQL-based tools that accept an Open Database Connectivity API.

Learn more

JDBC Driver

Leverage the Atlas SQL JDBC driver to connect your other SQL-based tools that accept the Java Database Connectivity API.

Learn more
Ganson Street logo image
"The old-school method of moving large data sets around takes time and effort. The Power BI Connector for Atlas creates a direct connection between our dashboards and our operational data, allowing us to find insights on the data we need in real-time. This means faster, more informed decisions for our clients."
Sam Marrazzo
Founder at Ganson Street

Looking for something else?

Integrate MongoDB with other components of your ecosystem.