1. Retrieve metadata
Metadata > SAP Connection > (Server) > right click and select Retrieve SAP BW metadata > Search in "InfoCube"
Search and check the line, wait the system to retrieve the metadata and click finish.
2. Copy the reference job is J024_BW_InfoCube_to_GCS
3. The components to change:
3.1 Component tSAPInfoCubeInput
Drag and drop the metadata table object to the new job and ensure that the schema, table name, filter, number of records are correct.
tSAPInfoCubeInput configuration
In case of a lot of records, it is required to use FTP-Batch option.
1.4. Click on the sync column to get the new schema on tLogRow if you want to see the output during the run of the job or delete this job
1.5 Add the context g_CNX_SAP_xxx on the server that need to be connected.
1.6 Enter the parameter context to connect to GCP
The rest of the job will extract the data from SAP and generate the file on the local folder, then upload it to the bucket that we enter in point 1.6