VOOZH about

URL: https://www.cdata.com/kb/tech/mongodb-jdbc-datagrip.rst

⇱ Query MongoDB Data in DataGrip

Query MongoDB Data in DataGrip

👁 Jerod Johnson
Jerod Johnson
Director, Technology Evangelism
Create a Data Source for MongoDB in DataGrip and use SQL to query live MongoDB data.

DataGrip is a database IDE that allows SQL developers to query, create, and manage databases. When paired with the CData JDBC Driver for MongoDB, DataGrip can work with live MongoDB data. This article shows how to establish a connection to MongoDB data in DataGrip and use the table editor to load MongoDB data.

About MongoDB Data Integration

Accessing and integrating live data from MongoDB has never been easier with CData. Customers rely on CData connectivity to:

MongoDB's flexibility means that it can be used as a transactional, operational, or analytical database. That means CData customers use our solutions to integrate their business data with MongoDB or integrate their MongoDB data with their data warehouse (or both). Customers also leverage our live connectivity options to analyze and report on MongoDB directly from their preferred tools, like Power BI and Tableau.

For more details on MongoDB use case and how CData enhances your MongoDB experience, check out our blog post: The Top 10 Real-World MongoDB Use Cases You Should Know in 2024.


Getting Started


Create a New Driver Definition for MongoDB

The steps below describe how to create a new Data Source in DataGrip for MongoDB.

  1. In DataGrip, click File -> New > Project and name the project 👁 Creating a new DataGrip project.
  2. In the Database Explorer, click the plus icon () and select Driver. 👁 Adding a new Driver.
  3. In the Driver tab:
    • Set Name to a user-friendly name (e.g. "CData MongoDB Driver")
    • Set Driver Files to the appropriate JAR file. To add the file, click the plus (), select "Add Files," navigate to the "lib" folder in the driver's installation directory and select the JAR file (e.g. cdata.jdbc.mongodb.jar).
    • Set Class to cdata.jdbc.mongodb.MongoDB.jar
  4. Click "Apply" then "OK" to save the Connection 👁 A configured Driver (Salesforce is shown).

Configure a Connection to MongoDB

  1. Once the connection is saved, click the plus (), then "Data Source" then "CData MongoDB Driver" to create a new MongoDB Data Source.
  2. In the new window, configure the connection to MongoDB with a JDBC URL.

    Built-in Connection String Designer

    For assistance in constructing the JDBC URL, use the connection string designer built into the MongoDB JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

     java -jar cdata.jdbc.mongodb.jar

    Fill in the connection properties and copy the connection string to the clipboard.

    Set the Server, Database, User, and Password connection properties to connect to MongoDB. To access MongoDB collections as tables you can use automatic schema discovery or write your own schema definitions. Schemas are defined in .rsd files, which have a simple format. You can also execute free-form queries that are not tied to the schema.

    👁 Using the built-in connection string designer to generate a JDBC URL (Salesforce is shown.)
  3. Set URL to the connection string, e.g., 
    jdbc:mongodb:Server=MyServer;Port=27017;Database=test;User=test;Password=Password;
  4. Click "Apply" and "OK" to save the connection string 👁 A configured Data Source (Salesforce is shown).

At this point, you will see the data source in the Data Explorer.

Execute SQL Queries Against MongoDB

To browse through the MongoDB entities (available as tables) accessible through the JDBC Driver, expand the Data Source.

👁 Exploring the data (Salesforce is shown.)

To execute queries, right click on any table and select "New" -> "Query Console."

👁 Opening a new Query Console.

In the Console, write the SQL query you wish to execute. For example: 

SELECT borough, cuisine FROM restaurants
👁 Querying with SQL (Salesforce is shown.)

Download a free, 30-day trial of the CData JDBC Driver for MongoDB and start working with your live MongoDB data in DataGrip. Reach out to our Support Team if you have any questions.