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 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.
Nishanth Kadiyala
