Create Keystore (SSH Key) for SAP Commissions Data Loader (CDL) in SAP Cloud Integration CPI

[Kim_Heckscher]

Use Case

Commissions Data Loader (CDL) is a vital component of the Commissions application. CDL allows you to securely import and export critical business data to and from the Commissions application, enabling you to easily synchronize and share data within your organization for further processing.

Using CDL, you can import and export data pertaining to the business objects that are defined in Commissions. You can transfer data in bulk, 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

With the SAP Cloud integration (CPI) we will securely import and export the critical business data to and from our ECC Eco System to the development and productive SAP Commissions Data Loader Dropbox (CDL.

Process Overview

Perform the following Steps:

1. Download and install the SSH/SFTP Client. CDL works with any standard SSH/SFTP client application. The most commonly used free SSH/SFTP client for Windows is WinSCP. You can download and install WinSCP from https://winscp.net/eng/download.php. To illustrate a typical client setup process, WinSCP is used as an example in this documentation.


2. Generate an SSH Public/Private key pair in your SSH client. For example, in WinSCP client, PuTTYgen is used to generate the SSH2 key. We support setting SSH 2 (RSA)to 4096


3. Associate the key pair with your email address to help you identify the key later on. For example, in WinSCP client, you can specify your email address in Key Comment


4. Save the public and private key pair. Specify a file name for the public and private key and save the key files in the same location. We recommend that you save the key files in a location that you can easily find later.


5. Open the Public SSH2 key file using any text editor and copy the public key. Send support the public key by logging a ticket. Your ticket must also include information about the customer tenant id you will be connecting to. Our technical operations team will install your public key in the Secure Box and give you access to your SFTP Dropbox (via a support ticket). You will then receive details about the SFTP File Protocol, Hostname, Port, and Username from the technical operations team.


6. To perform file transfers, log in to your SFTP Dropbox using the credentials provided by the operations team. When connecting to SFTP, you must provide the private key for authentication. For example, in WinSCP, the private key is updated in Advanced Settings> Manage > Edit option > Private Key File.


7. Convert your Private Key with Puttygen to an OpenSSH Key


8. Import the OpenSSH Key to CPI Keystore.


9. Test your Connection on CPI

Requirements

• Puttygen.exe (Click on link to the left and scroll down to find the download relevant to you)


• (S)FTP Client: Used to transfer files over the internet, for example, WinSCP


• SAP Commissions URL, for example, https://<tenant>.callidusondemand.com/SalesPortal/#!/

Create SSH Key Pair with puttygen.

1. Create SSH key with Puttygen
   


2. Save private-key once as standard (e.g. WinSCP) and one as openssh key
   


3. Save public-key - e.g. to send by SR to SAP for the Commission Data Loader (CDL) Dropbox
   

Change the filetype to .txt for uploading to Service Request Management of SAP Commissions.

 

Get access to the Commission Dropbox

Now you have to create an Service Request on Service Request Management for SAP Commission. Open the Service Catalog and select “Sales Performance Management SPM” and
the Service “SPM - Dropbox and, Landing Pad Shell Access Request”

LINK: SAP Commission - Services Request Management - SRM

Fill out the Request:

The filetype of the attached publickey needs to be “txt” for uploading to Service Request Management of SAP Commissions.

 

Import SSH Key into CPI Keystore

After you send the public key to SRM of Sale Performance Management (SPM) you can add your Key Pair to your CPI Keystore.

1. Open the Keystore of your SAP Cloud Integration (CPI) (Monitor)
   


2. Add SSH Key
   


3. Example to fill out the Form
   


4. Finally saved SSH Key on CPI Keystore:
   

Test your SSH Key with your Tenant

After the feedback from Suppport of successful placement of your Public Key you can Now you’re your SFTP Connection.

Open your Cloud Integration Tenant and select Monitoring Oveview / Connectivity
https://<YOURID>-tmn.hci.eu2.hana.ondemand.com/itspaces/shell/monitoring/Connectivity 

• Klick the Option SSH and Maintain your relevant Host / Port and select Public Key for Authentication and set the Username “1234” and choose your prior saved SSHKey.


• Klick on SEND and hope you will get the successful confirmation. (fingerscross)

 

Links

SAP Commissions | Home
SAP Cloud Integration | Home

SAP Commission - Services Request Management - SRM
Help - Commissions Data Loader (CDL)

CX Works | Get Access to Commission Data Loader (CDL) Dropbox (sap.com)

SAP Commissions sFTP – Integration Suite Use Case | SAP Blogs