by

Metabase Oracle



Metabase Enterprise Edition lets you quickly and easily embed interactive reports in your app, with simple tools to let you match the look and feel to your brand. Learn more about Embedded Analytics See how it all fits together Reporting for your customers in under 10 minutes. Oracle MetaBase (OMB) is an extension of the Tcl language (pronounced 'tickle') and it has all of the robust features of any programming language, including complex Boolean operators, variable support, and loops (FOR, WHILE, REPEAT-UNTIL). Metabase, an open-source BI tool, offers easy way to generate both charts and dashboards, see in-depth information about rows in your database and ask simple ad hoc queries without having to use SQL. Metabase installs in just a couple of minutes and can work with a variety of databases, such as MySQL, Amazon Redshift and PostgreSQL. Use Oracle MetaBase - OMB is a extension of the Tcl language (pronounced 'tickle') and it has all of the robust features of any programming language, including complex Boolean operators, variable support, and loops (FOR, WHILE, REPEAT-UNTIL). Metabase is a free and open source GUI-based query tool. It integrates with almost all types of databases and provides a very simple GUI to run queries on the database. Metabase lets you easily filter and group the data to find something without writing the SQL query. The application lets you visualize the data into beautiful charts and graphs.

Metabase Oracle

Contents

Overview

Metabase is a kind of Business Intelligence tool and Open Source Software itself. Here it shows how to install Metabase on windows with OpenJDK.

Metabase Add Oracle Database

Environments

Oracle

OS : Windows10
JDK : OpenJDK 13.0.2
Metabase : version 0.33.4

Step1 : Installation of JDK

According to Metabase website、Metabase works with OpenJDK or OracleJDK. This example uses OpenJDK13 from following URL.

After downloding OpenJDK13 zip file, decompress and put it in the any folder. This is a example path to java.exe in case you make the metabace folder at c: .

C:metabaseopenjdk-13.0.2_windows-x64_binjdk-13.0.2binjava.exe

Step2 : Downloading Metabase

You can get metabase.jar file from following URL.

Put it at any folder like c:metabase if you made it.

Step3 : Installation of Metabase

Execute following command at command prompt.

Metabase Oracle

If you put JDK and metabase.jar at any other folder please change path in the command example.

After installation , you can find following a folder and files.

  • plugins #folder
  • metabase.db.mv.db
  • metabase.db.trace.db

Step4 : Access to Metabase

Metabase Oracle Tns

Support

Please don’t close command prompt which executing metabase and open chrome or any other browser.

You can access metabase site with http://localhost:3000 and make administrator account following the guidance.

If you would like to use metabase anytime, it’s good to make bat file containing following commands and put it startup.

Oracle.metabase-driver.jar

Summary

Metabase Oracle

It’s so easier to install metabase on windwos than any other BI tools. Please try it.