You can view the data extraction status from the SAP BW monitor in SAP BW. It shows green if the data extraction was successful and red if the data extraction failed.
The SAP BW monitor also shows the following information about the data extraction:
Number of packets sent
Number of rows in each packet
Time taken for sending the packet
Start time and end time
If the data extraction fails, you can start the InfoSpoke again to start the data extraction process. You can start the InfoSpoke again only after the Data Integration Service completes extracting data from the database table and sends the status to the SAP BW monitor.