a bit of literature<\/a> on the software.[\/RANT]<\/p>\nAnyhow, GeoMedia Fusion is a great tool for doing data cleanup, attribute validation, and conflation. The schema remodeler utility comes with GeoMedia Fusion and is a stand alone utility that provides you with the ability to migrate data from one source to another and to bulk export from the GeoMedia environment. For those that have heard of Intergraph’s Data Warehousing Tools, the schema remodeler utility is the re-branded (and enhanced) Data Warehousing Tools. Schema Remodeler is one of my favorite Intergraph tools and I almost always use it at least once a week.. As of late I’ve set it up to take my Trimble GPS text files and load them into my Oracle Locator database. In the schema remodeler utility, you can do a number of things including re-mapping and reordering columns from one source to another (think migrating a database from Access to Oracle or SQL Server); exporting a seamless Access feature class into a gridded Bentley Microstation V7 environment; and updating columns using functional attributes, creating a subset of the the data using temporal and attribute queries, and modifying the source geometry using an analytical merge so you can export the Oracle data to create a shapefile (all in one transaction).<\/p>\n
When you look at the functionality of Schema Remodeler, it’s really pretty amazing at how much you can do with the utility. Now, how do I compare it to FME? It’s hard to say as I’ve used Schema Remodeler off and on for the last five years and I’ve only use FME a handful of times. In my eyes, they both attempt to do similar things. The biggest difference in my eyes has to do with the number of file formats supported (Schema Remodeler only supports the standard GM data server while FME supports at least 150 different GIS data types) and how detailed you need to get. Schema Remodeler is great for many things, however it’s only a utility. FME on the other hand is a complete software solution. Its so goal is “spatial ETL (E<\/strong>xtract, T<\/strong>ransform, and L<\/strong>oad”. It should also be mentioned that since you can’t buy Schema Remodeler by itself (it only comes with GeoMedia Fusion), FME is actually quite a bit cheaper than Schema Remodeler. So, if you’re looking exclusively for “spatial ETL” functionality, I personally would go with FME. However if you need to do some pretty advanced conflation, a lot of automated data cleanup, and attribute validation, you really should be looking at GeoMedia Fusion. If you do that, it’s really nice to know that Schema Remodeler comes as part of Fusion and may answer many of your ETL needs.<\/p>\n","protected":false},"excerpt":{"rendered":"With the last blog post on Safe Software’s FME suite, I would be remiss to not discuss Intergraph’s own Schema…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[3,4],"tags":[],"acf":[],"yoast_head":"\n
Intergraph Schema Remodeler - jeffhobbs.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jeffhobbs.com\/?p=301\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Intergraph Schema Remodeler - jeffhobbs.com\" \/>\n<meta property=\"og:description\" content=\"With the last blog post on Safe Software’s FME suite, I would be remiss to not discuss Intergraph’s own Schema...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jeffhobbs.com\/?p=301\" \/>\n<meta property=\"og:site_name\" content=\"jeffhobbs.com\" \/>\n<meta property=\"article:published_time\" content=\"2008-07-02T04:41:53+00:00\" \/>\n<meta name=\"author\" content=\"Jeff Hobbs\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Hobbs\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jeffhobbs.com\/?p=301\",\"url\":\"https:\/\/jeffhobbs.com\/?p=301\",\"name\":\"Intergraph Schema Remodeler - jeffhobbs.com\",\"isPartOf\":{\"@id\":\"https:\/\/jeffhobbs.com\/#website\"},\"datePublished\":\"2008-07-02T04:41:53+00:00\",\"dateModified\":\"2008-07-02T04:41:53+00:00\",\"author\":{\"@id\":\"https:\/\/jeffhobbs.com\/#\/schema\/person\/600c6cc6bd115876f071a9bfb5c934d7\"},\"breadcrumb\":{\"@id\":\"https:\/\/jeffhobbs.com\/?p=301#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jeffhobbs.com\/?p=301\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jeffhobbs.com\/?p=301#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jeffhobbs.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Intergraph Schema Remodeler\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jeffhobbs.com\/#website\",\"url\":\"https:\/\/jeffhobbs.com\/\",\"name\":\"jeffhobbs.com\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jeffhobbs.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/jeffhobbs.com\/#\/schema\/person\/600c6cc6bd115876f071a9bfb5c934d7\",\"name\":\"Jeff Hobbs\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jeffhobbs.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/bafb9a6abd79509b50a190d399dea779?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/bafb9a6abd79509b50a190d399dea779?s=96&d=mm&r=g\",\"caption\":\"Jeff Hobbs\"},\"sameAs\":[\"http:\/\/jeffhobbs.com\"],\"url\":\"https:\/\/jeffhobbs.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Intergraph Schema Remodeler - jeffhobbs.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jeffhobbs.com\/?p=301","og_locale":"en_US","og_type":"article","og_title":"Intergraph Schema Remodeler - jeffhobbs.com","og_description":"With the last blog post on Safe Software’s FME suite, I would be remiss to not discuss Intergraph’s own Schema...","og_url":"https:\/\/jeffhobbs.com\/?p=301","og_site_name":"jeffhobbs.com","article_published_time":"2008-07-02T04:41:53+00:00","author":"Jeff Hobbs","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jeff Hobbs","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/jeffhobbs.com\/?p=301","url":"https:\/\/jeffhobbs.com\/?p=301","name":"Intergraph Schema Remodeler - jeffhobbs.com","isPartOf":{"@id":"https:\/\/jeffhobbs.com\/#website"},"datePublished":"2008-07-02T04:41:53+00:00","dateModified":"2008-07-02T04:41:53+00:00","author":{"@id":"https:\/\/jeffhobbs.com\/#\/schema\/person\/600c6cc6bd115876f071a9bfb5c934d7"},"breadcrumb":{"@id":"https:\/\/jeffhobbs.com\/?p=301#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jeffhobbs.com\/?p=301"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jeffhobbs.com\/?p=301#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jeffhobbs.com\/"},{"@type":"ListItem","position":2,"name":"Intergraph Schema Remodeler"}]},{"@type":"WebSite","@id":"https:\/\/jeffhobbs.com\/#website","url":"https:\/\/jeffhobbs.com\/","name":"jeffhobbs.com","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jeffhobbs.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/jeffhobbs.com\/#\/schema\/person\/600c6cc6bd115876f071a9bfb5c934d7","name":"Jeff Hobbs","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jeffhobbs.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/bafb9a6abd79509b50a190d399dea779?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bafb9a6abd79509b50a190d399dea779?s=96&d=mm&r=g","caption":"Jeff Hobbs"},"sameAs":["http:\/\/jeffhobbs.com"],"url":"https:\/\/jeffhobbs.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=\/wp\/v2\/posts\/301"}],"collection":[{"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=301"}],"version-history":[{"count":0,"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=\/wp\/v2\/posts\/301\/revisions"}],"wp:attachment":[{"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}