SAP TABLE Provider

Let’s create a new pipeline and extract data to the Blob Storage:

  1. On the Data Factory Studio, click on the Pencil icon on the left, click the Dataset Ellipsis and select New Dataset monitoring1
  2. For the datastore, we will search for SAP and select SAP Table: monitoring1
  3. For the properties:
  • Name: SapTable1
  • Create a New under Linked Service monitoring1
  1. 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 monitoring1
  1. Select the newly created SapTable1 linked service, select Table MATDOC and click OK monitoring1

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)