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 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.
Select type of join, table from the auto created dropdown. Add your ON Condition. It is must require. Then add any clause if you want. After completing this procedure click "Add Condition". This will append the JOIN Condition list made by you which is initially null. You can view the auto generated JOIN Condition Statement by clicking "Show Condition". In case you have your own complex JOIN condition which doesn't fit in this dropdown criteria, you can make your raw sql join condition using "Raw SQL JOIN Condition" text box.
Datawarehouse Login
...