Technical Articles

August 2, 2021 4 minute read

SAP Commissions – Smart Data Integration[SDI] – Part 1

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

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://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/726eb3e87c231014a804993ce4041860.html?locale=en-US
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! 🚀

Yogananda Muthaiah |Twitter | LinkedIn | GitHub

2 Comments

You must be Logged on to comment or reply to a post.

Goldy Bijjan

March 22, 2022 at 1:52 pm

Thanks for sharing this, it is very informative.

Yogananda Muthaiah

Blog Post Author

September 2, 2022 at 6:05 am

Thanks for reading Goldy Bijjan !!