topic Can the Data Loader Tools - Worksheets be used to load directly to SDE? in Data Loading Tools Questions

Can the Data Loader Tools - Worksheets be used to load directly to SDE?

CristinHolmgren2 — Thu, 16 May 2024 18:07:05 GMT

I have had a lot of success using the data loading worksheets to load from gdb to gdb, but I cannot find any documentation about loading from gdb to SDE using the same worksheets. Is the load to SDE via the worksheets not currently supported? If it is, does anyone have an example of the target path syntax?

Re: Can the Data Loader Tools - Worksheets be used to load directly to SDE?

PatrickGCowan — Fri, 17 May 2024 14:31:35 GMT

Loading to an SDE database via a direct connection to the database is supported. This is done via a connection file. Make a database connection file with the proper credentials and then use that as your target dataset (https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-connection.htm).

For example, in the Target column of a DataReference.xlsx sheet you would use something similar to this path where the DLT.sde is the connection file that you created.

C:\Temp\DLT\DLT.sde\dlt.user.GravityMain

Re: Can the Data Loader Tools - Worksheets be used to load directly to SDE?

CristinHolmgren2 — Fri, 17 May 2024 17:52:29 GMT

Thanks Patrick! I've tried several renditions of the below path and keep getting a 'does not exist or is not supported' error. Anything I might be missing? I've tried with and without the FeatureDataset in the path - Same error.

C:\Temp\PROD @ TESTING.sde\PROD.FeatureDataset\PROD.FeatureClass

Re: Can the Data Loader Tools - Worksheets be used to load directly to SDE?

PatrickGCowan — Fri, 17 May 2024 20:36:36 GMT

I would check that the path for the SDE is correct. You can do this with python by using arcpy.Exists. If the path is valid, it should return True. You may want to look into the permissions and versioning on the SDE connection as well.

arcpy.Exists("C:\Temp\PROD @ TESTING.sde\PROD.FeatureDataset\PROD.FeatureClass")

Re: Can the Data Loader Tools - Worksheets be used to load directly to SDE?

CristinHolmgren2 — Fri, 17 May 2024 21:09:30 GMT

Thanks again. The database is traditionally versioned (has children & grandchildren), but I would like to load the data straight to default. The connection string is connected as the data owner and the Default version. Seems that one issue was that the path was too long. Had success at getting the arcpy.Exists to return true for target and source, but am still getting errors - Runtime errors when tool executes.

Re: Can the Data Loader Tools - Worksheets be used to load directly to SDE?

MikeMillerGIS — Mon, 20 May 2024 15:00:56 GMT

Did you save the username and password in the file?

Re: Can the Data Loader Tools - Worksheets be used to load directly to SDE?

CristinHolmgren2 — Mon, 20 May 2024 15:07:05 GMT

Hi Mike,

Database Connection has User Name and Password saved.

Re: Can the Data Loader Tools - Worksheets be used to load directly to SDE?

CristinHolmgren2 — Thu, 23 May 2024 16:42:30 GMT

After really digging into this, my issue ended up being a GlobalID/GUID issue combined with a path that was too long. I have been able to successfully load into a traditionally versioned SDE, but am now experiencing some issues with the attachments coming through. Attachment table gets populated, relationships look correct, but blobs do not resolve, nor is Pro seeing the feature and its attachments as related, even though the Feature.GlobalID field and Table.REF_GlobalID field match. Maybe the issue is the Feature.GlobalID field is a GUID?

Re: Can the Data Loader Tools - Worksheets be used to load directly to SDE?

MikeMillerGIS — Fri, 24 May 2024 09:17:51 GMT

If the row is coming over, but the blob is not usable, then I suggest you log a bug. Something is not loading correctly with the attachment. Are your attachments photos?

Re: Can the Data Loader Tools - Worksheets be used to load directly to SDE?

CristinHolmgren2 — Tue, 28 May 2024 20:19:38 GMT

Yes. Attachments are photos (mostly), none are working.