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

[Former Member]

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

[ravi_raman2]

You can do this using sap PI talking to IBM workflow engine sending data back to SAP BW.

Let me know if you need more details..

Regards

Ravi Raman

[Former Member]

Hello,

sorry for late reply.

During our negotation with IBM BPM team we were switching from WebService-Interface to a DB2-DBConnect-Interface.

On IBM side the major issue was the extraction out of IBM Alphablox. After solving this issue we commited ourself to generic format (valuepair-based) which will be extracted into BW. In the ETL process we transform this generic format

to reporting friendly data model.

All the best,

Guido