Nov 29, 2019 Following blog post is describing steps to establish connectivity between CPI DS and AWS SFTP. In current example we are going to create a File Format data store, which will be connected to AWS SFTP via ssh key, sample project task which will be pulling data from file, stored on SFTP server, map data and save into database table. Is there a way to use AWS KMS for key management with SSH in Jenkins on Windows? Ask Question Asked 2 years. So we are looking at other options. We know that AWS has KMS which would allow us to generate and rotate our keys, but we are not sure how to wire up ssh with AWS KMS. UNPROTECTED PRIVATE KEY FILE! When trying to SSH into Amazon. Putty is a free SSH client for Windows. This guide will show you how to use Putty to generate your SSH keys and connect to your AWS server. Begin by downloading and installing Putty and it's related SSH key generation tool. Download both the Putty client (putty.exe) and the putty key generator (puttygen.exe). Step 2: Add Your Key to Your Amazon EC2 Instance. Use the following command to copy your key to your Amazon EC2 instance. /you/.ssh/idrsa.pub is the location to your ssh key, pemfile.pem is the.pem file you normally use to login, and user@ec2-instance.com is the user and hostname to your EC2 instance. For help with importing the public key into Bitvise SSH Server, check the Public Key Authentication section of our SSH Server Usage FAQ. Configure public key authentication. Once the public key has been uploaded or imported for your account in the SSH Server, configure the SSH Client to enable public key authentication on the Login tab.

Following blog post is describing steps to establish connectivity between CPI DS and AWS SFTP.

In current example we are going to create a File Format data store, which will be connected to AWS SFTP via ssh key, sample project task which will be pulling data from file, stored on SFTP server, map data and save into database table.

Prerequisites:

1. CPI DS is up and running, including DS Agent service running on Windows.
2. S3 Buckets are enabled on AWS and we have read/write access into buckets.
3. AWS Transfer for SFTP service is enabled in AWS Console on top of S3 Bucket Service.
4. Hana Database is running and connected from CPI DS.

Generate SSH Keys from DS Agent machine.

Open Command line and navigate to C:ProgramDataSAPDataServicesAgentconfkeyssftp

Enter command ssh-keygen.

Specify full path to save keys.

Enter passphrase.

As a result 2 files should be created under C:ProgramDataSAPDataServicesAgentconfkeyssftp

Where first is a private key and second is a public key.

Upload SSH Key into AWS Transfer for SFTP.

Login to AWS Console.

Navigate to AWS Transfer for SFTP Service.

Open user which will be used for connectivity with CPI DS. Add new ssh key.

Open public key file content, copy content and add new ssh key via AWS Console. Save.

Create Datastore in CPI DS.

Go to CPI DS and create new Datastore with the following settings.

Create new file structure.

Create DB Datastore

And import table to map data into.

Create Project Task to retrieve data from SFTP, map it and save into HANA DB.

Aws Sftp Cost

Run task to test connectivity and make sure records from file located in SFTP have been replicate to HANA DB Table.

Check the database table. Make sure records being created.

Aws Sftp Server

Conclusion

Ssh Generate Key Windows Amazon Aws Sftp Password

Following blog post illustrates how to configure connectivity between CPI DS and SFTP via public key. This guide can be used specifically for Amazon Web Services (AWS Transfer for SFTP).