Skip to Content
author's profile photo Former Member
Former Member

SOAP API for SAP BPC 7.0 for the Microsoft Platform

Hi,

I'am looking for the SOAP API for SAP BPC 7.0 for the Microsoft Platform.

I want to import data into SAP BPC using webservices.

I know the client application is using SOAP to import data.

Where can I find documentation about the SOAP API for SAP BPC?

Has anyone experience with this?

Jan

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Oct 26, 2010 at 11:41 AM

    Hi Jan

    If I may ask, why do you want to import data using a web service, doesn't the traditional import methods available in BPC work for you.

    I am not aware of any documentation been made publically available, but I say this under correction.

    If you still don't want to use the traditional methods, have you tried created a stored procedure and then exposing that as a web service ( Provided you on SQL 2005 or later.. )

    Kind Regards

    Daniel

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Daniel Jacinto

      Hi Daniel,

      Thanks for your reply and extensive information about calling an SSIS package.

      As you already mentioned, this solution is very complex and not preferable.

      I'am currenty looking into the SOAP request that is fired by the client when starting a package. I found this request by using Fiddler. However I can't find the documentation about this SOAP request and also the WSDL is not published.

      I registerd an information request at SAP support portal and hopefully they will give me documentation on this, otherwise I have to solve this issue myself.

      Using SOAP calls, just as the client does, is certainly the prefered way.

      Jan

  • Posted on Nov 01, 2010 at 09:29 AM

    Hi Jan,

    Even if we will have all the information regarding the web services call for DM I don't understand how this will help you.

    You still need to use the BPC SSIS packages and also you have to use standard Transformation and Conversion files.

    BPC API will provide you just an interface from where you are able to call BPC packages (DM module from BPC) nothting else.

    But again you will have a lot of restrictions which means it will be easier to use BPC interface instaed to develop complex interface from where you will call BPC API which will probably not satisfy all the customer requirements.

    I was looking to entire thread and I think it is not a avlid option what you are trying to do. More than that it will request a lot of effort and it will not be supported.

    Kind Regards

    Sorin Radulescu

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Jan,

      Did you able to use web service to pull/push the data from SAP BPC MS to SAP ECC?

      We are planning to go in that routine but don't have a full understanding about how things will work, Really SAP BPC MS will able to call web service update its back end tables if SAP ECC web service is available?

      Your answer is much appreciated!

  • Posted on Nov 02, 2010 at 10:48 AM

    You have to ask the support to see if they can share the list with public web services of SAP BPC.

    But from what I know just BPC API for 5.1 was public. Starting with 7.0 we didn't publish anymore the webservices available into BPC application server.

    Any way in 5.1 amd 7.0 we provided just web services for read data, send data but nothing to call DM packages.

    So I don't think we will find easy a solution to call a DM package outside of BPC.

    One idea it will bve to schedule the DM package from BPC but not really for schedule.

    Just to go after that into Windows scheduler and to use the command line generate to launcgh the package.

    This can be a solution for you.

    Another option will be to think otherway around.

    Call from BPC package the SSIS from other tool.

    May be this suggestion can help you to find the bets solution.

    Regards

    Sorin Radulescu

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.