Following blog post is describing steps to establish connectivity between CPI DS and AWS SFTP.
- Product Key Windows Xp
- Ssh Generate Key Windows Amazon Aws Sftp File
- Ssh Generate Key Windows Amazon Aws Sftp Server
- Ssh Generate Key Windows Amazon Aws Sftp Download
- Ssh Generate Key Windows Amazon Aws Sftp Free
You can either use KeyGen or PuttyGen(for Windows) Let us create key pair using KeyGen. First go to the.ssh directory which we have created recently. Cd /home/atidke/.ssh Generate the Key-Pair. Ssh-keygen -t rsa Copy the content of public key (file with.pub extension) into the authorizedkeys which should be located inside the.ssh directory. Connect to your SSH server using WinSCP with the SSH protocol, using other means of authentication than public key, e.g. Typically using password authentication. Once logged in, configure your server to accept your public key. That varies with SSH server software being used. The most common SSH server is OpenSSH.
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:
- CPI DS is up and running, including DS Agent service running on Windows.
- S3 Buckets are enabled on AWS and we have read/write access into buckets.
- AWS Transfer for SFTP service is enabled in AWS Console on top of S3 Bucket Service.
- 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.
Product Key Windows Xp
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.
![Generate Generate](/uploads/1/2/6/6/126611220/754672397.png)
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.
Ssh Generate Key Windows Amazon Aws Sftp File
Open public key file content, copy content and add new ssh key via AWS Console. Save.
Ssh Generate Key Windows Amazon Aws Sftp Server
Create Datastore in CPI DS.
Go to CPI DS and create new Datastore with the following settings.
Create new file structure.
Create DB Datastore
![Sftp ssh key import Sftp ssh key import](/uploads/1/2/6/6/126611220/900926425.jpg)
And import table to map data into.
Create Project Task to retrieve data from SFTP, map it and save into HANA DB.
Run task to test connectivity and make sure records from file located in SFTP have been replicate to HANA DB Table.
Ssh Generate Key Windows Amazon Aws Sftp Download
Check the database table. Make sure records being created.
Conclusion
Ssh Generate Key Windows Amazon Aws Sftp Free
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).