3319018 - How To Enable Feature Data Inspector

This KBA illustrates how to enable the 'Data Inspector' feature. This tool is designed for users to check raw data for troubleshooting purposes.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP SuccessFactors Employee Central
• SAP SuccessFactors HCM Suite

The Data Inspector admin tool is designed for you to view and download the raw data in a tabular format from the system. In the table, it's possible to review the various entity tables accessed previously by different tools in SAP SuccessFactors.

Data Inspector only allows you to view and download the table. You can’t modify or upload the table using Data Inspector. Also, the tool doesn't show personally identifiable information (PII). 

Step 1:

As the Data Inspector is based on OData API, we need to enable OData in provisioning:

• Make sure the "Disable OData API" is unchecked 
   

NOTE: As a customer, you don't have access to Provisioning. To complete tasks in Provisioning, contact your implementation partner. If you're no longer working with an implementation partner, contact SAP Cloud Support.

Customer Action:

Customer must provide a written approval for task: 'Disable OData API' to be unchecked

Step 2: RBP Permissions for OData Metadata

Make sure the following two OData metadata released permissions have been assigned:

• Go to: Manage Integration Tools
• Access to OData API Metadata Refresh and Export 
• Access to OData API Data Dictionary
   
  

Step 3:

(Optional) Refresh the OData API Metadata

Refresh the OData API Metadata in Admin Center.

The OData API Metadata refresh will be executed by background job periodically. Well in case we cannot see the latest metadata, we can trigger it manually from here.

Using OData InspectorPermission for OData Inspector: 2589774 - MDF Object Definition to DB Sync or Refresh Metadata Cache

Step 4:

Assign the Data Inspector permission to a role:

• Go to: Manage System Properties

• Data Inspector 
   

Step 5:

Check Data in Data Inspector

After permission assignment, we can find it in Admin Center:

1. Choose a table or system information item from the Entity dropdown.
2. Define filter criteria.

   The text boxes in the Define Filter Criteria are case-sensitive.

3. Choose Show Data.

   A Results table is displayed.

4. To download the report, choose download.

Example For Employee Central

• Go to Tool Search --> Data Inspector
• Select one of: Table_EMP_EMPLOYMENT_INFO
• Or Table_USERS_SYSINFO   //  Table_EMP_EMPLOYMENT_INFO   // Table_EMP_EMPLOYMENT_INFO_AUD  // Table_EMP_JOB_INFO_T // Table_EMP_JOB_INFO_T // Table_WF_REQUEST/ Table_PER_PERSON
• Filter:
  Users Sys ID =

Also:

In the Data Inspector:

• Entity: Choose the Entity we want to check. It could be a table, or system info.
• Filter Criteria: We can filter the data based on conditions, like: Equals, Doesn't Equal, Contains, Greater Than, Less Than, etc.
• Data Table
  The data will be shown in pages. In the following screen shot, it shows the first page containing 200 records.
  We can download the data to local computer.

View some Audit Entity :

• Table_EMP_JOB_INFO_T_AUD
• Table_EMP_COMP_INFO_T
• Table_EMP_COMP_INFO_T_AUD
• Table_EMP_EMPLOYMENT_INFO_AUD
• Table_EMP_JOB_RELATIONS_INFO_T_AUD
• Table_BE_ECT_PAYINF_D_AUD
• Table_EMP_JOB_RELATIONS_INFO_T_AUD
• Table_PER_PERSON_AUD
• Table_EMP_PERSONAL_INFO_T_AUD
• Table_PER_PERSON_INFO_GBL_T_AUD
• Table_PER_PERSON_RELATION_T_AUD

FAQ - Additional Information

Q) Where can I get information on this from the Guide?

A) Guide: Using Admin Center

• Chapter: Using Data Inspector

• 3058601 - How To Check Soft Purge or (Hard or Permanent Purge ) User
• 2545988 - How to Purge/Delete users in SuccessFactors 
• 3375924 - How To check User Status Via Data inspector 
• 2584658 - How to Check if a User is an EC User using the Integration Center
• 2744431 - How to create a Change Audit Report and what reports are available? - FAQ
• 2618848 - Enabling Change Audit Feature 
• 2790859 - Change Audit Log Report for Metadata Framework (MDF) Configuration and Data Changes
• 2472648 - Check Tool: How to check your SuccessFactors configuration

Data Inspector , Disable OData API, Refresh the OData API Metadata in Admin Center , Manage Integration Tools, Access to OData API Metadata Refresh and Export, Access to OData API Data Dictionary, Table_EMP_, Table , KBA , LOD-SF-EC-ADM , Admin Tools (EC Core only) , LOD-SF-PLT-DRM , Data Retention Management , How To

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Suite all versions ; SAP SuccessFactors Platform all versions