The Progress DataDirect forODBC for MongoDB driver supports SQL to select data from MongoDB databases and some insert, update, and delete capabilities. The driver supports MongoDB version 2.2 and higher.
The driver translates the SQL statements provided by an application into native queries, enabling you to leverage your knowledge of SQL. Additionally, the driver creates a relational schema of your native MongoDB data to support SQL access to MongoDB's flexible schema data model. The relational schema created by the driver is written to a configuration file that can be shared among client machines accessing a common data store. The configuration file can be modified subsequently using the DataDirect Schema Tool.
The DataDirect Schema Tool is included with the driver. The Schema Tool enables you to customize and perfect the relational schema used to access your MongoDB data. The Schema Tool provides metadata, statistics, and a hierarchical view of your data, as it guides you through the mapping process. You can use the Schema Tool's Table Wizard to expose tabular relationships among your MongoDB data collections. Using the Schema Tool, you can create new relational views of your data with options to flatten, normalize, or customize your MongoDB data. In turn, the Schema Tool allows you to define data types consistently within columns, a critical step in ensuring data integrity.
Once you have an established relational schema, the relationships among objects can be reported through the following metadata methods: SQLColumns, SQLForeignKeys, SQLGetTypeInfo, SQLPrimaryKeys, SQLSpecialColumns, SQLStatistics, and SQLTables. Furthermore, when performing joins, the driver leverages data relationships in MongoDB collections, minimizing the amount of data that needs to be fetched over the network.
The driver can be used with industry standard tools, including: