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