Oracle Analytics Cloud and Server

Products Banner

OAC to onprem MySQL using RDG

Received Response
81
Views
2
Comments

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.
Has anyone faced the this issue before or have any thoughts on how to resolve this issue?
 

Version

MySQL5.6

image.png

Answers