topic Re: Connecting SQLite and ArcGIS Pro in Geodatabase Questions

Connecting SQLite and ArcGIS Pro

GloriaDesanker — Thu, 05 Aug 2021 05:37:59 GMT

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?

Re: Connecting SQLite and ArcGIS Pro

JoeBorgione — Thu, 05 Aug 2021 14:56:01 GMT

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.

Re: Connecting SQLite and ArcGIS Pro

GloriaDesanker — Thu, 05 Aug 2021 16:04:24 GMT

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:

https://pro.arcgis.com/en/pro-app/latest/help/data/databases/work-with-sqlite-databases-in-arcgis-pro.htm

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

Re: Connecting SQLite and ArcGIS Pro

JoeBorgione — Thu, 05 Aug 2021 16:24:52 GMT

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...

Re: Connecting SQLite and ArcGIS Pro

GloriaDesanker — Thu, 05 Aug 2021 18:45:34 GMT

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 🙂

Re: Connecting SQLite and ArcGIS Pro

JoeBorgione — Thu, 05 Aug 2021 18:48:00 GMT

Hate to pawn you off to ESRI Tech Support, but at this point it's probably a good call.