Skip to main content
Windward

MongoDB

autotag-wiki-logo.pngThis Data Source is not supported.  Code was removed in version 16, but we can get it working for a fee.

Overview

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.

Details

MongoDB is typically queried with a JavaScript-like query language to read and aggregate data. The Windward MongoDB drivers have been designed to deviate from this language as little as possible, and for most query operations, it is unlikely that one would need to change their select statement. We even provide support for the very powerful mapReduce functionality which MongoDB exposes. 

Connecting to MongoDB Data Sources

MongoConnection.PNG

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 Metadata

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/

  • Was this article helpful?