How to Connect Mysql with Arc GIS Enterprise

Question

We have our own mysql database in which the latitude and longitude of different entities are collected on a daily basis. We want to associate it with ArcGIS Enterprise. If yes, then please guide us. If this is not possible, then let us know which database is best with ArcGIS Enterprise and how we were able to transfer our data to it on a daily basis.

Scott_Tansley · Answer

Hi,

MySQL isn't a supported database.  The list of database technologies that are supported can be found here:  https://enterprise.arcgis.com/en/server/latest/manage-data/windows/dbms-support.htm

If you're looking at free database technologies then consider PostgreSQL.

https://enterprise.arcgis.com/en/server/latest/manage-data/windows/dbms-support.htm#GUID-1643CA16-F20D-46CF-B661-A2B43950084E

Your questions sounds as if the Latitude is stored in one field and the longitude in the other, though I am making assumptions.  That is not optimal.  The data needs to be in a geometry or geography field.

There are many ways of migrating data from one database to another.  Many would use FME or Python as a start point.

I hope this helps.

Scott

https://www.geoworx.co.nz