This page is in development, and focuses on Oracle connections & organization for JIRA-based views & tables.
Further information on these and other Atlassian applications can be found here: Genomics Platform Atlassian Applications
...
| SCHEMA& USERNAME | DESCRIPTION | WHEN TO USE IT | NOTES |
|---|---|---|---|
| REPORTING | This is where to write view synonyms that point to JIRADWH views. This can also be where view code drafts get written before being transferred to JIRADWH. | For all report-related read access, or when creating a view in REPORTING schema | |
| JIRADWH | Home of actual DWH views. Home of ETL packages & functions that work on multiple JIRA schemas' data. This is where to write DWH code. | Only when creating views or tables in JIRADWH schema | |
| LABOPSJIRA_5 | Home of the labopsjira data that the DWH looks at. | Rarely | |
| PRODINFOJIRA_5 | Home of the labopsjira data that the DWH looks at. | Rarely | |
| GPDEVJIRA | This is the "LABOPSJIRADEV" clone of labopsjira_5, which is refreshed on demand. | During testing | |
| PRODINFOJIRA5_TEST | This is the "GPDEVJIRA" server test clone which can be anything, depending on current testing needs. | During testing |
...
More info for analytics users can be found here: JIRA DB Schemas
Datamart structure
ETL
|
Nasko built ETL functions to simplify view creation, standardize SQL structure, and provide scalability and schema flexibility. These functions are generic, allowing you to plug in whatever specifiers you need. Use ETL functions to specify schemas, projects, and custom fields. When querying JIRA data, most of the functions you'll need live in JIRADWH/Packages/ETL/Entries
More info here: Jira DWH
|!
!|
Nasko built ETL functions to simplify view creation, standardize SQL structure, and provide scalability and schema flexibility. These functions are generic, allowing you to plug in whatever specifiers you need. Use ETL functions to specify schemas, projects, and custom fields. When querying JIRA data, most of the functions you'll need live in JIRADWH/Packages/ETL/Entries
...