I tried connecting the SFTP through Data Transfer component using the SFTP url, username and sftp key credentials and passpahrase .I also converted the PPK key as RSA private key format which is only supported in Matillion. But while I tried connecting I faces AUTH CANCEL issue. Is anyone faced this issue? Is there any alternative component we can use to connect to SFTP using ppk key and passphrase?
@jeberson_david If you're encountering an "AUTH CANCEL" issue when connecting to SFTP via Matillion, it typically indicates a problem during the authentication process. Here are some steps to troubleshoot:
- Verify credentials: Ensure username, passphrase, and private key are correct.
- Check server configuration: Confirm SFTP server is set up to accept RSA private keys and passphrases.
- Matillion configuration: Double-check SFTP URL and authentication settings.
- Review debugging logs: Look for detailed error messages in Matillion.
- Explore alternatives: Consider other Matillion components or custom Python scripts.
- Seek support: Reach out to Matillion support for assistance if needed.
Remember to securely manage your credentials to prevent unauthorized access.
I think this may Help you
@HariRamK Thanks for your reply !