You can set up MongoDB connections in Logi Report catalogs to get data from MongoDB databases. A MongoDB connection contains relational schemas which are transformed from the collections in a MongoDB database. From the transformed relational schemas, you can add tables to the Logi Report catalog, and the tables can then be accessed in the same way as JDBC supplied tables.
In addition, for users who wish to write their own MongoDB aggregation pipeline expressions (also referred to as APE), Logi Report Enables them to put the expressions into JSON files (.json) and then import the files to a catalog via the specified MongoDB connection. Logi Report can then load data from the MongoDB database by the expressions in the imported JSON files.
Logi Report Designer supports MongoDB 1.8 and above.
Select the following links to view the topics:
- How Logi Report Gets Data from MongoDB Databases
- Working with MongoDB Connections in a Catalog
- Imported APEs
Note: Logi Report can push down the calculation of the Distinct Count function of an aggregation to MongoDB for speeding up performance when there are a large number of records, as long as it is the only aggregation in a data component and is positioned at the lowest group level.
Please sign in to leave a comment.