RVR-SFTPConn-100

Issue summary

• You are encountering a connection error with the code RVR-SFTPConn-100 while attempting to connect to an SFTP server using Data Integration. This error typically indicates that there are bad credentials or permissions issues involved in the connection process. This could be due to incorrect login details, such as the username, password, or key file, or missing permissions for SFTP access.

Action steps

To resolve the error, follow these steps:

• Check Allowlisting: Ensure that Data Integration you have allowlisted the IP addresses on your SFTP server. Without this, you might face connection issues related to network blocking.
• Verify Credentials:
  • If using basic authentication, confirm that the username and password are correct. Ensure there are no spaces or unintentional characters in these fields.
  • If using a key file, ensure that the correct private key (.pem) and its password, if applicable, apply. This also involves generating a public key in Data Integration and adding it to the SFTP server's authorized_keys file.
• Permissions: Make sure that the SFTP server permissions allow access from the provided credentials (username, key).
• Test Connection: Use the Test Connection feature in Data Integration connection setup to verify that the settings are correct. This feature helps in diagnosing if credentials or network configurations are successful.
• Configuration Review: Recheck all configuration fields like Host, Port, and Connection Name for any discrepancies.

3. External References
   • Detailed steps on connecting by SFTP in Data Integration: Data Integration SFTP Connection Documentation.
   • General SFTP setup and troubleshooting documentation: Data Integration Documentation for IP address allowlisting and other connection setup references.

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.