topic How to use ArcGIS Pro with SQLite in ArcGIS Pro Questions

How to use ArcGIS Pro with SQLite

LarsLarsen — Fri, 30 Jan 2015 10:44:44 GMT

As far as I can see there is no direct support for SQLLite in Pro. Is that a planned feature ? Can I access SQLite through phyton and import data as layers that way?

Re: How to use ArcGIS Pro with SQLite

JoshuaBixby — Fri, 30 Jan 2015 18:07:16 GMT

I think Esri would agree, i.e., SQLite isn't currently fully supported in ArcGIS Pro.

Although "seeing" SQLite databases isn't possible through the Project pane/window, you can load SQLite databases using the Make Feature Layer tool either through the GUI or ArcPy. At least during beta testing, Spatialite-based spatial data wouldn't load because the correct DLLs weren't packaged with the installer, not sure if that changed. I have successfully loading ST_Geometry and GeoPackage spatial data into ArcGIS Pro.

Re: How to use ArcGIS Pro with SQLite

LarsLarsen — Mon, 02 Feb 2015 08:25:02 GMT

Just tested the Make Feature Layer Tool on version 1.0 and it does not see sqlite as a valid data source in the GUI. I could also not make it work using scripting directly, but that could be for other reasons as the error message is quite generic.

Strange though, because looking in the Pro folder structure both sqlite3 and ST_Geometry dlls are distributed with Pro.

Re: How to use ArcGIS Pro with SQLite

JoshuaBixby — Mon, 02 Feb 2015 14:32:07 GMT

Are you trying to load spatial data or just a table? Was the SQLite database created by ArcGIS Desktop or some other application? If the latter, try making a SQLite database from ArcGIS Desktop and putting some data in it, and then see if ArcGIS Pro sees that database, especially if working with spatial data.

Re: How to use ArcGIS Pro with SQLite

LarsLarsen — Mon, 02 Feb 2015 14:39:06 GMT

Thanks Josh, I am trying both simple table and spatial data. Also tried to start of with a SQLite created by ArcGIS. It doesn't make any difference. In the GUI neither the extension .sqlite or .gpkg is recognized in pro, but works fine in ArcMAp 10.3 with the same tools.

Re: How to use ArcGIS Pro with SQLite

JoshuaBixby — Mon, 02 Feb 2015 15:35:03 GMT

The tool won't "see" the SQLite database for the same reason the Project pane doesn't; however, the tool works with them. Don't rely on the tools Browse button, fully specify the path to the table in the SQLite database in the Input Features text box.

Re: How to use ArcGIS Pro with SQLite

LarsLarsen — Thu, 05 Feb 2015 12:41:08 GMT

I have tried almost every combination for entering the SQLite path and feature class as input argument to the tool. Both in GUI and from Py scripting. The py script tests OK in ArcMap but not in PRO. PRO will give me and 'unsupported or does not exist' error message.

Josh, did you succeed with this method in the release version of PRO?

Re: How to use ArcGIS Pro with SQLite

AsrujitSengupta — Thu, 05 Feb 2015 13:09:34 GMT

As far as I know, the below workspaces are not yet supported with ArcGIS Pro:

Enterprise Databases (Netezza, Teradata, SQLite)
SQLite GDB (only supported as part of map packages and offline editing)

Presently supported Workspaces should be --

File Geodatabase
Compressed File Geodatabases
Feature Service Layers
Enterprise Geodatabases (Oracle, SQL Server, PostgreSQL, DB2)

Re: How to use ArcGIS Pro with SQLite

JoshuaBixby — Sat, 11 Dec 2021 12:08:45 GMT

I am using ArcGIS Pro 1.0.0. Yes, it works, I tested it before posting the other day. I just tested it again, and it worked without any issues:

arcpy.MakeFeatureLayer_management(r"D:\tmp\test.sqlite\webMerc1","webMerc")
<Result 'webMerc'>

It is helpful if you can post specific code and error messages, especially since it keeps not working for you.

