1. Retrieve metadata
Metadata > SAP Connection > (Server) > right click and select Retrieve SAP BW metadata > Search in "DataStoreObject"
Search and check the line, wait the system to retrieve the metadata and click finish.
2. Copy the reference job is J023_BW_DSO_to_GCS
3. The components to change:
3.1 Component tSAPDSOInput
Drag and drop the metadata table object to the new job and ensure that the schema, table name, filter are correct.
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