How to include SAP and SuccessFactors data in your enterprise analytics

August 12, 2021
Written by Danielle Larocca

Senior Vice-President of HCM Solutions Danielle Larocca has worked in the SAP HCM space for over 20 years. An SAP Mentor and featured speaker at numerous conferences, Danielle has authored four best-selling books on SAP, is the Technical Editor for the SAP Professional Journal, and often the Voice of the Expert on SAPInsider’s Ask the Expert series for HR.

HCM blog_QMAC-Beyond-HCM_header-image

Having all your data in one place is a critical step in making business decisions and achieving an intelligent enterprise 

We continue to learn more about the intelligent enterprise and how business leaders require accurate, real-time information, coupled with historical data and analysis to drive business decisions and ensure that the business is moving in a forward, profitable direction.


Back in the old days, this type of task was performed by extracting data, spreadsheets or text files from various systems and uploading them to a consolidated spreadsheet in Microsoft Excel or a database via Microsoft Access or even into SAP® BW in the early days. The old way of downloading and uploading files is no longer a reasonable method for transferring confidential data, including the obvious reasons noted below.


Top five concerns with downloading and uploading confidential data

  1. Data that is taken out of secure, protected databases in a raw format is no longer protected by the complex security structures put in place to protect it.

  2. Data is no longer live (real-time).

  3. Often custom programs are required to extract data which are expensive to maintain, error-prone, require continual maintenance and always run the risk of excluding any new items added to the database structure.

  4. Data merging between the data between two systems is rife with errors.

  5. The multi-step process replicated the data and stored it in various places.

These days, data is often shared to a cloud-based database like Microsoft PowerBI, SAP® Analytics Cloud, Tableau via dynamic connections to ensure the data feed is secure, dynamic and continuous, and ideally not replicating the data in an additional location. So now that we know how it should be performed, let’s take a moment to understand why your Human Capital Management data should be included.

Why should you include HCM data in your analytics?

You have heard the expression that “...a company's largest asset is its employees...” and including employee data in your overall enterprise strategic planning is critical. A strong connection between HR practice, workforce capabilities, financial performance, operational efficiency and business results is required to achieve an intelligent enterprise. An easy example to think of is calculating the revenue per employee (tabulated with data from multiple systems to produce a company's total revenue divided by its current number of employees) to establish an important ratio that roughly measures how much money each employee generates for the organization.

Where is the HCM data coming from?

Data from different areas of the business is commonly stored, in its original form, in its system of origin which is often unique to each line of business. See the fictional sample below.

HCM blog_QMAC-Beyond-HCM_diagram

In this example, an organization's data exists in at least four different systems including a logistics system (NetSuite), a customer management database solution (Salesforce), and their SAP and SuccessFactors HCM systems. For this example, I’d like to share how you can easily include your critical HR and Payroll data in your analytics solution, dynamically and securely.

Accessing HR and Payroll data in SAP and SuccessFactors Hybrid

It’s no secret that accessing human capital management data in SAP and SuccessFactors hybrid is often listed as the single biggest challenge that customers face. The data is often buried in complex structures (clusters) and is replicated in two systems for hybrid or Employee Central Payroll. Accessing it requires multiple products or a trained programmer to collect and collate the data. You are probably reading this blog because you know that EPI-USE Labs solved this challenge and offers the only S/4HANA certified reporting solution for real-time HR and Payroll reporting for SAP HCM and Hybrid SAP SuccessFactors, via the Query Manager solution.


The good news is that same solution includes an extension or add-on called the Query Manager Analytics Connector Add-on, that allows for the secure, dynamic transfer of data to analytics systems including the most popular ones on the market today:



New call-to-action



Explore Popular Tags

