Technical Overview of Data Extraction

Activate SAP Traces and Logging to monitor what happens during data extraction.

Understanding the technical aspects of data extraction is crucial for users of zapAudit and zapCash. This knowledgebase article provides insights into the technical process during data extraction, emphasizing the use of SAP Java Connector (SAP JCo) and relevant SAP transactions for monitoring.

Technical Steps During Data Extraction:

1. SAP Java Connector (SAP JCo):

  • The software utilizes the SAP Java Connector (SAP JCo) to establish a connection with the SAP system. SAP JCo is a middleware component that facilitates the development of SAP-compatible components and applications in Java. It supports bidirectional communication with the SAP Server, enabling seamless data transfer between Java and ABAP (Advanced Business Application Programming). SAP JCo can be implemented with Desktop applications and with Web server applications. -- SAP Help

2. RFC (Remote Function Call):

  • SAP JCo uses the SAP Remote Function Call (RFC) to extract data from the SAP system to the local instance of zapAudit or zapCash. RFC allows for communication between different systems, and in this context, it facilitates the transfer of data from SAP to the software. The SAP user account used for this process requires specific READ permissions.

3. SAP User Traces:

  • To monitor the activities of SAP users during data extraction, you can use the SAP transaction 'STAD' (Statistical Data for SAP Users). This transaction provides insights into user activities, helping administrators track the execution of remote function calls.
    transactionSTAD

4. SAP User Traces Configuration:

  • Transaction 'SM19' can be used to configure SAP user traces. SAP administrators or users can consult their SAP admin or the SAP Help Portal for guidance on setting up and configuring user traces. This step is essential for monitoring and ensuring the security of data extraction activities.

5. Data Backup and Compression:

  • After a successful data extraction, a backup of the extracted data is created and packed into a zip file. This "raw" data is stored in the project folder within the installation directory or workspace. This backup serves as a valuable resource, allowing users to repeat data processing without initiating a new extraction.

6. External Data Source for Project Creation:

  • Users can select the raw data zip file generated during extraction as an "External data source" while creating a project. This ensures that the extracted data is used for subsequent analysis and processing within the software.

 

Understanding the technical steps involved in data extraction with zapAudit and zapCash provides users with insights into the secure and controlled transfer of data from SAP systems. Leveraging SAP Java Connector and Remote Function Call, combined with monitoring through SAP user traces, ensures a robust and transparent data extraction process.

 

For additional technical assistance or specific inquiries related to your SAP environment, it is recommended to consult zapliance or refer to the official documentation.