Human Capital Management Blogs by SAP
Get insider info on HCM solutions for core HR and payroll, time and attendance, talent management, employee experience management, and more in this SAP blog.
cancel
Showing results for 
Search instead for 
Did you mean: 
yogananda
Product and Topic Expert
Product and Topic Expert

 

SAP HANA Smart Data Integration provide tools to access source data and provision, replicate, and transform that data in SAP HANA on-premise or in the cloud.

SAP HANA Smart Data Integration let you enhance, cleanse, and transform data to make it more accurate and useful. You can efficiently connect to any source to provision and cleanse data for loading into SAP HANA on-premise or in the cloud, and for supported systems, writing back to the original source.

Capabilities include:

    • A simplified landscape; that is, one environment in which to provision and consume data
    • Access to more data formats including an open framework for new data sources
    • In-memory performance, which means increased speed and decreased latency

 

Feature area Description

SAP HANA Smart Data IntegrationReal-time, high-speed data provisioning, bulk data movement, and federation. Provides built-in adapters plus an SDK so you can build your own adapters.

Includes the following features and tools:

    • Replication Editor in SAP Web IDE and SAP HANA Web-based Development Workbench or Web IDE, which lets you set up batch or real-time data replication scenarios in an easy-to-use web application
    • Transformations presented as nodes in SAP Web IDE and SAP HANA Web-based Development Workbench, which let you set up batch or real-time data transformation scenarios
    • Data Provisioning Agent, a lightweight component that hosts data provisioning adapters, enabling data federation, replication, and transformation scenarios for on-premise or in-cloud deployments
    • Data Provisioning adapters for connectivity to remote sources
    • An Adapter SDK to create custom adapters
    • Monitors for Data Provisioning Agents, remote subscriptions, and data loads

 

Data Integration on SAP Commissions HANA using SDI

SAP Smart Data Integration (SDI) is packaged as part of SAP Commissions and can be used to integrate your on-premise systems with SAP Commissions on HANA.

Smart Data Integration (SDI) allows you to securely transfer critical business data to and from the Commissions application, enabling you to easily synchronize and share data within your organization.

Using SDI, you can transfer data pertaining to the business data objects that are defined in Commissions. You can transfer data to and from the following workspaces in Commissions:

    • Orders and Transactions workspace for Results
    • Participants, Positions, and Titles workspace for Organization
    • Categories, Products, Customers, and Postal Codes workspace for Classification
    • Accounts, Geography, CRM Opportunities, etc for T&Q objects

Watch Introduction to Smart Data Integration on SAP Commissions

Prerequisite

Understanding of data integration concepts, knowledge of SDI, Web IDE, HANA SQL and procedures is a prerequisite for implementing SDI with Commissions HANA.


Use this checklist to get started with the setup and configuration process. Make sure you have all the information handy before you proceed:

 

Item URL Notes


S-User ID

 

Required to raise for any Support ticket.


Link to Download DP Agent


 


https://tools.hana.ondemand.com/#cloudintegration

Data Integration downloads


Tenant DB Name


 

Provided in provisioning email


Required to connect to Tenant DB from WebIDE


HANA HTTPs URL (SQL connectivity)


 

Provided in provisioning email


Required to create the data provisioning agent


Web IDE URL

https://webide.<<region>>.calliduscloud.com

Provided in provisioning email


Web IDE credentials


 

Provided in provisioning email


Required to import/export projects and create flowgraphs


HANA DB credentials


 

Provided in provisioning email


Required to access EXT Schema


Data Provisioning Task Monitor


https://<<servername>>-sdi.calliduscloud.com/sap/hana/im/dp/monitor/index.html?view=IMTaskMonitor

Required to monitor information about replication tasks and transformation tasks

Job Scheduler

 

https://jobscheduler-dashboard.<<region>>.calliduscloud.com/index.html

Provided in provisioning email


Required to access Jobs Success and Failed

 

Important to Know

SAP Commissions HANA Server (SDI Data Provisioning Server) hosted by SAP/Callidus Datacenter (To be treated as On-prem version)

Coming Next: Part 2 - SDI Architecture flow

References

The table below provides links to detailed information on the following topics:


TopicLink
SDI Product Availability Matrix

https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/TIP/PAM_HANA_SDI_1_0.pdf

https://userapps.support.sap.com/sap(bD1lbiZjPTAwMQ==)/support/pam/pam.html#ts=21&s=SDI&o=most_viewe...

https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/TIP/PAM_HANA_SDI_2_0.pdf
SDI Product Supporthttps://support.sap.com/en/product/support-by-product/73554900100800000033/default-editorial.html
HANA Academy Videoshttps://www.youtube.com/playlist?list=PLkzo92owKnVwQ_preA3cxlQjn_v3W0Eh5
HANA SDI Documentationhttps://help.sap.com/viewer/p/HANA_SMART_DATA_INTEGRATION
Commissions SDI Documentation
https://help.sap.com/docs/SAP_Commissions/271e5f8e84de4fada00d623e5095e77a/726eb3e87c231014a804993ce...
Ask a SDI Question
https://answers.sap.com/tags/73554900100800000033
SDI Blogs
https://blogs.sap.com/tags/73554900100800000033/
SAP Commissions - SDI ( Micro learning )https://microlearning.opensap.com/playlist/dedicated/173269331/1_5ze3hxol/1_pcp71u3l







Thanks, for reading it till the end. 🙏




Hope you find that helpful! Let me know your thoughts on this in the comments section.
Don’t forget to share this article with your friends or colleagues.
Feel free to connect with me on any of the platforms below! 🚀

yoganandamuthaiah |Twitter | LinkedIn | GitHub






FollowLikeRSS Feed
2 Comments