RVR-SYNP-100

1. Issue Summary

   • The error code RVR-SYNP-100 indicates an issue trying to connect to Azure Synapse using the Rivery platform. This error typically results from network connectivity issues, IP whitelisting issues, improper configuration settings, or authentication failures.
   • It's crucial to diagnose whether it's a network-related problem or misconfiguration by checking the settings and connectivity options in the Rivery setup.

2. Action Steps:

   • Whitelist IP Addresses: Ensure that Rivery's IP addresses are whitelisted in your Azure Synapse firewall settings. This is necessary if you're not using an SSH Tunnel. Check the Rivery documentation for a list of IP addresses that need to be whitelisted.
   • Correct Credentials: Verify that the connection settings in Rivery match those required by Azure Synapse. This includes the host, database name, username, and password. Any incorrect detail can prevent a successful connection.
   • Azure Portal Configuration: Make sure that the 'Allow access to Azure services' option is enabled in the Azure portal firewall settings for your Azure Synapse Analytics setup.
   • Test the Connection: Use the 'Test Connection' feature in Rivery to see if the connection settings are correct and the issue persists.
   • Check for Azure Active Directory (AAD) Authentication: If using AAD, ensure that it is correctly configured. Refer to Rivery's guidelines on AAD set up.
   • Review Network and Firewall Logs: Check if there are any blocked requests or unusual activity in your Azure network logs that might indicate connectivity issues.

3. External References:

   • Rivery Documentation: https://docs.rivery.io/docs
   • Microsoft Azure Synapse Connection Guide: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse-connect-overview

If the issue persists or you need further assistance, please open a ticket with Rivery support.