Query SAP ECC Data using Database level vs. application level (Netweaver)

There are two ways to access SAP ECC Data for the purpose of validation. One is connecting to the application level, second is the database level. 

Refer to the below tables for the pros and cons of each approach:

Creating query chain to ingest data from SAP ECC using Database connection.

This example is for querying SAP ECC built on HANA database, the process is the same for any other databases. The objective of this sample query chain is to ingest all entries from DD03L table from SAP ECC, which has an approximate volume of 13 Million records.

1. Create a query chain using the following details:

2. Drag and drop the custom SQL option and input the SQL as follows

3. Configure the packet size as follows. The packet size and parallelism can be adjusted depending on the total number of records. When packet size is non-zero, the key fields (granularity of the query output) must be selected in the "Packetized By" field. If you don't select the correct set of key fields, there is a high possibility data will be duplicated. 

4. Connect to "RD Output". Execute the query chain. Depending on your server size, ingesting about 13M records with the above parallelism configuration would take around 3-4min to complete.