1. Retrieve metadata
Metadata > SAP Connection > (Server) > right click and select Retrieve SAP BW metadata > Search in "AdvanceDataStoreObject"
Search and check the line, wait the system to retrieve the metadata and click finish.
2. Copy the reference job is J025_BW_ADSO_to_GCS
3. The components to change tSAPADSOInput
Drag and drop the metadata table object to the new job and ensure that the schema, table name, filter, number of records are correct.
Configuration
3.1 Filter the data
3.2 Setup delta load with the subscriber name (delta) or select on full extraction
- With full flag = Full load
- Without full flag = Init with delta load (by subscriber name)
- Reset subscriber = re-init with data
- There is no selection delta basing on the filter but only by subscriber name
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
5 Add the context g_CNX_SAP_xxx on the server that need to be connected.
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
Appendix
How the Delta work (Subscription)
After running the job, it will create a job in BW
If run again with the same subscriber name, there will be no data and the log in BW will say no new request
If selection wrong in case of enter plant in correct
In case it is OK
