I'm migrating spatial data from AutoCAD (hosted in an Oracle database) to a SQL Server(ESRI geodatabase). I want to automatically extract domain values from Oracle lookup tables and populate them as domains in the SQL Server (EGDB) without using ESRI tools (like ArcGIS or ArcPy). Is there a way to automate this process, and what would be the recommended approach?
+40- Influencer
You could use Generate workspace reading all Oracle tables and specifying the writer as SQL Server. However as you clearly ask for creating domains, you’ll instead need the SDE writer format.
Domains in FME are created on the writer feature type under User Attributes. You select the type = domain for the data type. Here is a getting started article https://support.safe.com/hc/en-us/articles/25407778497421-Working-with-Geodatabase-Domains-Writing-A-Coded-Domain It assumes you already set up a domain on the SDE end… however I thin you can create domains populating the “coded domain” parameter dialogue.
There are a few limitations in regard to domain writing. read this section as well !
You’ll need to use transformers like AttributeValueMapper
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.