RVR-MSS-821

1. Issue Summary

   • The error code RVR-MSS-821 indicates a "Connection missing field" problem with the Azure SQL data connector within Data Integration. This error suggests that a necessary connection field has not been provided or is improperly configured. Initial diagnosis points to a missing or incorrect input required for establishing a proper connection to Azure SQL.

2. Action Steps:

   • Verify Connection Credentials: Ensure all required fields for the Azure SQL connection are provided. Typically, this includes:
     • Server name
     • Database name
     • User name
     • Password
   • Check Firewall Settings: Configure Azure SQL firewall settings to allow connections from the Data Integration platform. Ensure Data Integration IP addresses are whitelisted.
   • Review Connection Configuration: Double-check the correctness of each input needed during the connection setup in Data Integration.
   • Test the Connection: Use the "Test Connection" feature in Data Integration to validate that all the inputs are correct and that there are no connection blockages. Adjust any parameters if necessary and retest.

3. External References:

   • Data Integration Documentation on Azure SQL Connection for detailed steps on setting up the Azure SQL connection.
   • Azure SQL Database Connectivity Architecture for general information on setting up access and firewall configurations for Azure SQL.

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