RVR-SYNP-300

1. Issue Summary

   • You're encountering a Failed creating external data source error with Error Code RVR-SYNP-300 while using the Azure Synapse data connector in Rivery. This issue is often due to configuration settings in Azure Synapse or misconfigurations during setup.

2. Action Steps:

   • Whitelist Rivery IPs: Ensure that Rivery IP addresses are whitelisted in Azure, as lack of proper network configurations can cause connection issues. Follow the instructions to whitelist IPs, which involves going into Azure's firewall settings.
   • Check Connection Details: Double-check if your connection settings in Rivery for Azure Synapse are correct. This includes ensuring the correct hostname, database, user credentials, and any custom file zone configurations.
   • Firewall and Permissions: Make sure the Azure Synapse Firewall settings are configured to allow traffic from Rivery and that the user account used for the connection has sufficient permissions.
   • Resource Setup: Verify that you have properly set up an Azure Resource Group and that your Synapse SQL resources are correctly allotted with adequate permissions.
   • Azure Active Directory (Optional): If using Azure Active Directory authentication, ensure it is configured correctly.

3. External References:

   • More on configuring Azure Synapse can be found in the official documentation: Azure Synapse Documentation.
   • Refer to Microsoft Azure's guide on setting up data sources and firewall configurations: Azure SQL Configuration.

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