Documentation
...
- Download the omod file from here.
- Now go to the Administrator Page and then Click on Manage Module.
- Then Click on the Add or Upgrade Module button , after that a popup will appear , click the browse button then select the omod file that you downloaded and then click on upload button.
- After this wait for some until the message "Module loaded and started successfully" comes.
- After this you will see following section added to the admin page which means ETL Module is installed :
Getting Started
MySQL credentials
You have to fill up the following:-
...
MySQL Password: - Password for your MySQL database is present in openmrs runtime properties file. At the same folder from where you launch the openmrs standalone jar file.
Select Database
Select one database by clicking on it or you can choose multiple database at a time. By choosing, next page will load all the tables present in selected database.
...
At bottom left corner of the page, you will find a drop down contains chart type. Chart type are line, area, column, spline and pie charts. This are different mode of graphical view available. Choose any one and click “Graphs & Charts”.
Overview
This module provide's a mechanism for performing ETL. Extract transform and loading is done between the MySQL database which is using by the OpenMRS application and the datawarehouse. Datawarehouse is here HIVE/Hadoop where we are loading the extracted data. Feature accomplished with this module latest release is:-
- Select data from various table and database and as many columns you can.
- Drag and Drop UI for ease of column selection.
- Login to Datawarehouse and execute queries over it.
- Graphical Statistics and Charts.
- Save queries instantly and load it later whenever you want.
- Downloading Queries in different format like Excel Sheets, CSV, and TSV.
- Sleek and Interactive UI.
Prerequisite
- OpenMRS version 1.8.2+
- No special dependency module required.
Browser Compatibility
- Google Chrome 18 +
- Firefox 3.5 +
- Internet Explorer 9 +
- Opera
- Safari
Datawarehouse Prerequisite
- Hadoop
- Hive
- Sqoop
- SSH
Quick Start Guide
...
.
...
...
Installing the module
- Download the omod file from here.
- Now go to the Administrator Page and then Click on Manage Module.
- Then Click on the Add or Upgrade Module button , after that a popup will appear , click the browse button then select the omod file that you downloaded and then click on upload button.
- After this wait for some until the message "Module loaded and started successfully" comes.
- After this you will see following section added to the admin page which means ETL Module is installed :
Getting Started
- MySQL credentials
You have to fill up the following:-
MySQL Hostname: - The host over which MySQL database is running. It may be a Host name or Host IP address.
MySQL Port: - The port of the host over which MySQL database is running.
MySQL Username: - Username to login into your MySQL database. For OpenMRS by default it is “openmrs”.
MySQL Password: - Password for your MySQL database is present in openmrs runtime properties file. At the same folder from where you launch the openmrs standalone jar file.
- Select Database
Select one database by clicking on it or you can choose multiple database at a time. By choosing, next page will load all the tables present in selected database.
- Select Tables
Select one table by clicking on it or you can choose multiple table at a time. By choosing, next page will load all the columns present in selected tables.
- Select Columns
Select columns by drag drop them from left hand side to right hand side of the web page. By choosing, next page will load the JOIN condition page if it is require one join condition or multiple join condition should provide otherwise skip it by clicking next.
- Datawarehouse Login
This is the credential configuration page for datawarehouse. Which decide destination of where you want to load the extracted data. This requires ssh credentials of the remote machine.
You have to fill up the following:-
SSH Hostname: - The host over which Hive/Hadoop is running. It may be a Host name or Host IP address.
SSH Port: - The port of the host over which Hive/Hadoop is running. By default it is 22.
SSH Username: - Username to login into your SSH Remote Login.
SSH Password: - Password for your SSH Remote Login.
- Hive Login
- Create Queries
Create simple, complex or multiline HIVE queries using HiveQL, a SQL-Like language. You should know this language to run such queries over Hive.
- Execute Queries
Click on Execute Queries will bring a new page loaded with table of resulted query. If you don’t want to load you can click on Execute and download queries. This will download a Tsv file for you of resultant query.
- Download Excel Sheet, Csv, Tsv
You can download result in three format XLS (Excel Sheet), CSV (Comma Separated) and TSV (tab Separated).
- Tables, Graphs and Statistics
At bottom left corner of the page, you will find a drop down contains chart type. Chart type are line, area, column, spline and pie charts. This are different mode of graphical view available. Choose any one and click “Graphs & Charts”.
Downloads
...
Downloads
https://modules.openmrs.org/#/show/modules/view.jsp?module=...165/etl-module
Screenshots
Release Notes
...