- connect to "analytics" server using your favorite SSH tool
- enter EtlShell /home/unix/analytics/TigerETL3/runEtlShell.sh
- run etl-commands as you see fit
ETL Tasks
| TASK description | COMMAND |
|---|---|
Manually push into GitHub by providing CSV-list of dbObjects and optional commit message. Note that dbObjects are specified by (dbname.schema.objectname) triplets where dbname is: seqprod, labopsjira or bsp If no explicit commit-message is provided then built-into-your-code comments would be picked
/* GITHUBCOMMENT: RPT-1234 */ | analytics.tiger.agents.OracleVCS.main(Array("labopsjira.REPORTING.ZZZAB_METADATA_TRANSITIONS,seqprod.COGNOS.ACTIVE_LAB", "Monads are great")) |
| blacklist runfolder from RunMercury/RghqsLoader agents | CognosDB("RunfolderAPI.blacklist", RunfolderAPI.blacklistRun("runfolder1,runfolder2")) |
| whitelist runfolder from RunMercury/RghqsLoader agents | CognosDB("RunfolderAPI.whitelist", RunfolderAPI.whitelistRun("runfolder1,runfolder2")) |
| Manual Refresh in PDO Star5 using a query | AnalyticsEtlDB("analytics.tiger.agents.PdoStar.fromSQL", deltaFromSql("""SELECT DISTINCT a.pdo_name||','||a.pdo_sample_id FROM cognos.pdo_star5 a WHERE a.pdo_name = 'PDO-14680'""") flatMap DataSetEtl() flatMap analytics.tiger.agents.PdoStar.pipeline) |
| Manual Refresh of Picard Aggregations for a list of samples | CognosDB(" analytics.tiger.agents.PicardAggregator.Manual", deltaETL(Set("ALCH-ABSQ-TTP1-A-12-0-D-A489-36","ALCH-ABSQ-NB1-A-1-0-D-A489-36")) flatMap DataSetEtl() flatMap analytics.tiger.agents.PicardAggregator.Regular.pipeline) |