nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

In ArcGIS Pro, how do you make an OLE DB connection to a database like you can in ArcCatalog?

CherylTrine

I am using ArcGIS Pro 2.2.1. I have a non-spatial table in a MySQL database that I need to be able to join to a table from a file geodatabase. In ArcCatalog this was done using a separate command (Add OLE DB Connection) and filling in the MySQL database info. I've had it set up for years and it works fine (I don't edit the data, just read it). How do I do it in ArcGIS Pro?

Cheryl

Find more posts tagged with

Accepted answers

All comments

Robert_LeClair

Cheryl - in reviewing the Support Services website about OLE DB - I found this "ArcGIS Pro does not have the functionality to create OLE DB connections to connect to RDBMS databases." Further I found good thread on ArcGIS Ideas here.

CherylTrine

That is very disappointing! Why was that done?

I knew people were upset about something to do with MS Access databases and I had always assumed it had to do with Esri dropping support for personal geodatabases; because I don't use personal geodatabases I hadn't paid much attention. I had not realized that OLE DB for ODBC connections were dropped in Pro!

The MySQL data is used in real-time joins, so transforming and importing is not practical. I only have one table that I have been using this way in GIS currently, but we were planning more. I can see how other organizations could have many connections to such data and this could be quite a hardship. Guess I'll have to stay with ArcMap until I find a solution, or this functionality is brought to Pro. But I can't stay with ArcMap, because I need the Utility Network . . .

That thread is referring specifically to Microsoft Access (accdb) support. If that were solved, would it solve my issue with MySQL? If so, I'll add my use case, but I don't want to be off-topic.

Cheryl

MikeVolz

How about bringing your MySQL data into Pro as a Query layer and then joining it to your GIS data?

Robert_LeClair

It could be that OLE DB connections may be supported in the future for AGP. Perhaps the developers have not yet added the functionality. In addition to the query layer suggestion from Michael, would a database view work for the join?

TedKowal

This is why the upset on dropping the MS Access geodatabase, this affects FAR MORE than Access. The power and speed of MS ACCESS comes with its ability to Link multitudes of various datasources in combination with Geometry. Albeit the Geo-processing is slow, the speed on analyzing and viewing related data from multiple sources as well as its ability to be embedded in Most not all applications makes it a POWERFUL timesaving tool. Those of you who do not use MS Assess as your geodatabase, be advised dropping access has far more reaching affects other than MS Access itself.

Please do put your use case in as well as voting here as well Enable ArcGIS Pro to access ESRI Personal Geodatabases

CherylTrine

The ArcGIS Pro documentation says, "Before you can create a query layer, you must first make a connection to the database." And there's the rub. I expect the same is true for a database view.

My SQL RDBMS experience is limited and I have not worked at all with MySQL; Is there a way to create a query layer or view from the MySQL database that Pro can use that works more or less in real-time?

Robert_LeClair

Hmmm...if your data is in a SQL Server RDBMS, you can make a Database connection to the database via AGP. From there, open the DB connection in AGP, right click on the DB, select New->Database View and create the SQL statement to create the DB view for viewing (and maybe a join - haven't done that before with a DB View). But if you're data is in MS Access, then we're back to square one.

Asrujit_SenGupta

Just suggesting a workaround, incase you would like to try it out:

1. Create a Linked Server connection to the MySQL database from SQL Server (Access MySQL data from SQL Server via a Linked Server)

2. In your SQL Server database, create a View, pulling data from the non-spatial table in MySQL database.

3. Use the View in ArcGIS Desktop.

CherylTrine

This looks interesting. I'll have to check into it. I have not worked with views, yet, so . . . something more to learn!

MarcoBoeringa

Relevant link to a 3rd of April 2019 post by Cole Andrews that suggests ESRI internally already created an enhancement request for this:

https://community.esri.com/ideas/13645-microsoft-access-accdb-support-in-arcgis-pro#comment-72023

bharold

Hi, this doesn't fully answer your question but ODBC connectivity is possible:

https://community.esri.com/community/open-platform-standards-and-interoperability/blog/2019/09/26/using-odbc-data-sources-in-core-arcgis-pro

KoryKramer

+ https://community.esri.com/ideas/17216

ColeAndrews

Posting this update on the OLE DB/ODBC related threads. 2.6!

TMull

Did you ever get MySQL working in Pro?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.