Skip to Content
0
Former Member
Oct 29, 2009 at 10:50 AM

How to feed SAP BW with KPI data from IBM Workflow engine?

46 Views

Hello,

in my current project we want to feed SAP's data warehouse BW with KPI data from

IBM's workflow engine.

I found the following redbook "BPM meets Business Intelligence":

http://www.redbooks.ibm.com/abstracts/SG246340.html?Open

This document describes the integration of an workflow KPI's into a common data warehouse

based on web services.

SAP BW is in general supporting in this context the following interface types:

+ WebService

+ CSV-File.

For WebService to BW we expect the data in the following XML-format:

<?xml version="1.0" encoding="utf-8"?>

<ns1:DataToBW

xmlns:ns1="http://customer.com/XI/BW"

xmlns:xsi="http://www.w3.org/2001/XMLSchemainstance">

<DATA>

<item>

<CALDAY>1999-01-24</CALDAY>

<MATERIAL>4711</MATERIAL>

<AMOUNT>260</AMOUNT>

<CURRENCY>EUR</CURRENCY>

</item>

<item>

<CALDAY>1999-01-24</CALDAY>

<MATERIAL>4712</MATERIAL>

<AMOUNT>100</AMOUNT>

<CURRENCY>EUR</CURRENCY>

</item>

</DATA>

</ns1:DataToBW>

Are there are pratical experience and advises out there how to design the interface between IBM's workflow engine/BAM and SAP BW?

Regards & Thanks,

Guido Brune

Germany