Integrate SAP BI/BO into Successfactors

[Former Member]

Scenario

Your company has begun using SuccessFactors and you would like to give the users easy access to your on-premise SAP BI or SAP BO reports.

Main alternative solutions to provide a seamless integration:

• SAP HANA Cloud Connector
• SAP Web Dispatcher
• SuccessFactors extension
• Tile development

SAP HANA Cloud Connector

• The SAP HANA Cloud Connector is the approach recommended by SAP to integrate cloud solutions with on-premise solutions.
• Requires an SAP HANA Cloud Platform license.
• Single Sign-On is possible.

Use in case of an existing need of an SAP HANA Cloud Platform license.

SAP Web Dispatcher

• SAP Web Dispatcher can be set up as a reverse proxy to allow external access to your SAP BI or SAP BO platform.
• No additional license required.
• Single Sign-On is possible.

Use when a simple integration with different styling is sufficient. A tile can be created with direct links to the SAP BI/BO reports and opened in a new tab using Single Sign-On.

SuccessFactors extension

• In order to present the report in the entire content frame of the browser and not just a tile, a SuccessFactors extension needs to be developed.
• Note that the reports will then be accessible from the navigation entry in the top left hand corner.
• Requires an SAP HANA Cloud Platform license.
• Single Sign-On is possible.

Use when harmonised styling and top user experience is a priority.

There are several resources on how to get started developing an extension, incl. this one:

http://scn.sap.com/community/developer-center/cloud-platform/blog/2016/01/13/creating-cloud-extensio...

Tile development

• In order to show data residing outside SuccessFactors in a tile, custom development is required.
• The integration can either be done using an SAP Web Dispatcher (no license) or the SAP HANA Cloud Connector (license fee) depending on the requirement.
• Single Sign-On is possible.

Use when a small dashboard or chart is needed on the Home Page to present aggregated, external data, and when harmonised styling and top user experience  are needed. Note the width limitation on tiles where the largest is 612 pixels wide.

As a final option, you could also consider to integrate a dashboard using a standard "custom tile". A suitable dashboard solution to do this could be Design Studio and I will create a separate blog post on this in the near future.

[Andreas_Grabher]

The other way around would be interesting. How to analyse SF data in your on premise BI system. In particular I'd be interested in having Learning data in the on premise BI system.

[Former Member]

Hi Andreas

Sorry for the late reponse.

To achieve your goal, have you considered this option?

1. Run one/more of your reports and make sure the result ends up in an FTP server. You can set this up through System Configuration > Report System. See link below for further details.
2. Load the files from the FTP server to DIR_HOME on the BW server and from there into the PSA. See link below for details.

Have a nice weekend.

Best regards,

Martin

https://community.successfactors.com/t5/Learning-Product-Discussions/Config-LMS-report-ftp-destinati...

http://www.element61.be/e/resourc-detail.asp?ResourceId=410

[Former Member]

Please also note that each customer gets their own FTP server that can be used for this purpose.

[Former Member]

Has anyone successfully used Odata as a means of utilising LMS data in an on premise BI system?

[former_member26235]

Hi Martin,

Thanks for your blog!

I am also interested to know, if the requirement is to feed BW with SF data (may be talent modules) through Webservices (I am not interested through middleware - SAP PI)? If yes, can you please help with the correct to approach?

Regards,

Kiran