Hello,
I am attempting to connect a SQL database to ArcGIS Pro so that changes made to the tables in the SQL database, are seen/automatically made in ArcGIS Pro.
I am working with SQLite v3.
I created a geopackage in ArcCatalog and imported a table into the geopackage in Arc. I was able to connect the geopackage to SQLite and have made edits to the table in SQL. And when I make changes to this table in Arc, I see those changes reflected in the table when I view it in SQL.
But when I make changes in SQL to the table, I cannot see those changes reflected in the table in Arc.
Is there a way that changes made to a table in SQLite are automatically seen in ArcGIS Pro?
I have to ask; what platform are you working in? Arc Catalog / ArcMap or ArcGIS Pro?
I've never used a geopackage, and personally I would follow the online help to make a connection to your SQL Lite db. If you edit your SQL Lite table in the you may need to refresh which ever connection you go with to see the changes.
I am working in ArcGIS Pro (when I said ArcCatalog above I meant Catalog in ArcGIS Pro, sorry that was confusing). I have tried following the online help in the link you sent but ArcGIS Pro wasn't recognizing a .sqlite database.
Some of the things I've attempted:
creating a geopackage (which is the closest I've gotten to getting it to work): https://pro.arcgis.com/en/pro-app/latest/help/data/databases/spatially-enable-sqlilte.htm
https://desktop.arcgis.com/en/arcmap/10.3/manage-data/databases/connect-sqlite.htm
I'm not familiar with Sql Lite. When you are in ArcGIS Pro and make your connection can you actually see the tables and values therein? Is there a driver you may need to install in order for ArcGIS Pro & Sql Lite to play nice together? I had a problem connecting to My Sql sometime back and it turns out there's a bug in ArcGIS Pro that won't let that happen. Not saying that's your issue, but ESRI didn't know about it till I showed them...
When I make the connection I can see the table that I added in ArcGIS Pro. And I can see the tables in the SQL database. But when I, for example, add a column in SQL, I don't see that in ArcGIS Pro even after refreshing. But that's good to know, I'll look into drivers, I hadn't thought of that. If that doesn't work, I'll contact ESRI directly.
I appreciate you helping me out 🙂
Hate to pawn you off to ESRI Tech Support, but at this point it's probably a good call.