Since the release of ArcGIS Pro my main challenge has been the inability to access my GIS data in Pro, from within Microsoft Access. Access is very popular in my environment (engineering/asset management) and has powerful capabilities to connect to both enterprise and local databases, along with robust yet simple tools for querying, reporting and automating.
This issue is actually a much broader issue than access. It's the inability to access an ESRI geodatabase from within a 3rd party software (without purchasing an ArcGIS Server license). ESRI has not provided a long requested ODBC for the FGDB; does not provide editing capabilities for sqlite (fully available in qGIS); has removed support for the PGDB format within Pro; to my best knowledge has removed support for editing a SQL-Express "desktop GDB" within Pro; and requires a server license for SQLServer/Oracle/PostGressql. Numerous "ArcGIS Ideas" relate to this issue and remain open (some links below).
It only recently occurred to me, that the shapefile actually does all of this! This simple and outdated format is accessible from basically any 3rd party software. Microsoft Access has even renewed support for the underlying .dbf format , to a large extent at the requests of the GIS community (link below).
What I learn from this is the importance of open formats and the open source community.
My messages to ESRI are two:
1. The importance of open formats. ESRI has provided the community with the .shp format, and its openness proves to be invaluable even today. Please don't leave the FGDB a silo.
2. It seems that ESRI is focusing too much on the organizational level. My (huge) organization actually is based on the ArcGIS Eneterprise architecture; yet this platform is not typically accessible to end-users like myself for desktop analysis and development. But it is us, the end-users, who eventually drive the organization forward; it is our initiatives that grow into enterprise solutions, and we need powerful and flexible tools to do so.
Relevant "ArcGIS Ideas":
Microsoft Access DBF Support is back
Even the FGDB format is not open there is a free library that can read and update it (simple features).
Look here: File Geodatabase API details | ArcGIS Blog
It is true that for many non ESRI software it is easier to keep using the shape files and not implement this library but it is possible.
Are you refering to the solution mentioned here?
This still means that I have to manage this through arcmap, and I can't find any documentation indicating if this will or won't be supported in future in PRO releases.
My understanding is SQL Express workspaces are supported because the same technology is used across all SQL Server clients. The best way to get the functionality you want into Pro is to get an Ideas post up there and voted on.
Bruce Harold wrote:
SQL Express is supported by Pro, but you have to make the database connection file in 10.x.
Please vote on the ideas you reference.
Really? Have you had experience with this? I cannot connect to SQL Server Express "Desktop" Geodatabases in Pro 2.4.1. If you have other information on how to do this please share. I am already connected to the database in ArcCatalog/ArcMap 10.7.1.
No - it is not a connection issue being discussed. Editing requires special licensing with all flavors of SQL server including express. The only way you can use express is if you are willing to overwrite your complete Feature Class/Table each and every time changes made to the data because editing is not allowed with your standard ArcGIS license. This issue here is ESRI removing various open formats that are in use with 90% of business processes like MS Access (more prevalent with smaller operations).