I have a job in which I'm uploading a file from our S3 bucket to an SFTP site. I was provided two different keys to use, but neither of them are working, When I do this step manually using FileZilla it works perfectly.
What specifically should I be asking for?
Does this key come from our side or the vendor side?
My error message is 'Key cannot be empty" and this happens even though I have pasted the key information on the Target SFTP key component.
Screenshot of error is attached.
I added an additional image to show exactly where the error is happening
Hi @kerri.gathright,
The SFTP key would be given to you by who ever is administering the SFTP endpoint. When the key is generated there is a Public and a Private key. The public key is applied directly to the SFTP instance and then usually the private key is shared with the user trying to gain access to the SFTP. One thing I noticed in your screen shot is that it appears you are trying to give the component the Public key. (i.e. "-----BEGIN PGP PUBLIC KEY-----") This should be the private key. Take a look at the doc for the Data Transfer component (https://documentation.matillion.com/docs/2953509) and search for SFTP Key.
Let us know this helps at all. Thanks for posting!
Thanks so much for your reply! We had a meeting yesterday with the vendor and others from my company. The vendor insisted that no key is required from their end.
We generated a key from the server in which Matillion resides hoping that would help but still the same error.
The confusing part is that the documentation says the Key is optional but I'm not able to bypass.
Since the error persists, does this mean that we in fact DO need a private key from the vendor?
Any input would be greatly appreciated!
Hi @kerri.gathright ,
I am curious if you have checked the Matillion Server logs? If so, did you find any helpful information in there besides "Key cannot be empty"?
It looks like you are able to make the connection to the SFTP server using FileZilla. If you didn't configure a key for that connection then I would say it's not required. I would also say that if Matillion thinks it's required, there maybe a bug or something in the component. You would probably need to open a support case with Matillion on that one.
According to the documentation, the Data Transfer component should not require a SFTP key and it's noted as optional. The docs indicate though that if the server you are connecting to is requesting the key then it would be required.
If you contact support and they come up with an answer for you, please post back. I would be interested what the issue was. Thanks and sorry I couldn't be of more help.
