![]() This is free software, licensed under: The Apache License, Version 2. This software is Copyright (c) 2011 by David Golden. It is not possible to combine -eq with other comparisons on the same field or to combine multiple constraints on the same field using the same operator (e.g. Search queries have limitations based on the underlying MongoDB search API. See Metabase::Index, Metabase::Query and Metabase::Librarian for details on usage. See Metabase::Backend::MongoDB for constructor attributes. StrongDM simplifies data visualization by granting Metabase users centralized access to containers, databases, logging tools, and more. ![]() This is an implementation of the Metabase::Index and Metabase::Query roles using MongoDB. MongoDB: Integrating into a Metabase workflow Teams using Metabase to generate graphics and dashboards need access to MongoDB and other digital resources. Version 1.000 SYNOPSIS use Metabase::Index::MongoDB If you also want to explore your data with no-code open-source tools click on the button below to get a fully managed instance of Metabase ready to use in less than 3 minutes.Metabase::Index::MongoDB - Metabase index on MongoDB VERSION The whole team loved it, they are now autonomous for these kind of tasks. Then I invited few employees of the customer to the Metabase instance and they were really impressed by how easy it was to create new reports or view information from the DB without knowing SQL. Minerva guides show you how to do anything on Metabase with expert knowledge. In a very short time I had deployed Metabase, connected it to the replica MySQL database of the customer, created a report in few clicks and automated the report and CSV export to be sent on a schedule to the accountant! This is an example KPIs dashboard that can be produced in few clicks with Metabase There are two ways to connect to MongoDB: Using the Metabase fields to input your connection details. I chose Metabase because has a nice visual interface, it is intuitive (I never had to check the documentation), and had all the features I required like being able to export in CSV, XLSX, JSON, and the scheduled reports that can be sent to a list of recipients according to a schedule, and finally being able to invite the non-technical team members to use the tool safely with groups & permissions. This time I wanted to try something open-source and there are several very good options like Redash, Superset, Lightdash or Metabase. There are a lot of Business Intelligence tools on the market, but from my experience they are either too limited or too complex or too expensive (e.g. Then, I would have to create a Web UI with filters that will call the API endpoint and also create a scheduled job that will send the report on the expected date/time. Usually to do that I have to create a new API endpoint that will do authentication, execute a complex SQL query against the database and transform the results to CSV. Last week, one of our startup customers (e-commerce) contacted me to create a new database query, apply a lot of special conditions, make it available in their dashboard and send it on the last day of each month to the company's accountant. A roles & permissions system for inviting your colleagues. ![]() The ability to subscribe to dashboards and receive them on a schedule by email or slack. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |