Skip to main content
Question

Is their any Fme reader to pull data from getech into fgdb?


Is their any reader in fme available to read data from getech and convert into fgdb??

6 replies

erik_jan
Contributor
Forum|alt.badge.img+19
  • Contributor
  • May 8, 2020

Hexagon's Gtech data is stored in an Oracle database.

The Oracle Spatial Object reader can be used to pull out the data.

If you have a really old version (before 2000), you might need the Oracle Relational reader (Oracle 7.3.4 and older), but the chance of that is small.

No specific reader is available.

Hope this helps.


Forum|alt.badge.img+2

@sandeepchettu As @erik_jan mentions you have to use the FME Oracle Spatial Object reader. It does assume you have a reasonably good understanding of the Hexagon G/technology database and data model. This is because you have to peice the data together from different tables. There are a couple of approaches you can take:

  • Create appropriate views in the G/tech database and have FME read those views (preferred approach)
  • Read all the tables using FME Oralce reader and using FeatureJoiner or FeatureMerger, join the appropriate feature in the FME Workspace.

markatsafe wrote:

@sandeepchettu As @erik_jan mentions you have to use the FME Oracle Spatial Object reader. It does assume you have a reasonably good understanding of the Hexagon G/technology database and data model. This is because you have to peice the data together from different tables. There are a couple of approaches you can take:

  • Create appropriate views in the G/tech database and have FME read those views (preferred approach)
  • Read all the tables using FME Oralce reader and using FeatureJoiner or FeatureMerger, join the appropriate feature in the FME Workspace.

Thanks @markatsafe,Will views importing require gtech data model knowledge or else we can directly transfer data into fgdb.As I am layman in getech datamodel.


erik_jan wrote:

Hexagon's Gtech data is stored in an Oracle database.

The Oracle Spatial Object reader can be used to pull out the data.

If you have a really old version (before 2000), you might need the Oracle Relational reader (Oracle 7.3.4 and older), but the chance of that is small.

No specific reader is available.

Hope this helps.

We are using Gtech 10.2 version.


Forum|alt.badge.img+2
sandeepchettu wrote:

Thanks @markatsafe,Will views importing require gtech data model knowledge or else we can directly transfer data into fgdb.As I am layman in getech datamodel.

@sandeepchettu I think you would need someone on the project team who understands the G/Tech data model. That would be my advice. You can use our partner locator to find an FME partner that might be able to help.


srg
Forum|alt.badge.img+10
  • May 19, 2020

@sandeepchettu if you are from India, we could assist you


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