Welcome Guest! Log in


This article is a abstract of Stambia SAP connector. It will present you all global features but will not go into details.

To get more information, please refers to : Stambia DI for SAP

Features

Stambia SAP connector can reverse 4 kinds of metadata :

  1. Table: a classic database table, similar to SQL table
  2. IDoc: an document format, similar to XML
  3. BAPI/RFC: a service that can be used by external system, similar to PL/SQL procedure or WebService
  4. DataSource: a read-only structured data, used for BI or customer reports

Setup

SAP server

To be able to connect Stambia to SAP, we first need to parametrize the SAP server:

  • All Stambia custom ABAP is in the dedicated ZSTB_PACKAGE package and ZSTB_FUNCTION_GROUP function group
  • For each kind of metadata, there a dedicated setup :
    • To query a table, use ZSTB_RFC_READ_QUERY
    • To query a DataSource, use ZSTB_RFC_READ_DATA_SOURCE
    • To manipulate IDoc, there is no RFC but network must be configured
    • to call a BAPI/RFC, just ensured it is remote enable

Stambia Designer

Once SAP server is up-to-date, we can work on Stambia designer :

  • In both your "c:/windows/system32" and "[DESIGNER_INTALLATION_FOLDER]\stambiaRuntime\lib\addons\sap" directories, copy/past SAP JCO libraries
    Be aware those file are provided by SAP, not by Stambia.
  • In your "[DESIGNER_INTALLATION_FOLDER]\dropins\plugins" directory, copy/past the Stambia connector
  • In your Stambia Designer, add SAP template in your templates project

Usage

SAP can be used for mapping like any other technology. Here are some tips.

Reverse

Choose the kind of objects you want to reverse :

SAP reverse

BAPI/RFC

Input data are in the "ImportParameters" node and output in the "ExportParameters" one.

"Tables" node is available for both input or output.

SAP BAPI RFC

Tables

SAP tables are not different than SQL ones

SAP tables

IDocs

SAP IDocs can be handle like XML file (even for writing).

SAP IDocs

DataSource

Read only strutured data, but a delta mode is available to only load updated information:

First initialize a load with Mode=C. It will make a full load and reset counters.


SAP DataSource init

 

Then, run a delta load with Mode=D. It will only get new data.


SAP DataSource delta

 

You have no rights to post comments

Articles

Suggest a new Article!