SAP Commissions on Hyperscaler - 🛠️Setup your own sFTP Key as Self Service

[yogananda]

Dear All,

As you may be aware, in the past & current today for HANA and Oracle tenants you had to raise a support ticket in order to set your FTP Public keys. However, with the new SAP Commissions Architecture on Hypersclaer, you can configure on your own without the requirement for a ticket or the sharing of your public key.

In this blog, I will explain how you can configure the key on your own with simple steps and it takes just within 2-5mins.
Let’s get started

To generate your public/private key pair for SFTP, please follow the steps below:

1. Install the PuTTY Key Generator, navigate to the PuTTYgen directory, and launch it. The default directory path is C:\Program Files (x86)\PuTTY\puttygen.exe.Note: If you have an existing public/private key pair in PPK format
2. Create a new public/private key pair by clicking the Generate button:
3. Move your mouse over the blank area to create some randomness that can be used to generate the keys:
4. Save Public and Private key in your local folder.
5. Private Key should look like below
   -----BEGIN RSA PRIVATE KEY-----
   [key content here]
   -----END RSA PRIVATE KEY-----

---

Login to SAP Commissions -- Go to Express Data Loader

Go to Configuration - File Transfer Settings

Upload your public Key which you generated
Open your WinSCP, and fill all the relevant details for you to get login

hostname : <GCP tenant domain name>

port : 9092

username : <find it in CDL File Transfer Settings>

Key - Go to Advanced - Key Configuration - Provide your Private Key path

---

Now, you could able to see folders after your login

 

[philipholtom]

Great to see this self-service feature! Will make life easier.

Is this something we will see on the non HyperScaler platforms in future do you think?

[yogananda]

pholtom

All Oracle / HANA customers will be Migrated to HyperScaler.  This feature is not available currently for Oracle. For HANA Customers, you can ask Support team to enable it if there is already feature available as Feature Flag

[minjie_lao]

just for user who is working on MacOs,  following steps are generating the public/private key under macos

1. Open a new Terminal window


2. Type ssh-keygen -b 4096 -t rsa 


3. You will be prompted to enter a filename. By default, your keys will be saved as id_rsa and id_rsa.pub. Simply press Enter to confirm the default - there is no need to change this unless you have multiple keys! (Note: if you would like to change the default filename, you'll need to include the complete file path)


4. When prompted, enter a passphrase.


5. This will created a hidden directory called .ssh that contains both your public (id_rsa.pub) and private (id_rsa.) key files.

[yogananda]

Thank you 352684 for providing the steps for Mac Apple users ! 🙂

[IshtiaqAlam]

I am facing problem in Sftp key upload . It is Key format not supported

[DChristenson]

Puttygen does not create the correct format of the key - use the ssh-keygen method to create the SSH keys.  I do not use a passphrase when setting up the keys.  Once you create the public key, you should be able to upload it into XDL without the format error.

[Ashwani_Koul]

@yogananda Since there is currently a limitation of 1 key in GCP, Is there a way to know which key is currently loaded in the XDL? Also, is there a tentative date for multiple keys to be used so that multiple users can access the system? Thank you!

Ref  - https://me.sap.com/notes/3444150/E

[yogananda]

@Ashwani_Koul- you or Admin should gather the keys together for multiple users and append in same key in next line .. uploaded it back to XDL SFTP configuration.  If you have API access to XDL, you can check which key is uploaded.