Connect to Data Lake with JDBC Driver
On this page
The support for SQL format queries is available as a Beta feature. The feature and the corresponding documentation may change at any time during the Beta stage.
You can use the JDBC driver to connect to Atlas Data Lake and run SQL format queries on your Data Lake collections and views. The JDBC driver can be used to connect a Java application like a Maven project or a visualization tool like Tableau. To run SQL format queries, your collections or views must already have the relational schema set. See Query with SQL to learn more about automatically or manually generating and setting schemas for your collections and views.
This page describes how to install and configure the JDBC driver for connecting to Atlas Data Lake.
Connect with Maven Project
Configure the driver for your Maven application.
To connect with your Maven application:
- Click on the JDBC driver version in the JDBC Driver download page to open the JDBC Driver page for that version.
Click the copy icon in the Apache Maven on the right-hand side to copy the dependency.
For example:
Open your Maven project and add the dependency to your pom.xml file.
Connect with Tableau
You can only connect to one database at a time. To query multiple databases, you must create multiple connections or fully specified SQL queries. When you use the JDBC driver to connect to Atlas Data Lake with Tableau, you can only connect to the database specified in your properties file.
Download the MongoDB Atlas Data Lake JDBC driver JAR file and all associated dependencies by selecting all.jar from the dropdown list in the Download column.
Move the downloaded MongoDB Atlas Data Lake JDBC driver JAR file to one of the following folders.
Operating System | Folder Path |
|---|---|
Windows | C:\Program Files\Tableau\Drivers |
MacOS | ~/Library/Tableau/Drivers |
Configure the driver for your Tableau.
To connect with Tableau, create a properties file with the following settings:
user=<database-user> password=<database-user-password> authSource=admin database=<database-to-query> ssl=true compressors=zlib
Property | Description |
|---|---|
user | Username of the database user in your Atlas cluster. |
password | Password of the database user in your Atlas cluster. |
authSource | Authentication database
of the database user in your Atlas cluster, which is
always admin. |
database | Database in the Atlas cluster that contains the data to query. Important When you use the JDBC driver to connect Tableau to Atlas Data Lake, you can only connect to the database specified here. |
ssl | Whether format of the query is SSL. Value must be
true. |
compressors | File compression format. Value must be zlib. |
Open Tableau Desktop to configure the database to connect to.
From the left navigation under Connect To a Server, select More and click Other Databases (JDBC).
In the Other Databases (JDBC) window, specify the following settings:
UI Field | Description | ||||
|---|---|---|---|---|---|
URL | Specify your Data Lake URL in the following format: To construct the URL:
| ||||
Dialect | Select MySQL from the drop-down. | ||||
Properties File | Click Browse and select the properties file to use
for this connection. |
You can leave the Username and Password fields empty if you specified them in the properties file.
Click Sign In.
From the left navigation, select the database to connect to from the drop-down under Database.
