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.
...
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 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.
After Completion of loading this kind of page will appear.
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.
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.
...