How to expose BW data (DSO/InfoCube) to DataServices using ODP?

[pelleko]

Hi,

we want to export BW data (DSO/InfoCube) with DataServices using ODP. We already have this setup working for BW->BW, using the INFOPROV$F DataSources.

Our initial idea was to setup a DataStore of type SAP BW Source in DataServices (as discussed in Using extractor as source (BODS 4.2)), but there we do not have the Object Type "Extractor" available. I don't understand this, since I think our Systems have the required updates (BW7.4 SP14 and BODS 4.2 SP11) and I didn't find any more hints on this online.

Our second idea was:

1. generate an export DataSource in BW
2. expose that to ODP using RODPS_OS_EXPOSE
3. access that ODP source from DataServices (DataStore Type: SAP Applications)

However, as discussed in ODP Framework Blog, the extractor can't be exposed in this way and therefore not found as ODP Source. Also SAP Note 2368268 agrees this is not the correct approach and confirms we should work with the ODP API 1.0 which should be available for BW7.4 SP14.

Can anyone help here?

Many thanks in advance,

Pelle

[pelleko · Accepted solution]

The solution was to setup a DataStore of type SAP Application instead of SAP BW Source in DataServices. This made Object Type "Extractor" available and allowed us to extract data. See: dataservices-odp.png

In this specific case we however chose to not use DataServices and instead go with Open HUB /Azure Data Factory as an ETL Tool to extract data from BW to a MS Azure DataLake.

Best, Pelle

[john_hawk]

Hi Pelle,

I have not used ODP, but I'm sure they can connect to a database table. Consider making an ODP connection to the underlying table.

DSO - Connect through the Active Data table

InfoCube - Much tougher, since InfoCubes are a cluster to tables. Consider exporting the data using OpenHub to a database table on the BW system, them connecting to the OpenHub table.

Let us know how you solved the issue.

John Hawk