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