topic Re: ArcGIS Pro Connect to MySQL database via OLE DB connection in ArcGIS Pro Questions

ArcGIS Pro Connect to MySQL database via OLE DB connection

KieranClark — Tue, 20 Apr 2021 17:02:31 GMT

I've found some old threads talking about the difficulty connecting to a MySQL and I was wondering if it's even possible to connect to MySQL directly in ArcGIS Pro these days.

I've created a data source on my computer, but when I go to add an OLE DB connection in ArcGIS Pro, I don't even have the option to select the MySQL ODBC driver.

Is there a setting or plugin/addon I'm missing that would let me do this? I would really rather not have to migrate our database to PostgreSQL if I can avoid it.

Re: ArcGIS Pro Connect to MySQL database via OLE DB connection

JoeBorgione — Tue, 20 Apr 2021 17:09:08 GMT

If you follow this link you'll not see mySql as a supported database. I have used stand alone python to connect to a mySql db and with arcpy copy various tables into an ArcGIS file geodatabase.

Re: ArcGIS Pro Connect to MySQL database via OLE DB connection

KieranClark — Tue, 20 Apr 2021 17:25:37 GMT

Yeah, I was just hoping there was some sort of workaround. Looks like we'll be moving to PostgreSQL. Not a big deal as there are really good migration tools out there but it would be nice if Esri supported MySQL as well. I feel like it's common enough to warrant compatibility.

Re: ArcGIS Pro Connect to MySQL database via OLE DB connection

MichaelVolz — Tue, 20 Apr 2021 17:45:29 GMT

Do you currently connect ArcMap to MySQL via an ODBC connection and you're trying to migrate that workflow to Pro? Or is this a new setup just in Pro?

Re: ArcGIS Pro Connect to MySQL database via OLE DB connection

KieranClark — Fri, 23 Apr 2021 18:59:08 GMT

I was actually able to find a way to make this work!

I had completely misunderstood what the Microsoft OLE DB Provider for ODBC Drivers was for. If I choose that option and select the MySQL data source that I made through MySQL's OLE DB connection it all works.

I guess that option is like a wrapper or whatever to allow connections to other types of database. So if you're in my situation and need to connect to a MySQL server, try the "Microsoft OLE DB Provider for ODBC Drivers" option!

Re: ArcGIS Pro Connect to MySQL database via OLE DB connection

JoeBorgione — Fri, 23 Apr 2021 19:00:40 GMT

Great Tip @KieranClark ! Thanks!

Re: ArcGIS Pro Connect to MySQL database via OLE DB connection

JoeBorgione — Wed, 05 May 2021 17:26:28 GMT

@KieranClark : I followed your advice as well as post from @KenGalliher1 and I've established a MySQL connection through ArcGIS Pro (2.7.1) but I get an error when I try to add a table to my ArcGIS Pro session:

I can get to this data base (which is web hosted) using WorkBench without any problem.

Any ideas?

Re: ArcGIS Pro Connect to MySQL database via OLE DB connection

InokaW — Tue, 18 May 2021 13:39:17 GMT

how can I add OLE DB connection in Arc GIS Pro 2.4 ?? any methods??

Re: ArcGIS Pro Connect to MySQL database via OLE DB connection

InokaWijekoon — Thu, 20 May 2021 11:52:57 GMT

any add-ins or arcpy packages?

Re: ArcGIS Pro Connect to MySQL database via OLE DB connection

JoeBorgione — Fri, 25 Jun 2021 21:40:49 GMT

If anyone is still following this post or comes across it, the problem I describe is now a listed as a bug when connecting to MySql ver8.

BUG-000141014