We have Success Factor application and need to integrate with SAP BW/4 HANA system

[venkatraju_m]

how to integrate Success Factor application(SAAS) and SAP BW/4 HANA system(IAAS)?

[former_member71289]

Hi Anders,

generally it would work.

But some SF OData APIs will provide you only with the current record instead of the full history - unless you use so called provisioning parameters 'fromDate&toDate', please consider the following Knowledge Based Articles and SAP Notes about this topic:

2578195 - Unable to fetch historical data from EmpJob SF Odata through a virtual table in HANA SCP, SDI 1.x

2584924 - Unable to fetch historical data from EmpJob SF Odata through a virtual table in SAP HANA SCP

If you do not have BW/4HANA 2.0, I believe there is no better way then to call the API through the virtual table by SDI with these provisiong parameters and persist the data first in SAP HANA, then you can use a HANA data source to load the data from the HANA table into SAP BW.

With BW/4HANA 2.0 the Odata API is called directly with the provisioning parameters.

All the best,

Andreas

[former_member71289]

Hi Venkat,

it depends a bit which components of SuccessFactors you want to integrate.

Some SuccessFactors applications like Employee Central or Performance Management provide OData APIs that can be consumed directly by the oDATA adapter of HANA SDI and load through HANA DataSource into SAP BW/4HANA.

Alternatively you could use DataHub or CPI for the integration which also could consume oData / SOAP / RestAPIs of SuccessFactors components - this might be interesting if you have already DataHub or CPI in the game.

What is always possible for all components of Success Factors is to use SF Integration Center with which you can consume all different types of APIs (OData, SOAP, RestAPIs) and load it to SAP BW/4HANA via file. Not nice, but a pragmatic workaround whereever you run into problems with direct integration via SDI, CPI or Data Hub.

Best regards,

Andreas

[AndersKortbaek]

Hi Andreas,

In BWonHANA 7.5 SP2 it is possible to make a HANA DataSource:

https://assets.cdn.sap.com/sapcom/docs/2016/02/98df360a-617c-0010-82c7-eda71af511fa.pdf

Would that also mean that we in BW 7.5 can connect to the same SF OData APIs as BW/4HANA?

Thanks, Anders