Query Manager SAP SuccessFactors SAP HCM reporting HCM Reporting SAP HCM SAP Reporting HCM SAP Payroll SAP SuccessFactors Employee Central Payroll EPI-USE Labs SAP SuccessFactors Reporting reporting PRISM Payroll Document Builder Payroll reporting Query Manager Analytics Connector SAP Analytics Cloud SAP HCM Data SAP Query Microsoft PowerBI SAP Payroll data SAP SuccessFactors People Analytics Variance Monitor HR and Payroll data Human Capital Management (HCM) Intelligent HR and Payroll Tableau HXM Move Payroll Data SAP HCM Payroll SAP S/4HANA SAP S/4HANA Private Cloud Edition (S/4 PCE) people analytics sap query hr Data Sync Manager Employee Central Payroll Journey to SAP SuccessFactors SAP SAP ERP HCM SAP HCM On-Premise Solutions SAP HCM journey SAP HR Reporting SAP and SuccessFactors HXM Reporting COVID-19 Cloud-based SAP HCM solutions Employee payroll HCM Productivity Suite HR SAP HCM/HXM SAP HXM reporting solution ABAP DSM for HCM Employee Central Payroll Reporting Employee data GeoClock H4S4 Let's Talk HCM PRISM for HCM (Private Cloud Edition) PRISM free assessment Pay Recon SAP Data Warehouse Cloud SAP HCM Analysis SAP SuccessFactors HCM Journey SAP SuccessFactors Roadmaps SAP data privacy and compliance SuccessConnect data validation payroll control center successfactors Data Sync Manager for HCM Employee Central GDPR HCM, HR OData Query Manager with Document Builder Real-time reporting and document creation SAP Analytics Cloud (SAC) SAP HCM On-premise SAP HCM for SAP S/4HANA On-Premise SAP HR SAP On-Premise customers SAP Payroll to the Cloud SAP Road maps SAP customers SAP data SAP data privacy & security Success Factors SuccessConnect 2019 Tax Reporting Transformation without re-implementation Ultimate Guide: SAP HCM & Payroll Options accurate payroll data certification custom infotype data source on-premise SAP HCM s/4HANA Analytics solutions Automated reports Automation Cloud migrations DSM Object Sync for SuccessFactors Hybrid Data Secure Data Types Data analysis Digital tranformation EPI-USE Labs’ solutions Employee Letters Employee communication Free HCM Assessment HR Journey HR employee reports Human Resources Human Resources data Hybrid Reporting SAP and SuccessFactors Hybrid SAP and SuccessFactors Hybrid reporting Hybrid reporting solution Integrated reporting SuccessFactors SAP Intelligent Enterprise Microsoft Excel News OData integration OM Object Sync On-Premise Payroll On-Premise Payroll S/HANA Sidecar On-premise reporting Organization of the data PA People Analytics Workforce Planning Personalized documents Protect personal employee data Report Stories Reporting and analysis Robotic Process Automation (RPA) Robotic Process Automation framework S/4HANA Private Cloud Edition (PCE) SAP Data Privacy Suite SAP Data Security SAP ERP Payroll customers SAP HCM Roadmap SAP HCM and Payroll customers SAP HCM for S/4HANA SAP HXM 2021 SAP Mentors SAP SuccessFactors Hybrid SAP SuccessFactors Next-Gen Payroll SAP SuccessFactors Release updates SAP SuccessFactors Time Management SAP SuccessFactors Time Tracking SAP Wage Type Reporter SAP certified solution SAP migration SAPPHIRE 2018 SuccessFactors and the Intelligence Enterprise SuccessFactors' Employee Central Payroll TCO Calculator The Report Center The Road to People Analytics Time management Workforce Planning ad hoc data variances easy reporter ebook high-speed, low-risk on-premise SAP data partner roadmap single reporting solution sq01 stories in SAP SuccessFactors People Analytics technology third party ALE STP report ASUG Accessing COVID-19 data Ad Hoc Query American Payroll Association (APA) Analytics Connector Analytics reports Analytics solution At-risk employees Australian Payroll Australian Tax Office (ATO) Automated analysis and pay run reconciliations Automatic HR reports Best practice in BI Bots Business Analytics Business Intelligence COVID-19 statistics COVID-19 vaccinations Certified solutions Check for data replication errors Client Sync Cloud hosting SAP PCE Company Branding Compare legacy HR and Payroll data Comparing data Configuration Center Copy and mask test data Coronavirus Created timestamp Custom store Customer-specific infotypes DSAG Data Privacy Data Replication Data Sources Data Sync Manager (DSM) Data access Data privacy regulations Data production support issue solution Democratize data Description Diversity & Inclusion reporting DocuSign Document Building Dynamic data ECC EPI-USE ERP Education sector Electronic Signatures Embedded Analytics Edition Employee Central time Employee Central timesheets Employee NICs Employee payment summaries Employee right to privacy Employer NICs Encrypt data FAQ Index Font Guidelines Gender Pay Gap General Data Protection Regulation Governance, Risk Management and Compliance (GRC) Government forms Grid control Grid layout HANA HCM Client Sync™ HCM/HXM/HR Blogs HIPPA HMRC HR Innovations 2019
+ See More

Get Instant Updates

Leave a Comment: