Intergraph G/Technology Oracle Database

DavidBrett

Anyone have any insight on exporting or directly linking into an Intergraph G/Technology Oracle database via ArcGIS with Data Interoperability Extension?

I created a spatial view and link as outlined here with no success:
http://fmepedia.safe.com/articles/Samples_and_Demos/Oracle-Spatial-Object#heading_toc_j_2

DavidBrett

Roxana,

I use the SQLCreator in FME to run SQL statements. This way is much faster and seems to be more reliable. The nice thing about using a SQL statement is you can review the results in TOAD, SQL Developer, etc. prior to running the extract in FME.

FME_SQL_DELIMITER ;
--********************************************************
--Filename: GTechFME_Elec_Breaker.sql
--Purpose: For use in SQL Extractor Transformer in FME
--Author: 
--Date: 20141113
--********************************************************


Select 
  b.G3E_FNO
  , b.G3E_FID
  , b.G3E_CNO
  , b.G3E_CID

  , round(GETELEMANGLE(feature.G3E_GEOMETRY)*(57.2958),2) Angle
  , to_char(SYSDATE, 'YYYYMMDD') as "ExtractDate" 
FROM  
    pecoprod.b$breaker_pt feature
    , pecoprod.b$breaker_n b
    , pecoprod.b$common_n comm
    , PECOPROD.B$CONNECTIVITY_N conn
Where
  comm.g3e_fid = feature.G3E_FID
  and feature.g3e_fid = b.G3E_FID
  and feature.g3e_fid = conn.G3E_FID
  and feature.ltt_id=0 and comm.ltt_id=0 and conn.ltt_id = 0 and b.ltt_id = 0
  and comm.state = 'In Service';