Skip to main content

Hi.

I have a workspace that uses the ArcSDE Writer. It works perfectly in my FME Desktop, because I have ArcGIS installed in the same machine.

But now I have to upload it to a FME Server. In that machine, there is not any ArcGIS installation and I've been told that there is no plan of installing one. So... my workspace won't work.

I'm aware of the ArcGIS Legacy writer, but it's an option that they don't want to use due to its lack of maintenance.

So... is there any other solution? I've been searching in this forum and I haven't found anything else.

Thanks for any help provided!

Not really....you can write to a fdgb and then write it using the ESRI application, not very direct but could work.


Not really....you can write to a fdgb and then write it using the ESRI application, not very direct but could work.

Thanks for the answer. I was afraid of something like that.

 

 

Maybe I will have to drop the ArcSDe Writer and use the SQL Server Writer instead. And cross my fingers that everything stay as it should be.

 

 


Thanks for the answer. I was afraid of something like that.

 

 

Maybe I will have to drop the ArcSDe Writer and use the SQL Server Writer instead. And cross my fingers that everything stay as it should be.

 

 

You can always try....just make sure all fingers are crossed....

 

 


In principle you will need a valid and licensed ArcGIS installation to write to an ArcSDE Geodatabase.

But in practice it depends on what you need to write. If you only need to write attributes, you can use the native writer for the underlying SDE database, e.g. SQL Server.

If you need to write geometries it is slightly more complicated, but it depends on your geometries and how they are stored in the database. If your geometries are stored as spatial objects native to your database (e.g. SQL Server Spatial), you can probably use that writer to write directly into the table on which your feature class is based. Just be aware that any SDE specific attributes such as extents may or may not automatically be updated. Important: If you're inserting data you will also have to make sure to use the SDE-based generator for OBJECTID values, otherwise you may experience collisions later, see http://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/next-rowid.htm

If you need to write data into SDE-specific datasets, e.g. versioned tables, it's going to be a lot more complicated/not feasible.

If you can tell us a bit more about your exact requirements it would be easier to give more concrete advice.


In principle you will need a valid and licensed ArcGIS installation to write to an ArcSDE Geodatabase.

But in practice it depends on what you need to write. If you only need to write attributes, you can use the native writer for the underlying SDE database, e.g. SQL Server.

If you need to write geometries it is slightly more complicated, but it depends on your geometries and how they are stored in the database. If your geometries are stored as spatial objects native to your database (e.g. SQL Server Spatial), you can probably use that writer to write directly into the table on which your feature class is based. Just be aware that any SDE specific attributes such as extents may or may not automatically be updated. Important: If you're inserting data you will also have to make sure to use the SDE-based generator for OBJECTID values, otherwise you may experience collisions later, see http://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/next-rowid.htm

If you need to write data into SDE-specific datasets, e.g. versioned tables, it's going to be a lot more complicated/not feasible.

If you can tell us a bit more about your exact requirements it would be easier to give more concrete advice.

Thanks for your answer!

 

 

I need to write geometries; but, if I'm doing it properly, I'm storing spatial objects native to the SQL Server database.

 

 

This is one of the tables I'm writing:

 

 

 

There is not versioning, or archiving or attachments... so I'm optimistic about the SQL Server Writer.

 

 


Thanks for your answer!

 

 

I need to write geometries; but, if I'm doing it properly, I'm storing spatial objects native to the SQL Server database.

 

 

This is one of the tables I'm writing:

 

 

 

There is not versioning, or archiving or attachments... so I'm optimistic about the SQL Server Writer.

 

 

So the probability of the SQL Server Spatial writer working should be pretty good. I recommend you make a full backup of the table before testing, however.

 

 


Reply