Apologies if this is a dumb question.
I have some programs that utilize MySQL to store data that I would like to use in some ArcGIS Online services. I have an ArcGIS Server set up on our network that I use to host data and services to use in AGOL.
I'm able to create a connection in Arc Catalog to our MySQL database and use that data in ArcMap to do whatever. But what I want to do is share a map as a service for AGOL using this MySQL data, but that seems to be an issue. I registered my OLEDB connection in server manager and the service publishes just fine, but nothing works from that point. I make a map with the service and the pop-ups won't work and no data comes up in a data grid. Clearly something is amiss. Does the MySQL server need to be configured differently?
I'm perfectly open to NOT connecting directly to MySQL if that's just not possible for my situation, but I need to figure out an alternative. Is it possible to automate converting a MySQL table to a table in the GIS nightly? Is there a better way to achieve what I'm trying to do?
I'm using ArcGIS 10.6.1
For reference I have an old application I wrote that maintenance guys use to enter their work on water lines. Obviously this uses a MySQL back end. I want to associate this work history with line segments in a web map so they can see where work has been done.