Skip to main content
Solved

Use SDE Writer in FME Server

  • May 16, 2017
  • 6 replies
  • 261 views

oscard
Influencer
Forum|alt.badge.img+22

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!

Best answer by david_r

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

6 replies

itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • May 16, 2017

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


oscard
Influencer
Forum|alt.badge.img+22
  • Author
  • Influencer
  • May 16, 2017

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.

 

 


itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • May 16, 2017
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....

 

 


david_r
Celebrity
  • Best Answer
  • May 16, 2017

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.


oscard
Influencer
Forum|alt.badge.img+22
  • Author
  • Influencer
  • May 16, 2017

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.

 

 


david_r
Celebrity
  • May 16, 2017
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.