PCM export data to BW

[Olj]

Hi Dear Experts,

Could you help me please, we will use DataBridge to load data from BW to PCM, but can DataBridge load data from PCM to BW? It's necessary to build reports on BW side.

Or there are other variants to load data to BW?

Thanks...

[Former Member · Accepted solution]

Hi Daulet,

Please look into the 'Export to database' option for calculated results in PCM (see PCM F1 help files or Model builder guide on help.sap.com).

BW could pick up those database tables using database connection.

If you are reporting using SAP BI tools, check the Export to Universe feature.

Kind Regards,

Jef

[Olj · Accepted solution]

Hi Jef,

we did db connection on BW side to PCM oracle database.

We see data, but we cannot use DB connect, because some fields is inactive:

Can you help me?

[Former Member · Accepted solution]

Hi Daulet,

please have a look at it, specially to the page 7. "Note further that the NAME column from all of these tables is data type nvarchar(256) and therefore cannot be accepted by DB Connect (see Note 512739 mentioned in pre-requisites above)"

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/c06e1bc4-0475-2c10-ada3-aa46c8059...

Regards