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.

...

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.

Image Added

You have to fill up the following:-

...

SSH Password: - Password for your SSH Remote Login.

Loading

Wait for Loading to completed it tooks several minutes. So you have to be patient at this time. You can skip the page any time but the process will remain continue until loading is completed.

Image Added

After Completion of loading this kind of page will appear.

Image Added

Hive Login

You can reach this page three way. At admin page click "Datawarehouse Login". Second In "ETL Process" MySQL Login you can skip to "Hive Login" by bottom left corner link. Third is after completion of successful loading you can skip to it.

Image Added

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.

Image Added

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