...
First we try to perform a sample ETL from a MySQL DB to another MySQL DB and Export it to Hive.
| Mockup |
|---|
| |
|---|
| Version | 13 |
|---|
| Name | Login - Source Database |
|---|
|
| Mockup |
|---|
| |
|---|
| Version | 12 |
|---|
| Name | Selecting DB |
|---|
|
| Mockup |
|---|
| |
|---|
| Version | 67 |
|---|
| Name | Select Database |
|---|
|
| Mockup |
|---|
| |
|---|
| Version | 34 |
|---|
| Name | Selecting Data - Null Select |
|---|
|
| Mockup |
|---|
| |
|---|
| Version | 78 |
|---|
| Name | Select Columns |
|---|
|
| Mockup |
|---|
| |
|---|
| Version | 12 |
|---|
| Name | Datawarehouse Login |
|---|
|
B. Second Stage Process -
I. After a ETL is performed, now for Second Stage we require two component
1. EDW
2. OpenMRS Predictive Analysis Module.
II. Performing Predictive Analysis - we can use Apache Mayhout for implementation.
...