Technical documentation for the Bollate ELN data load and integration.
Summary
Sum-up
| Data Sources | ELN, Spreadsheets | ||
| Mapping spreadsheet | |||
| Talend job | Query SQL | BigQuery Target Tables | |
|---|---|---|---|
| Data Load | |||
| Integration | |||
| Presentation | |||
ELN Mapping
ELN Data Model
https://app.diagrams.net/#G1sD6OqKnBzSR_SrGvzlhEl7s5F5vUGQqD
Macro Schema
Data Sources
| Source | Description | Data Status | Flow Status |
|---|---|---|---|
ELN EWHA BOLLATE (ELN current spreadsheet) | This is a standard ELN spreadsheet for Ewha and Bollate | HOT | ACTIVE |
ELN BOLLATE (ELN historic spreadsheet) | This is a ancient format for ELN spreadsheet. The data is still necessary but it's been | COLD | DISABLED |
ELN Battery mapping | This is a spreadsheet has many necessary sheets. It's used mainly for mapping data between the historic spreadsheet and the new one | COLD | ONE SHOT |
| ELN MuSigma (pré-ELN) | Before the ELN spreadsheets specific for battery, the enterprise MuSigma created some process to recover some ELN data | COLD | DISABLED |
| ELN Separator data Mapping | ? | ? |
Data Load and Integration
| N | Description |
|---|---|
| A1 | |
| A2 | |
A3 | |
| A4 | |
| A5 | |
| A6 | |
| B1 | |
| B2 | |
| B3 | |
| B4 | |
| C1 | |
| D1 |