DataFlux Data Management Studio 2.6: User Guide

SAP Remote Function Call Node

You can add an SAP Remote Function Call node to execute SAP Remote Function Calls (RFC) and Business Application Programming Interfaces (BAPI) in the context of a data job. This node enables you to:

• read information from SAP that is not readily available in tables
• use the functionality that SAP exposes as BAPIs
• load data to SAP by using SAP-provided functions that are a standard way of updating objects
• trigger an upload to SAP by using functions that take, for example, an external file input.

In order to use this node, you will need the following:

1. A DSN data connection that will provide access to an SAP system. For an example connection, see Adding Custom SAP Connections.
2. SAP libraries (DLLs) installed on all computers where the connection is used. For more information, see Error: "Unable to load extension: (tkesapf)" when connecting to an SAP System.
3. A personal login for this node since shared logins are not supported. For more information, see Does the SAP Remote Function Call node support shared logins?

After you have added the node, you can double-click it to open its properties dialog. The properties dialog includes the following fields and controls:

Name - Specifies a name for this node in the context of a data job.

Notes - Enables you to open the Notes dialog. You use the dialog to enter optional details or any other relevant information for the input.

Data source - Enables you to specify a DSN data connection that will provide access to an SAP system. For an example connection, see Adding Custom SAP Connections.

Refresh icon - Enables you to refresh the list of data sources.

Function - Specifies the SAP function to use in the job.

Search button - Opens the dialog to search for an SAP function. The DSN must be selected in order to search for functions.

Options button - Opens the dialog to set the commit interval and the grouping field name options.

Input Fields tab - Enables you to map input fields in the Available pane to parameters in the Parameters pane. The goal is to map an available field to a parameter which then displays in the Selected pane.

• Available - Specifies the names of the input fields of the data node. Parent nodes are the names of the input sources. Child nodes are the names of the input fields.
• Parameters - Specifies all of the input and table parameters of the selected RFC function. Parent nodes are the parameter names. Child nodes are the column names. For simple parameters without columns, the child node is the name of the parameter. Required parameters are marked by the table icon with a check mark.
• Add (+) or delete (-) arrows - Enables you to add or delete selected input fields mapped to parameters.
• Selected - Specifies the selected input field and parameter mapping.

Output Fields tab - Shows the available output parameters and tables of the SAP function. The user can select from the list of parameters which parameters should be used as output of the call.

• Available - Displays the available output parameters and tables of the SAP function..
• Add (+) or delete (-) arrows - Enables you to add or delete selected parameters mapped to output fields.
• Selected - Specifies the name of the output field and an editable output name.
• Up or down arrows - Enables you to move the selected object up or down in the Selected grid.