I would like to migrate data from Intergraph FRAMME format to G/Tech data model. How should I go about it?
Cheers,
John
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
I don't think there will be documents available as it is not same for all kinds of projects/data. My email ID is ?kumarchintadri@gmail.com do let me know if you need any help.
We use FME to generate a table containing features to write into the G/Tech database (Oracle Spatial). After that, a self created Oracle Package is used to generate G/Tech features.
Another way I am experimenting with, is the following:
Use a FeatureReader to read only Schema data for all features to write, connect it to a dynamic Oracle writer
Be sure to use Pre- and After SQL run scripts that disable/enable all triggers on tables to insert
Be sure to generate correct new KEY fields like G3E_FID from the tables sequences using an SQLExecutor
Use a FeatureReader to read all features to be migrated.
Use an InlineQuerier connected to the schema features to write and the features to be migrated and produce a full outer join to accommodate writing multiple tables coming from just one feature to migrate.
Use a SchemaMapper to perform mappings
Connect the mapped features to the dynamic Oracle writer
At the moment, the writer does not write any geometry. Working on that.