Connecting CRM Online and to a hosted mySQL



I am in the early stage of researching Scribe Insight features. Not sure if anyone has worked with a scenario where by the source is CRM Online, with Scribe Insight installed on one server and the target is on another hosted mySQL database. So in all 3 separate locations. If on premise agent is installed on the hosted mySQL server, can Scribe Insight talk to the on-premise agent? If not, does that mean the mySQL host firewall must be opened for Scribe Insight to connect to?


Thank you for the help.