sapDS

Using the sapDS Data Source

Purpose

This Data Source leverages the SAP RFC by querying a SAP Table.

Please note that this Data Source is readonly (only for extractors)

Pre-requisites

The RFC SDK (NWRFCSDK) must be installed as well as the pyrfc package must be deployed. The needed libraries can be downloaded on the SAP web site or here

pipelite configuration

The specific configuration (as a Datasource) in the configuration file section parameters includes the following parameters:

• ashost Host
• client SAP Cllient
• sysnr System Number
• user User
• passwd Password
• saprouter SAP Router (optional)
• rfctable RFC Table Name
• rfcfields List of fields to gather (separated by a comma
• rowlimit Row Count limit (Nb Max of rows retreived from SAP)

Configuration example:

    "classname" : "pipelite.pipelines.sequentialPL",
    "extractors" : [ {
        "id": "S1",
        "classname": "pipelite.datasources.odbcDS",
        "parameters": {
            "ashost": "<SAP Server>",
            "client": "000",
            "sysnr": "00",
            "user": "[...]",
            "passwd": "[...]",
            "saprouter": "[...]",
            "rfctable": "<RFC Table Name>",
            "rfcfields": ["MANDT","AUFNR","AUART","REFNR","ERNAM","AENAM"],
            "rowlimit": "200"
        } 
    ... ] ...