I would like to migrate data from Intergraph FRAMME format to G/Tech data model. How should I go about it?
Cheers,
John
+2
- Participant
- 594 replies
-
21 July 2015
Hi,
It is not possible to explain in just a paragraph but mentioned below are just indications of few important points...
1. Mapping of attributes
2. Defining or mapping components
3. Topolofy or connectivity
4. Look for creation of seamless data
etc...
Pratap
Thanks Pratap.
Is there any kind of documentation I can refer to. Is it possible in single workbench however complex it may be or do I need multiple workbenches.
Cheers
John
+2
- Participant
- 594 replies
-
21 July 2015
Since more unique features will invlove in this activity so multiple workbenches are required.
May I ask you, Is it for internship or you have been assigned in this kind of project?
You can say it's kind of internship.
Are there any good docs available? I googled it but could not found much. I need info on Readers, Writer and other transformers which can be used.
Cheers
+2
- Participant
- 594 replies
-
22 July 2015
Hi John,
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.
Pratap
+2
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.