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

[former_member309681]

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!

[former_member186338 · Accepted solution]

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

[former_member186338 · Accepted solution]

SAP NetWeaver is DB independent (except HANA DB).

Vadim

[former_member309681 · Accepted solution]

Thanks, Vadim.  One follow up question. What factors drove your decision to to use SQL as the underlying db?  Licensing? Functionality?  Since the back end interface is the SAPGUI, once setup can you even tell that SQL is the db?  Thanks again.  Sorry, that was more than one follow up question.

[former_member186338 · Accepted solution]

We used MS SQL for SAP ERP main system, then, when we decided to implement SAP BPC - MS SQL was obvious choice. We have experts in MS SQL. But you can select any supported DB.

Vadim

P.S. Functionality will be the same for any DB except HANA.

[former_member309681 · Accepted solution]

Last question, I promise. I'm trying to get my head around what SQL knowledge can you leverage when the application is Netweaver.  Isn't any backend maintenance in the SAPGUI and any custom code done in ABAP and process chains?  What pure SQL functionality can you leverage?  Thanks again. 

[former_member186338 · Accepted solution]

None, just performance tuning...

We do not use any native MS SQL code in BPC badi's. But it's possible

Vadim

[former_member309681 · Accepted solution]

Terrific! That helps. Thanks.

[former_member182709]

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