Technical Articles
Connecting SAP SuccessFactors and SAP Datasphere
In today’s technologically advanced world, an enormous amount of data is being produced every day from many sources for businesses of all sizes and it is important to make sense of the growing volumes of data. Data analytics helps organizations make sense of data. This allows the organization to be more involved in addressing business needs, identifying problems, recommending solutions and also enable to create new business models by using the next level of creative business intelligence services. The proper usage of business intelligence can qualify them to improve profitability and income. It helps them to
- Evaluation of the current roles and organization structure
- Find opportunities for improvement, review processes and speak with team members.
- Examining procedures and communicating to find areas for improvement
- Presenting findings and recommendations to management and other key stakeholders
- Making financial and visual representations to assist with business decisions
- Educating and coaching about new systems
This is exactly how SAP Datasphere delivers meaningful data to every data professional. So, what is SAP Datasphere? It is the next generation of SAP Data Warehouse Cloud, a comprehensive data service enabling every data professional to deliver seamless and scalable access to mission-critical business data. (Read the announcement blog)
Human capital is the most valuable asset for a company, but it is also one of the most challenging parts of running an organization. Employees’ qualitative characteristics can be difficult to translate into analytically valuable figures. So how can we objectively evaluate workforce elements like hiring, performance management, or employee engagement to identify emerging patterns and foster organizational success?
You may have spent considerable time creating ad hoc reports in SAP SuccessFactors because you need a template for your business scenario. Your challenge is visualizing data in a way that effectively highlights critical insights or complex calculations aren’t your strength.
In this blog post, let us take a look at how to setup and configure SAP Datasphere to consume data from SAP Success Factors and create analytical reports.
Blog post series for our learning journey with SAP Datasphere and SAP Analytics Cloud together to handle complex analytics scenarios.
|
Prerequisite
You need to have:
- SAP BTP global account setup and to entitled the SAP Datasphere Cloud Foundry environment please follow the excellent blog How to create SAP Datasphere service instance in the SAP BTP Platform?
- A SAP SuccessFactors instance.
Let’s proceed Step By Step
Before we start, ensure you have set up and launched the SAP DataSphere service instance; if not, Goto your subaccount space then the services Instance page, search for “DataSphere”, and click on the three dots(…) on the rightmost side with Datasphere instance and then View Dashboard.
OR Look for the URL to the newly created SAP Datasphere tenant in the email.
Create Space
Space is a secure area that an administrator creates where users can acquire, prepare, and model data. The Administrator can set the space’s priority, assign disc and in-memory storage, and set a memory consumption limit. Spaces are virtual work environments with their databases.
Users can collaborate without worrying about disclosing their data because spaces are decoupled from one another but are available for flexible access. Start with a space to model your data and develop your stories. You can choose the volume, kind, and relevance of storage you require for your space compared to other spaces.
Note: you can use existing space and directly start with Create Connection, OR you can create a new space by following the mission Get Started with Your Trial in SAP Datasphere, OR follow the simple step as mentioned below.
Create Connection
To access data from various sources, including those that are on-premises, in the cloud, or both, or those that are SAP-related, as well as those that are not, SAP Datasphere provides a wide variety of default connections.
Connections are in a separate view accessible from the main navigation window on the left. In SAP Datasphere, connections are individual objects. They are built and maintained per SAP Datasphere space; only individuals who are a part of that space may use the linked connections.
Connections allow the space members to connect sources for accessing and modelling data in SAP Datasphere.
In the side navigation area, click on Connections, select a space if necessary and then click the Local Connections tab.
Click Create to open the connection creation wizard.
In the connection creation wizard, please enter a search string SuccessFactors in the search field to only show the connection type for SAP SuccessFactors. Click an SAP SuccessFactors connection type tile for your source.
Complete the configure connection properties.
Connection Details
URL : Enter the OData service provider URL of the SAP SuccessFactors service that you want to access.
Version : Displays the OData version used to implement the SAP SuccessFactors OData service.
Authentication
Authentication Type : User Name And Password:
User Name : Enter your API user and company ID in the format <username@companyID>. e.g. sfapi@HXM2345 into the User Name.
Password: Enter the password.
Click on Next Step
Enter a descriptive Business Name, which you can change at any time. Technical Name displays the name used in scripts and code, synchronized by default with the Business Name. Once the object is saved, the Technical Name can no longer be modified. To Provide more information to understand the object enter the Description as well.
Click Create Connection to add the Connection to the overview of available connections.
Select the connection and click to check if the connection is valid and can be used for the enabled features.
As soon as we try to validate the Connection, we get a warning which shows the Connection is valid. Still, it cannot establish a secure connection due to no valid service certificate. It mentioned that we need to upload the certificate of service or the certification of the signing authority(CA) to allow Remote Table and Data Flow features.
To enable a secure SSL/TLS-based connection, we need an SSL certificate, a digital certificate that provides authentication for a website, and a secured encrypted connection, for a connection type that allows remote tables and data flow.
We must upload the server certificate to SAP Datasphere to successfully validate and use the SAP SuccessFactors connection.
Download Certificate
One of the easiest ways is to download the required SSL certificate from an appropriate website. Common browsers give users the option to download these certificates by exporting them.
Visit the website for the URL you wish to download the Certificate from. For instance, at https://salesdemo.successfactors.eu, sign in with your login and password and the correct Company ID.
After logging in, notice the certificate information Pop-up by clicking the padlock icon before the URL.
As shown below, click the Connection is secure link.
Click on Certificate is Valid Tab to bring up the certificate viewer to export the appropriate Certificate.
Click the Export button to export the certificate to the download folder.
Upload Certificate
We have already discussed a server certificate to SAP Datasphere that needs to be uploaded to enable a secure SSL/TLS-based connection that allows remote tables and Data flow.
Return to the SAP Datasphere system once more, then click System then Configuration in the side navigation menu.
Click the Add Certificate icon under the Security tab.
Choose the certificate by browsing your local directory in the Upload Certificate dialogue. Add a description to the certificate to give understandable information about it. Choose Upload.
In the Security Overview tab, you can see the Certificate’s creation and Expiry date. If required from the Overview, you can delete certificates as well.
After successfully importing the Certificate, we need to recheck the connection validation. So, In the side navigation area, click on Connections, select a space if necessary, and then click the Local Connections tab.
Select the Connection and click Validate to check if the Connection is valid and can be used for the enabled features. After some time, a message popped up which shows Connection is valid
With this validated Connection, you are now ready to connect to SAP SuccessFactors data from SAP DataSphere with the enabled features.
Summary
So, now you have seen how to create a valid connection with SAP SuccessFactors with the availability of supported features – Remote Tables, Replication (snapshot) and Data Flows.
What’s next?
In the next blog post, we will see how to use this connection to access employee-related data directly from the source into Remote Tables and Replicate it into SAP DataSphere to improve performance while accessing.
Bring SAP SuccessFactor Data into SAP Datasphere
Keep your anticipation high for the upcoming blog posts. Stay curious!
Reference & Further Reading
SAP Datasphere Power Of Business Data
SAP Datasphere: Overview and Architecture
What is SAP Datasphere and what benefits does it bring to your business?
Unlock the full potential of your enterprise data with SAP Datasphere Catalog
For more information and related blog posts on the topic page for SAP Datasphere.
If you have questions about SAP DataSphere you can submit them in the Q&A area for SAP Datasphere in the SAP Community.
Great blog post Lalit Mohan Sharma - Thanks for sharing this valuable guide!
Thanks for your feedback! Martin
Hi Lalit,
Thank you for sharing informative blog.
I need one clarification on this.
You have mentioned the User Name : Enter the user name in <username@companyID> format while creating connection in DWC.
Can you please confirm this ID is successfactors login ID ?, if so I have ID like testuser@company.com and Company ID: abcID then what would be the user ID ?
If any other user ID please let me know.
Thanks
Ashwani
Hello Ashwani
Thanks for your feedback.
You are correct; it is a Company ID. I will update it in the blog post as well.
Thanks, Lalit
This is a great guide; thanks for creating it!
I have uploaded the certificate as well as done the other pre-requisites for SuccessFactors connections. However, I'm still receiving the "server certificate cannot be validated" error message.
Are there any other tips that might fix this?
Thanks much
Hello Mike,
Thanks for your feedback.
In the Certificate hierarchy, make sure you have selected the top one and Exported it.
Best Regards,
Lalit
Great--that was the issue. Thanks!
Mike
Great post Lalit, thanks for sharing details.
Hello Premnarayan Patidar Thanks for your feedback!
Thanks for sharing. Does it include SF Learning data?
Hello Jacques,
No, it is not included SF Learning data. As per my knowledge, you need to consume SAP SuccessFactors Learning OData APIs to connect with SF Learning API.
Best Regards,
Lalit
Expected, but not what I would like to hear. 🙂
Thank you for your prompt response. Much appreciated.
Hello Jacques Maeda, Thanks for your feedback. 🙂
Hi Lalit Mohan Sharma
Thanks for the great blog post.
I have an issue with the certificate. I am not allowed to access API using basic authentication or oauth on the SF server. So I am using API server instead as mentioned in https://help.sap.com/viewer/d599f15995d348a1b45ba5603e2aba9b/LATEST/en-US/af2b8d5437494b12be88fe374eba75b6.html
I have downloaded the certificate from the API server
and uploaded it to datasphere. However I am still having warning on the connection
Please advise.
Thanks,
Amri