SAP TABLE Provider
Let’s create a new pipeline and extract data to the Blob Storage:
- On the Data Factory Studio, click on the Pencil icon on the left, click the Dataset Ellipsis and select New Dataset
- For the datastore, we will search for SAP and select SAP Table:
- For the properties:
- Name: SapTable1
- Create a New under Linked Service
- Fill the required data for the linked service:
- Name: SapTable1
- Integration Runtime: SAPIntegrationRuntime
- Server Name: «HANA IP»
- System Number: 00
- Client Id: 100
- Username: BPINST
- Password: Welcome1
- Click on Test connection and if successful, click on Apply
- Select the newly created SapTable1 linked service, select Table MATDOC and click OK
We are now communicating with SAP via Netweaver.
Jump to STEP 4 on this LAB: Extracting data (this is based on the values provided on the Step 3, but pipeline source data can be changed to match what the dataset we just set up)