Discovering Schema and Creating a Mapping File for the SAP RFC Adapter

Use the Schema Discovery button in the Visual editor to discover function, table, or query schema and create a mapping file for the RFC adapter.

Prerequisites
Add the SAP RFC adapter to the diagram.
Task
In the Authoring perspective:
  1. Configure the RFC Input or Output adapter for schema discovery. In the adapter shape, click Edit Properties adapter_in and set these properties:
    • Adapter Configuration File
    • Adapter Mapping File
    • SAP Host
    • SAP System Number
    • SAP Client
    • Username
    • Password
    Ensure there are no checkboxes selected, and click OK.
  2. Click Schema Discovery find.gif on the adapter toolbar.
    • If the schema is successfully discovered, a dialog appears where you can view and select schemas.
    • If the schema is not successfully discovered, an error message appears stating that no schema was discovered for the adapter. Check that the adapter properties are configured for schema discovery and that no checkboxes are selected in the Edit adapter properties dialog.
  3. In the schema discovery dialog:
    • (RFC Input adapter only) Select which remote schemas to search: Functions, Tables, or Queries. Scroll through to view the discovered functions, tables, or queries.
    • (RFC Output adapter only) Scroll through to view the discovered schemas. Only function schemas display.
  4. Select a function, table, or query and click Select Schema.
  5. Click Next.
  6. In the Create Element dialog, select an option:
    • Assign schema to the connecting stream/window - this populates the stream or window to which the adapter is attached with the selected adapter schema.
    • Create new named schema - this creates a new named schema in ESP which is made up of the RFC schema elements.
  7. Click Next.
  8. From the left hand side column, select the remote fields for your schema and click Select Field(s).
    These fields now appear under the Selected Mapping fields column. To remove any fields from this column, select the field and click Select Field(s) again.
  9. Click Finish.
    • The mapping file you specified in the Adapter Mapping File property is populated with mappings based on the schema you selected.
    • Either the window or stream that is attached to the adapter is populated with the schema you selected or a new named schema is created in the project to which the adapter is attached.
Next