Writing spatial data to SQL Server ArcSDE connection.

Question

I am attempting to overwrite a data table within an ArcSDE Geodatabase (Esri's Enterprise Geodatabase in SQL Server) using a workflow in Designer that reads data from a local excel spreadsheet, creates points in NAD27 using lat/long fields in the excel doc, transforms to WGS84, and then overwrites a spatial table within the SDE.  Everything seems to work up to the point of actually writing the data to the SQL Server.

I am attempting to do this using the SQL Server Bulk Loader format because I saw in another post on the Community that this was a viable option for interfacing with an Esri enterprise geodatabase.

The error that pops up every time is "Spatial Objects are not enabled for this Connection."  This seems odd since it is definitely an enterprise geodatabase and stores other spatial data.

Is there something I'm missing here on the SQL and/or Alteryx side of things that I need to enable to allow this type of interfacing?

TrevorS · Answer

Also,

Make sure you are using the correct driver version! If you can, please provide us the current driver version for your SQL Bulk Loader connection (ODBC Data Source Administrator)

TrevorS · Answer

@GIS_Master_J

Your trial license shouldn't be affecting the ability.

I would recommend you try another connector. its been recommended you try SQL Server, or ODBC and OLeDB as these have worked with Spatial Objects.

GIS_Master_J · Answer

Hi @TrevorS

I went through your recommendations and made a few changes to my workflow.

1. The table receiving the data was created in ArcMap and exported to the eGDB, so I didn't make any changes on this point.

2. The UID field in the eGDB uses "OBJECTID" as is standard in Esri geodatabases.  In order to make this match I used the 'Record ID' tool to create a new field named 'OBJECTID' and populated it as integers in series.

3. I renamed my geometry object "SHAPE" to mimic the eGDB schema using the 'Dynamic Rename' tool.

4. I used a series of additional 'Dynamic Rename' tools to ensure that field names match in both the input data and the eGDB table I'm trying toto write to. Additionaly, I am now using the "Delete and append" option.

5. I'm relatively certain that the data I'm attempting to write and the eGDB table are both using WGS84.  I verified this through the 'Browse' map view and the 'Spatial Info' tool.  That said, I am not sure how to check the ESPG code within the 'Output Data' tool.

I am still getting the same message 'Spatial Objects are not enabled for this connection'.

Is it possible that this just isn't available in the trial edition of Designer?