Real Time Intelligence Connection issue with MySQL DB CDC

[Parthiban006]

We have set up an on-premises data gateway to connect AWS RDS MySQL within a VPC. Using this gateway, we successfully fetch data from Fabric Data Factory pipelines, and the connection is working as expected.

To achieve real-time synchronization, we configured the MySQL CDC connector in Real-Time Hub, using the same connection that was previously set up for data loading. However, when attempting to establish the connection, we encounter the following error:

"Property 'username's value '' is invalid."

We are attaching a screenshot for reference

[v-sathmakuri]

Hi @Parthiban006 ,

I hope this information proves helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.

Thank you!!

[v-sathmakuri]

Hi @Parthiban006 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-sathmakuri]

Hi @Parthiban006 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft · Accepted solution]

Hi @Parthiban006 

Thank you for reaching out to Microsoft Fabric Community.

Below steps might help in resolving the issue :

• Go to the CDC connector settings in Real-Time Hub and explicitly enter the username and password, even if the connection was previously set up.
• Ensure that the on-premises data gateway is correctly configured and that Real-Time Hub is using the right connection.
• If using a connection string, verify that the username is correctly formatted (ex: user=root or UID=root).
• MySQL user must have REPLICATION SLAVE and REPLICATION CLIENT permissions for CDC to work.
• If the issue persists, review the logs to see if there are any additional authentication failures.

After applying these steps, retry the connection and see if it resolves the issue.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

[Parthiban006]

If we have a MySQL DB inside a private network we can't able to perform this operation as per the prerequisites in the documnet and attached the screenshot for your reference. Is there any alternate solution to acheive this? 

[v-sathmakuri]

Hi @Parthiban006 ,

Yes, Real-Time Hub doesn’t support private network access. Here is one alternate solution.

Implement near real-time sync using high-frequency scheduled Copy Activities or Data Flows in Fabric Data Factory, leveraging a watermark column (like a timestamp or ID) to capture only the incremental changes.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!