Connect to Data Lake with JDBC Driver¶
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 Querying 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¶
Open your Maven project and add the dependency to your
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.
Move the downloaded MongoDB Atlas Data Lake JDBC driver JAR file to one of the following folders.¶
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
Username of the database user in your Atlas cluster.
Password of the database user in your Atlas cluster.
Authentication database of the database user in your Atlas cluster, which is always
Database in the Atlas cluster that contains the data to query.
When you use the JDBC driver to connect Tableau to Atlas Data Lake, you can only connect to the database specified here.
Whether format of the query is SSL. Value must be
File compression format. Value must be
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:¶
Specify your Data Lake URL in the following format:
To construct the URL:
Select MySQL from the drop-down.
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.