Skip to Content

Is anyone using BPC 10 NW with SQL as the BW database?

We want to use SQL, but also want the functionality that comes with the NW version. My understanding is that you can install EPM 10 NW, then when setting up BW select SQL as the database type. That is where my understanding ends. Do you use SAPGUI to view the tables or SQL? Do you use ABAP and process chains or stored procedures and SSIS or both?

Are there any other experiences to share?

Thanks Experts!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 16, 2014 at 11:48 PM

    Hi Jonathan,

    Yes, we are using MS SQL as a DB for BPC NW. We are using this DB also for SAP ERP...

    And yes: we are using SAPGUI to view the tables, using ABAP and process chains

    Vadim

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 17, 2014 at 05:59 AM

    Hi Jonathan,

    Yes, you can use SQL Server as the DB of BW. But as i know, you cannot use store procedures and SSIS. The process chains mentioned by Vadim should be the BW concept process chain. Not Microsoft SSIS package.

    Best regards,

    Charlie

    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.