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 Data Integration. This issue is often due to configuration settings in Azure Synapse or misconfigurations during setup.

2. Action Steps:

   • Whitelist Data Integration IPs: Ensure that Data Integration 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 Data Integration 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 Data Integration 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 Data Integration support.