10. Bulk Query All

This document describes how to create an inbound interface using SKYVVA Bulk Query All mode in SAP PI/PO with a new SKYVVA V3 connector module.

What Is Bulk Query All

Bulk Query All - It will retrieve all archived and deleted records along with the existing records. The SKYVVA search will internally work on your query and will provide the complete result from your query. You can use the same Search operation to use it for Bulk v3 Query, which will help you to retrieve a huge volume of records in CSV format. You can configure in your Interface with operation type as "Bulk Query“ or "Bulk Query All“ to use the Bulk v3 Query feature.  Then you need to configure your SQOL in PI/PO Channel parameters or in SAP PI/PO mapping or in the SKYVVA interface. Base on your configuration in Interface SkYVVA connector will automatically detect the operation type and work accordingly with the same Search operation.

How Bulk Query works

• Create an inbound interface.
• Select the Operation type as Bulk Query All". As shown below.

• maximum integrate Batch size will be 5000

• In this example, we are going to put the SQL statement in the SAP PO Mapping.
• Now save the interface and download the WSDL from the Lightening mode.
• For new V3 we are going to use the new way WSDL.
• Generating the WSDL from Lightening as shown below.
• Go to Integration in that user have to select the "Generate Metadata"

• Provide all the required details and click on export to generate the file.

• Now click on View to download the generated WSDL file.
• In this example, we are going to use only one interface for both request and response.

1. Import WSDL into ESR

Test the Inbound Interface.

• Triggering the data from the Source system.
• Here is the result from Salesforce.

• This picture shows the same record in response, which is in the Recycle bin.