Typically, the data used to calculate compensation originates in various source systems. The Data Integration process is used to ensure that this data is property mapped and updated regularly before each calculation is run.
For example, payees enter their sales transactions into a CRM tool. The transaction data is integrated into the system, where the payments are then calculated.
When using most data integration options, inbound data moves to a series of staging tables.
- Excel Data Loaders are used for ad hoc data loads on the user level. It is not designed for high volume data transfers.
- Express Data Loader (XDL) is an ideal solution for small to medium-sized businesses. This tool is included with the system and uses a secure dropbox to load high volumes of data. The data transfer is completed with HANA procedures.
- DataSphere is an SAP tool designed for high data volume and data transformation. It runs on SAP Business Technology Platform (BTP) and requires technical expertise to accomplish data integrations.
- SAP Integration Suite is a cloud based integration platform. It can be used to build complex integration scenarios, manage APIs, and extend connectivity to both SAP and non-SAP cloud applications.. SAP Integration Suite runs on SAP Business Technology Platform (BTP).
- REST APIs are new configured APIs. Typically, APIs are used for smaller volumes of data, with real-time integration.