Page Comparison

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

Image Modified

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

Image Modified

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.

...

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.

Image Added

Download Excel Sheet, Csv, Tsv

You can download result in three format XLS (Excel Sheet), CSV (Comma Separated) and TSV (tab Separated).

Image Added

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”.

Image Added