Hallo

I tried a bit SQL querying on Oracle but found SQLExecutor too limited.
Coming from a traditional procedural programming environment, I still 
have a hard time to get things done as I was used to. Feel like 
handicapped ...

What I did then, was to write a transformer using TCL and accessing
ORACLE directly over ODBC connection. In that way I could do more
on SQL level.

It is quite useful for specialized tasks, but not very flexible ...
and in many ways not really fitting to the FME philosophy ...

Recently I need to access ArcSDE versioned tables and tried 
ArcSDEQuerier which gives even more headache ...

So I am searching in this area too ...

Michael


intelecgeomatic wrote:
> Hi,
> 
> I use FME Workbench and I would like to extract geospatial data from
> Oracle9i according to a nonspatial query. 
> 
> I have one spatial table and some non spatial tables, all related to 
> each others. I would like to use a select query on many non spatial 
> tables to extract a subset of my spatial table. 
> 
> I tryed something with SQLExecutor but it takes too much time to 
> process.
> 
> Any ideas ?
> 
> Thanks
> 
> 
> 
> 
> 
> 
> 
> Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our 
> Professional Services team.  Visit www.safe.com/services for details. 
> Yahoo! Groups Links
> 
> 
> 
>  
> 
> 
> 
> 

-- 
      //   \\   Michael Habarta: Munich/Bavaria/Germany
     //     \\    Mail office: <mailto:[EMAIL PROTECTED]>
    //=======\\     Mail priv: <mailto:[EMAIL PROTECTED]>
   // \/|   | \\     Homepage: <http://people.freenet.de/mhabarta>
  //    |   |  \\       Motto: Romans 8:28




Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our 
Professional Services team.  Visit www.safe.com/services for details. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/fme/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to