- The HEAD of development on the Metabase repository. Use at your own risk.
- The fastest, easiest way to share data and analytics inside your company. An open source Business Intelligence server you can install in 5 minutes that connects to MySQL, PostgreSQL, MongoDB and more! Anyone can use it to build charts, dashboards and nightly email reports.
- Metabase is free, open source business intelligence that installs in minutes and let's anyone in your company create dashboards, set up nightly stats emails, and interactively explore your company's data.
- With the successful adoption of Metabase as our BI solution, we’ve been able to climb up the first two levels (descriptive & diagnostic) of the analytical maturity model. The other two (predictive & prescriptive) will be conquered in the times to come with the data science initiatives that we are actively pursuing!
Not sure if Metabase, or Microsoft Power BI is the better choice for your needs? Check Capterra’s comparison, take a look at features, product details, pricing, and read verified user reviews.
GitHub Readme.md
Metabase is the easy, open source way for everyone in your company to ask questions and learn from data.
- 5 minute setup (We're not kidding)
- Let anyone on your team ask questions without knowing SQL
- Rich beautiful dashboards with auto refresh and fullscreen
- SQL Mode for analysts and data pros
- Create canonical segments and metrics for your team to use
- Send data to Slack or email on a schedule with dashboard subscriptions
- View data in Slack anytime with MetaBot
- Humanize data for your team by renaming, annotating and hiding fields
- See changes in your data with alerts
For more information check out metabase.com
Supported databases
- Officially supported databases.
- Community-supported drivers.
Installation
Metabase can be run just about anywhere so checkout our Installation Guides for detailed instructions for various deployments. Here's the TLDR:
Docker
To run Metabase via Docker, just type
JAR file
To run Metabase via a JAR file, you will need to have a Java Runtime Environment installed on your system.
We recommend the latest LTS version of JRE from AdoptOpenJDK with HotSpot JVM and x64 architecture, but other Java versions might work too.
Go to the Metabase download page and download the latest release. Place the downloaded JAR file into a newly created directory (as it will create some files when it is run), and run it with the following command:
Now, open a browser and go to http://localhost:3000 , and you will be asked a set of questions that will set up a user account, and then you can add a database connection. For this to work you will need to get some information about which database you want to connect to, such as the Host Name and Port that it is running on, the Database Name and the User and Password that you will be using.
Once you have added this connection, you will be taken into the app and you'll be ready to ask your first question.
For a more detailed walkthrough, check out our Getting Started guide.
Some questions come up over and over again. Check here first:FAQ
See SECURITY.md for details.
To get started with a development installation of the Metabase, follow the instructions at our Developers Guide.
Then take a look at our Contribution Guide for information about our process and where you can fit in!
We want Metabase to be available in as many languages as possible. See which translations are available and help contribute to internationalization using our project over at POEditor. You can also check out our policies on translations.
Metabase also allows you to hit our Query API directly from Javascript to integrate the simple analytics we provide with your own application or third party services to do things like:
- Build moderation interfaces
- Export subsets of your users to third party marketing automation software
- Provide a specialized customer lookup application for the people in your company
This repository contains the source code for both the Open Source edition of Metabase, released under the AGPL, as well as the commercial edition of Metabase Enterprise, released under the Metabase Commercial Software License.
See LICENSE.txt for details.
Metabase Enterprise Cost
Unless otherwise noted, all files © 2021 Metabase, Inc.
Summary
Metabase offers an attractive looking visual SQL query building tool to serve ad hoc reporting and charting needs. InetSoft offers a completely customizable data visualization, analytics, dashboarding and reporting platform with a very strong data mashup and transformation engine.
Maturity of Code
InetSoft has 21 years of experience in business intelligence and reporting software development with sole control over source code. Metabase is a startup founded 3 years ago relying on the best efforts, open source model of code development.
Company Resources
InetSoft employee count is over 150. Metabase is under 10. InetSoft is profitable, self-funded, requiring no venture investment and control. Metabase is venture-backed with inherent uncertainty of future success or viability.
Production Reporting
InetSoft support pixel-perfect production reporting which covers the breadth of paginated reporting, burst generation, and automated distribution options. Metabase has no production or paginated reporting capabilities.
Dashboard Design
InetSoft's designer is a blank canvas for laying out any desired set of charts with precise control of all graphic elements. Metabase does not offer a designer, only a rudimentary method of saving and resizing charts to view again.
Visualization Interactivity
InetSoft supports many interactive data exploration controls to make one or more charts be filterable and explorable, such as range sliders, selection lists, calendar selectors, and brushing. Metabase supports none of these. Charts are single-purpose views that result from designing a specific question, which is a visual process of writing an SQL query. Limited filtering is possible only through a confined drop-down method.
Archiving Reports, Dashboard Snapshots, Alerts, Chart and Data Exporting
InetSoft supports these. Metabase does not.
Advanced Chart Types
InetSoft supports many advanced chart types and options that Metabase does not, such as bullet charts, sparklines, histograms, top-n/bottom-n, custom maps, and conditional coloring.
Data Connectivity
Metabase connects to a handful of SQL-based sources and one Hadoop type. InetSoft connects to all of those plus many specialized enterprise application and cloud sources, plus spreadsheets, even those imported by end-users.
Access and Permissions
Metabase only supports Google SSO and table-level access control. InetSoft supports many standard SSOs such as Active Directory and LDAP or custom ones and cell-level access control.
Data Mashup
Metabase does not support data mashup and connects only to a single source. InetSoft connects to as many sources as desired and enables mashing up of data even when field types aren't exactly matching. Complex join types are supported.
Data Transformation
Metabase only supports simple expressions. InetSoft supports the entire library of functions Excel does plus any custom function or algorithm.
Database Writeback
InetSoft supports this. Metabase does not.
Metabase Enterprise Development
Machine Learning
InetSoft supports machine learning via Spark. Metabase does not.
Embeddability, Multi-tenancy, API
InetSoft support a full range of embeddability from white-label OEM'ing with multi-tenancy and API access to displaying interactive visualizations in a portal. Metabase does not.
Metabase Source Code
Since 1996 InetSoft has been delivering easy, agile, and robust business intelligence software that makes it possible for organizations and solution providers of all sizes to deploy or embed full-featured business intelligence solutions. Application highlights include visually-compelling and interactive dashboards that ensure greater end-user adoption plus pixel-perfect report generation, scheduling, and bursting. InetSoft's patent pending Data Block™ technology enables productive reuse of queries and a unique capability for end-user defined data mashup.
Metabase Sso
This capability combined with efficient information access enabled by InetSoft's visual analysis technologies allows maximum self-service that benefits the average business user, the IT administrator, and the developer. InetSoft was rated #1 in Butler Analytics Business Analytics Yearbook, and InetSoft's BI solutions have been deployed at over 5,000 organizations worldwide, including 25% of Fortune 500 companies, spanning all types of industries.