The Progress® DataDirect® for ODBC™ for MongoDB™ driver supports SQL to select data from MongoDB data sources. Some insert, update, and delete capabilities are also supported. The driver translates the SQL statements provided by an application, 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.

Once the driver has generated a 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 documentation for the driver also includes the Progress DataDirect for ODBC Drivers Reference. The reference provides general reference information for all DataDirect drivers for ODBC, including content on troubleshooting and supported functions. For the complete documentation set, visit the Progress DataDirect Connectors Documentation Hub.