schmittv has asked for the wisdom of the Perl Monks concerning the following question:

Hi all,

here's the scenario:

I need to fetch data from a cube of a remote SAP NetWeaver 7. The data will later be used in a web application based on Linux and Perl/PHP. (I'd prefer using perl for the backend and doing the business logic of the web application.)

I have:

- A Linux system with all its on-board tools and scripting languages.

- A user for the SAP BW which allows me to logon (very,very limited user rights, no se37,no se80,no rsaX and so on)

- Access to http://<SAP BW Server>:<Port>/sap/bw/xml/soap/xmla with the above mentioned user.

My questions:

- Could you please push me into the right direction how I can realize this? E.g. by pointing to tutorials / HowTos / sample code / CPAN modules etc.. (Most information I found so far referred to software based on a different operating system and on remote function calls using custom functions in SAP to be called via RFC.)

- I'm aware of the SAPNW::RFC CPAN module, but do I necessarily have to perform a remote function call? ( If so, is there a "standard" function I could call for accessing a cube?)

Thanks a lot in advance!

  • Comment on How to fetch data from a SAP BW Cube via Perl/PHP on a Linux machine?

Replies are listed 'Best First'.
Re: How to fetch data from a SAP BW Cube via Perl/PHP on a Linux machine?
by talexb (Chancellor) on Sep 09, 2010 at 14:53 UTC

    Sounds like fun.

    If you have URL access to the data, can you just walk through the tree, collecting and dumping data as you go? Then the dump could form the basis for the web application database.

    Things get a bit more complicated if this is going to be a continuous process, rather than a one-time dump. Once the process is better understood, we can start talking about tools, although I doubt some module is going to be a silver bullet.

    Tell me more.

    Alex / talexb / Toronto

    "Groklaw is the open-source mentality applied to legal research" ~ Linus Torvalds