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 Integration Real-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:











































Topic Link
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 Support https://support.sap.com/en/product/support-by-product/73554900100800000033/default-editorial.html
HANA Academy Videos https://www.youtube.com/playlist?list=PLkzo92owKnVwQ_preA3cxlQjn_v3W0Eh5
HANA SDI Documentation https://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












2 Comments