We have a requirement to develop an application that pulls the data from SAP BW system and display it on a Flex chart.
The Flex guy wants the data in the XML format. I am the middleWare guy who sits in between the SAP BW and the Flex. I need to pull the data from SAP BW system and feed the Flex components in XML.
Question: How do I pull the data from SAP BW system, process it and convert to XML?
Initial thoughts:
- The SAP BW system generates a CSV file. Process that CSV file and generate the XML. Basically I am a Java guy, so I am thinking it as a JAVA WEB-SERVICE.
Any other thoughts, better approaches, please?
Thank You :)