Connecting SQLite and ArcGIS Pro

1893
5
08-04-2021 10:37 PM
Labels (1)
GloriaDesanker
New Contributor II

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?

Tags (3)
0 Kudos
5 Replies
JoeBorgione
MVP Emeritus

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.

That should just about do it....
0 Kudos
GloriaDesanker
New Contributor II

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

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

 

0 Kudos
JoeBorgione
MVP Emeritus

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

That should just about do it....
GloriaDesanker
New Contributor II

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 🙂

0 Kudos
JoeBorgione
MVP Emeritus

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

That should just about do it....
0 Kudos