Select to view content in your preferred language

Access FGDB data dynamically from Excel

221
0
09-16-2024 07:08 AM
Status: Open
Labels (1)
Bud
by
Esteemed Contributor

Background: Store geoprocessing outputs in a format accessible to ArcGIS Pro and Excel

Idea: An Excel driver to access file geodatabase data, similar to ODBC, but using the FGDB API. Non-concurrent access, read-only.

Explanation: Need a place to store one-off enterprise geodatabase geoprocessing outputs that can be accessed in Excel by non-GIS staff, as well as in ArcGIS Pro. Unfortunately, there don't seem to be any reputable SQLite Excel drivers for using mobile geodatabases. Further, file geodatabases are Esri's most supported, flagship data type. It would be great to be able to dynamically access FGDB data in Excel instead of making additional copies of the data. The ArcGIS ecosystem is very powerful, but copies of data are where GIS people get into trouble. Microsoft would never create an FGDB driver, so it would have to be made by Esri.

Geoprocessing outputs and file geodatabases are the backbone of ArcGIS Pro. It would be very helpful to have full access to our GP/FGDB data using industry-standard tools like Excel.