I am not sure what is different between our machines. I recently re-imaged my machine using Windows 7 64-bit Enterprise Edition. I installed ArcGIS 10.3 before I got around to putting ArcGIS Pro on the machine, but the installations should be compartmentalized from each other. Anyhow, I was loading SQLite databases into Pro with the beta versions and pre-releases before I re-imaged my machine.

Have you tried creating a layer file in ArcGIS Desktop that points to a SQLite data source and then load that layer file into ArcGIS Pro?

As has been pointed out, SQLite isn't officially supported yet, so the best approach in the interim might be to find an alternate data store.

Re: How to use ArcGIS Pro with SQLite

LanceShipman — Thu, 12 Feb 2015 20:37:08 GMT

Sqlite, SpatiaLite and GeoPackages are not supported in Pro 1.0. They didn't make the cut. We are trying to get them into Pro 1.1.

Regards,

Lance Shipman

Geodata Product Engineer, File Geodatabase, Sqlite, Shapefile

Esri, Redlands, California

Re: How to use ArcGIS Pro with SQLite

BradleyAndrick3 — Wed, 30 Aug 2017 18:42:12 GMT

Is there any update on this? I would like to open a sqlite geodatabase (a ".geodatabase" file) in ArcMap or ArcGIS Pro. Is this possible?

Thanks,

Brad

Re: How to use ArcGIS Pro with SQLite

LanceShipman — Wed, 30 Aug 2017 18:56:29 GMT

Sqlite, SpatiaLite and GeoPackages are supported in Pro. Mobile Geodatabases (.geodatabase) support is being considered for a later release, but not in the Pro 2.1 currently under development.

Lance

Re: How to use ArcGIS Pro with SQLite

JoshuaBixby — Wed, 30 Aug 2017 19:52:39 GMT

I think mobile geodatabases (.geodatabase) are great, SQLite meets geodatabase. Does Esri have plans to support native access within the desktop clients instead of having to convert back and forth between file geodatabases?

Re: How to use ArcGIS Pro with SQLite

MalcolmMeyer — Wed, 13 Dec 2017 18:27:06 GMT

Confirmed. I have successfully created both a Spatialite and GeoPackage database. However, I cannot edit the data...getting a 'not registered in the Database' error. I try to register the data and that also errors out. Is it possible to edit SQLite databases in Pro, and if so how does one do this?

Re: How to use ArcGIS Pro with SQLite

LanceShipman — Wed, 13 Dec 2017 18:31:28 GMT

Editing SQLite data is not currently supported in ArcMap or Pro. We are looking at it for a later (post 2.1) release.

Lance

Re: How to use ArcGIS Pro with SQLite

MalcolmMeyer — Wed, 13 Dec 2017 18:38:11 GMT

Great. It would be helpful to have that clarified either here - Supported data types and items—ArcGIS Pro | ArcGIS Desktop or here - Work with SQLite databases in ArcGIS Pro—Help | ArcGIS Desktop, would have saved me asking in this forum.

Re: How to use ArcGIS Pro with SQLite

AZendel — Tue, 30 Apr 2019 15:52:20 GMT

Still doesn't look like SQLite is editable in Pro 2.3. Any news/speculation about future releases?

Re: How to use ArcGIS Pro with SQLite

ThomasColson — Tue, 30 Apr 2019 17:48:58 GMT

I don't think there's going to be any rush for sqlite support anytime soon. Many organizations are blocking it from the network, too many security holes.

https://www.cvedetails.com/vendor/9237/Sqlite.html

Re: How to use ArcGIS Pro with SQLite

JoshuaBixby — Tue, 30 Apr 2019 19:26:08 GMT

Let's not advertise then that GeoPackage is built on top of SQLite.

In defense of SQLite, it isn't any more prone to issues than most software, and the group behind SQLite does address vulnerabilities fairly quickly. If having CVE entries was sufficient to block software from the network, I am not sure how many applications would remain on the network.

Re: How to use ArcGIS Pro with SQLite

ThomasColson — Tue, 30 Apr 2019 20:29:02 GMT

There was something specific about one of the entries, and how it was fixed (or not), that put it in "jail".