send file data using AWS AppFlow

Question

Hi

I have a file which is encrypted using PGP encryption and decryption in core .net now next requirement is send the file to sftp using aws appflow.

I'm looking for how to send file to s3 bucket via sftp.

Amit Mohanty · Answer

Hey, please check the below link, this may help you. https://medium.com/tensult/aws-transfer-for-sftp-secure-shell-file-transfer-protocol-f37e09f94813 You can transfer file using WinSCP also. Please check the below code. Namespace to use: using WinSCP; readonly string sHostName = "host neme/ ip" ; readonly string sUserName = "user_name" ; readonly string sPassword = "your password" ; readonly string sSshHostKey = "your SSHHostKey" ; readonly string sFilePath = @ "your local file path" ; readonly string sToFilePath = "S3 folder path" ; public void CopyFiles( string sFilePath) { try { // Setup session options SessionOptions sessionOptions = new SessionOptions { Protocol = Protocol.Sftp, HostName = sHostName, UserName = sUserName, Password = sPassword, SshHostKeyFingerprint = sSshHostKey }; using (Session session = new Session()) { // Connect session.Open(sessionOptions); // Upload files TransferOptions transferOptions = new TransferOptions { TransferMode = TransferMode.Binary }; TransferOperationResult transferResult; transferResult = session.PutFiles(sFilePath, sToFilePath, false , transferOptions); // Throw on any error transferResult.Check(); // Print results foreach (TransferEventArgs transfer in transferResult.Transfers) { Console.WriteLine( string .Format( "Upload of {0} succeeded" , transfer.FileName)); } } } catch (Exception e) { Console.WriteLine( string .Format( "Error: {0}" , e)); } }

Ritu · Answer

Hi, I want to access the SQL Server instance on an aws appflow. is this possible? if yes can u provide some solution in c#