This Data Source is not supported, but we can get it working for a fee.
The MongoDB driver was added to the Windward solutions in version 12.5. This includes Java and .NET drivers, as well as Wizards for Microsoft Office products.
Want to upgrade to version 13? Head to our downloads page.
Connecting to MongoDB Data Sources
The MongoDB connection window provides fields for all necessary information to connect to a single database instance. Support is provided to connect to multiple hosts, and for advanced connection options (such as the '?replicaSet" option), however these connection strings must be entered manually using the "custom connection string" text box.
MongoDB is a schema-less database system, and as such, the methods for creating metadata information are either not very clean, or not very fast. At Windward, we take the approach of analyzing only the first element of the collection, and making the assumption that the rest of the elements look similar to this one. This process is fairly quick, however it may exclude some data elements from the Data Bin tree. These elements are still accessible via normal queries passed to the engine, however they will not be supported by the drag-and-drop functionality in the query wizard.
Supported Types of Queries
For the most part, any query which will work in MongoDB will also be supported by our software. This includes map-reduce queries, however map-reduce functions are not explicitly supported by the wizards. Map-reduce queries should be manually entered using the "Advanced" functionality of the wizard, or the select text box in the AutoTag ribbon menu.
The one place where we do something unexpected is when working with arrays. The default behavior when trying to output an array is to only output the first value. If you wish to output multiple elements of an array you can use the $slice operator in MongoDB to take a subset of the array. See this article for more information on using the slice operator: http://docs.mongodb.org/manual/reference/operator/projection/slice/