DCI Interface Hero

MongoDB JDBC Driver

MongoDB logo

Select your platform

Table of Contents:

    Overview

    Progress DataDirect’s JDBC Driver for MongoDB offers a high-performing, secure and reliable connectivity solution for JDBC applications to access MongoDB data. Our JDBC driver can be easily used with all versions of SQL and across both 32-bit and 64-bit platforms. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as SAS, Yellowfin, SAP, Sisense, Denodo, Cognos, Jaspersoft, Tableau, Tibco, OBIEE, and more.

    • DataDirect quality exclusively certified by MongoDB, Inc.
    • Supports connectivity to Microsoft Azure CosmosDB via the MongoDB API  Reference information found here
    • Get instant SQL access to business-critical NoSQL data
    • Integrate MongoDB data with unlimited document normalization and without duplication data or flattening documents


    Features

    Authentication Enhancements

    • Authentication using SCRAM SHA-256 authentication mechanism. The driver will automatically detect if the user ID is configured for SCRAM SHA-256 authentication and use it to log in to the database.
    • Authentication through an external LDAP proxy service.

    Performance Enhancements

    • The normalization algorithm has been upgraded to improve sampling performance and optimize the generation of tables in the relational view.
    • The schema map files saved to disk now utilize gzip compression in order to significantly reduce the file size.
    • Support for migrating schema maps and internal files created with the 6.0 version of the driver so that they can be used by the 6.1 driver.
    • Enhancement of the driver to allow you to limit sampling to only new collections when refreshing the schema map.

    Connection Enhancements

    • Support for connections to MongoDB Atlas clusters using a DNS seed list.
    • Added support for connections through a proxy server.
    • DataDirect JDBC Driver Configuration Manager for quick configuration and testing of your driver.

    New Driver Properties

    • The new QualifyNormalizedNames property allows you to determine whether names of relational child-tables normalized from arrays, objects, subdocuments are prefixed with the collection name and names of any parent objects.
    • The new SpecialCharBehavior property allows you to determine how the driver handles the mapping of native identifiers containing characters that would require them to be quoted in SQL statements.
    • New ReplicaSetName connection property that supports replica set failover for write operations.
    • The new SchemaFilter connection property allows you to limit the databases and collections for which the driver fetches metadata
    • The new EnableDNSLookup property specifies whether the driver performs a DNS lookup to discover member nodes of an Atlas cluster when connecting.
    • New SchemaFormat connection property allows you to determine to which relational view the driver maps data, including normalized, mixed, and flattened views.

    Fast

    Superfast data loading and extraction that reduces the time and cost of running enterprise infrastructures 

    Enterprise Features

    Extensive support of data types to enable the full use of Greenplum functionality 

    Secure

    Supports the latest TLS protocols for data encryption, secure authentication methods for connections and HTTP Proxy for client security while connecting to cloud deployments 

    Robust

    Ensure high availability via application failover and workload balancing without changing application code 

    Easy to Use

    True standards compliance with ODBC and JDBC 

    Versatile

    Supported on every major platform and certified to work with leading applications such as Tableau, Informatica, ODI and more 

    Technical Specifications

    Progress DataDirect for JDBC for MongoDB Driver
    Version 6.1.0

    Database Support

    • MongoDB 7.0 and higher
    • MongoDB 6.0 and higher
    • MongoDB 5.0 and higher
    • MongoDB 4.0 and higher
    • MongoDB Atlas 6.0 and higher
    • MongoDB Atlas 5.0 and higher
    • MongoDB Atlas 4.0 and higher
    • Microsoft Azure Cosmos DB for MongoDB 4.0 and higher
    • Microsoft Azure Cosmos DB for MongoDB 3.6 and higher
    • WiredTiger Storage Engine

    Platform Support

    • 32- and 64-bit platforms

    Software Requirements

    • Java Virtual Machine (JVM): Java SE 8 or higher (LTS version), including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.

    Documentation

    Connect any application to any data source anywhere

    Explore all DataDirect Connectors

    A product specialist will be glad to get in touch with you

    Contact Us