Data Integrator and SAP documentation

dataservices administration
1

hi experts,

i am a BODI ETL developer. i like to study SAP. how can i use SAP in BODI dataintegrator tools. please guide me.

is any ariticle available for this?. please reply me

thanks
R.saravanan :lol:

dataintegrator.net (BOB member since 2006-01-12)

2

Hello,

There is a Data Integrator SAP Supplement guide available in the document folder (in DI zip file or CD). This will cover in detail all the interactions between DI and SAP.

It is also available in the Technical Manual as the section “Supplement for SAP”

Nicolas

dataintegrator.net (BOB member since 2006-01-12)

3

First, get SAP GUI installed on your PC (where DI is running) and get a developer account for SAP.

Then, you create a datastore by copying the SAP logon information (host, system no, client, username, password). Don’t mind the other parameters, just set them to anything. As long as you are not executing flows, you don’t need that.

If the login and the permission inside SAP are correct you can import an SAP table, e.g. KNA1 (KundenAllgemein1 = Customer Common [attributes] 1). Or you open the entire datastore and click on “external data” in the newly openend workspace window. You can place table into data flows as with any other tables, but only for very small amounts of rows and columns, in most cases you will add a R/3 dataflow to the dataflow, and drag’n drop the SAP tables into this - so an ABAP is generated under the hoots.

regards

Werner

dataintegrator.net (BOB member since 2006-01-12)

4

Add the other critical file which you may need to add some .dll files in Windows, even with SAP GUI installed, and in UNIX back-end you definitely need library file(s). Extracted from ReadMeLibRfc.txt (BusinessObjects):

Installing Connection Libraries on Windows platforms

The SAP GUI application installs the library and makes it available
in the Windows system PATH. If you don’t have any version of LibRFC
on your system, install SAP GUI from the SAP R/3 “Presentation CD”.

This table lists the earliest version that Data Integrator supports.
If you are extracting data from an SAP R/3 instance of an earlier
version, you need to upgrade the connectivity library to a compatible
version. You need not upgrade SAP GUI, only the library.

Data Integrator Component Windows 2000, Windows XP, Windows 2003

Designer 4.0A
Job Server/Engine 4.0A
Access Server 4.0A*

Library Name LibRFC32.dll

  • Data Integrator Access Server requires SAP R/3 connectivity only if
    your Data Integrator application sends or receives IDocs.

Checking the version of librfc32.dll on Window

You can verify the version of your library by displaying the
Properties for the file, selecting the Version tab, then Product
Version. Look for the library as follows:

C:\winnt\system32\librfc32.dll Windows 2000
C:\WINDOWS\system32\librfc32.dll Windows XP
C:\winnt\system32\librfc32.dll Windows 2003

Obtaining a more recent compatible version of the library

To obtain and install the new library:

  1. Download the latest patch file (librfc.dll_16.car or later) from
    SAP support website.

  2. Uncompress the patch package.

  3. Copy librfc32.dll into the system directory.

  4. Register the DLL by running the following command:

     regsvr32 librfc32.dll

Stracy :us: (BOB member since 2006-07-14)