• +1 510-870-8668, 510-298-5936, 510-796-2400
  • Login

Metabase

Metabasethe classiest, simplest and fastest way to provide business intelligence and analytics to each person working in the company. Pushing data is one of the things in which it has achieved a great level. It is written in Clojure and offers multiple options such as Mac application, Docker image, cloud images and a jar file which are designed specifically for particular use cases.

 

Miri Infotech is launching a product which will configure Metabase to a wide variety of statistical (linear and nonlinear modelling, classical statistical tests, time-series analysis, classification, clustering) and graphical techniques which is embedded pre-configured tool with Ubuntu 16.04 and ready-to-launch AMI on Amazon EC2 that contains Hadoop, Hbase and SQL interface.

MetabaseThe classiest, simplest and fastest way to provide business intelligence and analytics to each person working in the company. Pushing data is one of the things in which it has achieved a great level. It is written in Clojure and offers multiple options such as Mac application, Docker image, cloud images and a jar file which are designed specifically for particular use cases.

 

Now, while going through the information, the most important question arises is that why we choose metabase?

And to answer this is that, we should understand a concept of Pulses! It’s a feature in metabase that gives you the ability to automatically send regular updates without any intervention to your teammates to keep a full track on the changes that are done to the metrics which matters you the most.

The Metabase application has two basic components

1. A backend written in Clojure which contains a REST API as well as all the relevant code for talking to databases and processing queries.

2. A frontend written as a JavaScript single-page application which provides the web UI.

Supported Databases

  • Postgres
  • MySQL
  • Druid
  • SQL Server
  • Redshift
  • MongoDB
  • Google BigQuery
  • SQLite
  • H2
  • CrateDB
  • Oracle
  • Vertica
  • Presto
Metabase live cast:
 

You can subscribe to Metabase, an AWS Marketplace product and launch an instance from the Metabase product's AMI using the Amazon EC2 launch wizard.

  • To launch an instance from the AWS Marketplace using the launch wizard
  • Open the Amazon EC2 console at https://console.aws.amazon.com/ec2/.
  • From the Amazon EC2 dashboard, choose Launch Instance.
  • On the Choose an Amazon Machine Image (AMI) page, choose the AWS Marketplace category on the left. Find a suitable AMI by browsing the categories, or using the search functionality. Choose Select to choose your product.
  • A dialog displays an overview of the product you've selected. You can view the pricing information, as well as any other information that the vendor has provided. When you're ready, choose Continue.
  • On the Choose an Instance Type page, select the hardware configuration and size of the instance to launch. When you're done, choose Next: Configure Instance Details.
  • On the next pages of the wizard, you can configure your instance, add storage, and add tags. For more information about the different options you can configure, see Launching an Instance. Choose Next until you reach the Configure Security Group page.
  • The wizard creates a new security group according to the vendor's specifications for the product. The security group may include rules that allow all IP addresses (0.0.0.0/0) access on SSH (port 22) on Linux or RDP (port 3389) on Windows. We recommend that you adjust these rules to allow only a specific address or range of addresses to access your instance over those ports.
  • When you are ready, choose Review and Launch.
  • On the Review Instance Launch page, check the details of the AMI from which you're about to launch the instance, as well as the other configuration details you set up in the wizard. When you're ready, choose Launch to select or create a key pair, and launch your instance.
  • Depending on the product you've subscribed to, the instance may take a few minutes or more to launch. You are first subscribed to the product before your instance can launch. If there are any problems with your credit card details, you will be asked to update your account details. When the launch confirmation page displays

About

Metabase is the easy way for everyone in the company to learn from data and ask questions. When you need to dig into some complicated stuff, metabase provides you with an elegant and flexible SQL interface. It helps you get a real time glimpse in what your company is learning about your data.

Guidelines

It is basically a business tool. It’s the go-to-guide on asking questions and sharing answers using metabase. A deep learning about how to express questions, chart answers in whichever way and create dashboards.

Limitations

Before discussing the limitations of using metabase, it is important to learn one concept which helps in understanding its limitations more easily.

SSH Tunneling in Metabase

Metabase has the ability to connect to some databases by first establishing a connection to a server in between Metabase and a data warehouse, then connect to the data warehouse using that connection as a bridge. This makes connecting to some data warehouses possible in situations that would otherwise prevent the use of Metabase.

While using an ssh tunnel makes it possible to use a data warehouse that is otherwise not accessible, it is almost always preferable to use a direct connection when possible:

There are several inherent limitations to connecting through a tunnel:

  • If the enclosing SSH connection is closed, because you have put your computer to sleep or changed networks, all established connections will be closed as well. This can cause delays in resuming connections after suspending your laptop
  • It's almost always slower. The connection has to go through an additional computer.
  • Opening new connections takes longer. SSH connections are slower to establish then direct connections.
  • Multiple operations over the same SSH tunnel can block each other. This can increase latency in some cases.
  • The number of connections through a bastion host is often limited by organizational policy.
  • Some organizations have IT security policies, forbidding using SSH tunnels to bypass security perimeters.

 

Usage / Deployment Instruction

Step 1: Open Putty for SSH

Step 2: Open Putty and Type <instance public IP> at “Host Name” Type "ubuntu" as user name Password auto taken from PPK file.

Step 3 : Use following Linux command to start Metabase

Step 3.1 : $ sudo vi /etc/hosts

Take the Private Ip address from your machine as per the below screenshot and then replace the second line of your command screen with that Private ip address

Step 3.2: Change ssh ‘ubuntu’ user to ‘root’

>> sudo su

Step 3.3: First remove ‘metabase’

>> docker rm metabase

Step 3.4: Start metabase with docker

>>  docker run -d -p 3000:3000 --name metabase metabase/metabase

Step 3.5: Now Metabase start in Browser.

Open the URL:  http://<instance ip address>:3000

Example: http://54.165.94.231:3000

Step 4: Register with Application

First Name : <Any Name>

Last Name: <Any Name>

Email Address: <Your Email Address>

Create a password: <InstanceID>

Confirm password: <InstanceID>

Your company or team name: <Team name>

Note: Email address is mandatory but storing data in your running application email address not to send anywhere else.

Step 4.1: Select database.

Step 4.2: Installation Complete

 

 
Live Demo

Our Rating

5 star
0
4 star
0
3 star
0
2 star
0
1 star
0

Submit Your Request

First Name:*
Last Name:*
Company/Organisation:*
Email Address:*
Phone Number:*
Message:*