Skip to main content
Question

SQL Table to SQL SDE Featured DataSet


I'm new, so any help is appreciated. I have a SQL table that has lat/longs.  Want to copy table into SQL Server SDE feature dataset with geom column.  Tried the feature writer, but don't see where I can select the feature dataset.

4 replies

dustin
Influencer
Forum|alt.badge.img+30
  • Influencer
  • January 17, 2024

First step will be creating the geometry from the coordinate lat/long. That can be done with the VertexCreator. If it's only points, that's all you should need. If it's lines or areas, you can use transformers like the LineBuilder or AreaBuilder after that. If you have more specific information about the schema of your input table and the desired geometry, we can provide a little more direct advice.


  • Author
  • January 17, 2024

I've got that, and was able to write the table with GEOM to destination SQL Server SDE. My problem is how do I get it into the FeatureDataSet?


srinivasgg
Contributor
Forum|alt.badge.img+5
  • Contributor
  • January 18, 2024

Hi,

I understand that you are able to write it into sde, then that's it. The features supposed to reflect in feature dataset where you can be able to visualise in ESRI's catalogue.

Guess it is clear!


david_r
Evangelist
  • January 18, 2024

The Feature Dataset name can be specified as part of the Feature Type name with the following syntax:

<Feature Dataset>/<Feature Class>

It's described here in the manual:https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/geodatabase/feature_dataset.htm


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings