Download the UnityJDBC installation package which contains the JDBC Driver for MongoDB and example Java programs.Start using the JDBC Driver for MongoDB in 5 minutes: SQL features not natively supported by MongoDB and the JDBC driver are executed using the UnityJDBC virtualization engine.Metadata is exposed to relational systems through JDBC by building a representative schema by sampling the datastore and fitting the least-general type that will represent the data.
The generated MongoDB query can be output in text form which provides a SQL to MongoDB translation tool and service.The SQL query is validated and translated into a MongoDB query and executed using the MongoDB Java library.Full support for nested documents (subdocuments) and arrays including filters and expressions.Perform SQL joins across MongoDB collections and databases.Manipulate and control data using standard SQL functions not natively supported by MongoDB.Works with all reporting and query software that supports JDBC including Tableau, Splunk, Tibco JasperReports, SAP Lumira, QlikView, and hundreds of others.Access data in MongoDB collections via SQL including WHERE filters, GROUP BY, and ORDER BY.Perform cross-source reporting and analyticsīuild applications that work with any database system.ĭownload UnityJDBC for SQL Virtualizationĭownload the open source multisource plugin for SQuirreL JDBC Driver for Splunk (supports Tableau)Ĭustom software development and consulting for your data challengesĪdd cross-platform translation and querying to your query software.SQL Virtualization, Translation, and Integration of NoSQL and SQL data sources UnityJDBC JDBC Driver for MongoDB JDBC Driver for Splunk JDBC Driver for ServiceNow SQuirreL Multiple Source Plugin Purchase Company