Prerequisite
Talend Job
1. Copy the job J028_BW_Query_csv_to_GCS to the new job
2. Edit the context variable on
| Variable | Meaning |
|---|---|
| l_VAR_XTRACT_JOB | The job name of the Xtract |
| l_VAR_XTRACT_FOLDER | The output folder of the Xtract |
| l_VAR_FOLDER | The local folder to save to Talend server |
| l_VAR_FILE | The local file to save to Talend server |
3. The job should upload the output to the GCS as we configure in the context
In case the query has variable, the URL will required to have parameter, it may required to modify it.
For example,
Xtract will generate URL like this:
http://ACEW1DXTRAXUS01:8085/?name=DEV_DE_BW_QRY_MVCOPP01_0021&Fiscper=
we can create another variable for the filter parameter