Skip to main content
Question

Geomedia queries in FME


Hi everyone,

 

 

We have a tool in Geomedia compriosed of a set of (complicated) queries and due to Geomedia's limitations to run the tool, we are thinking of applying FME.

 

 

Is there any way not to need to recreate these queries from scratch on FME? Any chance we can import queries to FME or possibly through the library feature in Geomedia in which we can store the queries there?

 

 

Thanks

2 replies

takashi
Influencer
  • May 20, 2013
Hi,

 

 

Since I have no experiences on Geomedia, this is only by guess: According to the FME documentation, Geomedia dataset is stored as Access or SQL Server database. So, SQLCreator or SQLExecutor transformer may be available to execute the queries. I think probably attributes can be read with SQLCreator / SQLExecutor, but I'm not sure whether those work to read geometries. When those cannot read geometries, it may be possible to read separately geometries (using Geomedia Reader) and attributes (executing queries), then merge them (FeatureMerge).

 

 

Hope this helps.

 

Takashi

fmelizard
Safer
Forum|alt.badge.img+18
  • Safer
  • May 20, 2013
Hi,

 

 

As Takashi mentions you can input the queries to the SQL creator or  SQL executor. The advantage of the SQL executor is that you can save the queries externally (text file) and have more flexibility/control over SQL syntax.

 

Hope this helps.

Reply


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