OAC to onprem MySQL using RDG

Summary

OAC to onprem MySQL using RDG

Content

Hi All, we are trying to establish a connection from OAC to on-prem MySQL (version 5.6) database.
As per OAC documentation, connection to on-prem MySQL is possible only through Remote connectivity Datamodels.
We have successfully configured the RDG and we're getting the XML response back, however, when we change the connection pool to point it to the database(which is installed in the local machine) and deploy the RPD , we don't get any data. The analysis keeps loading and it has a timeout after 15min. Both the OAC and RDG are of version 105.5.