I need to transform an Oracle geodatabase using st_geometry to postgresql using postgis. Ultimately it will be moved to the cloud (RDS on AWS). Is FME the correct tool for this sort of conversion? Would it be fast (roughly 15GB database(
Best answer by danminneyatsaf
Hi @sweingar if you're moving data from an Oracle geodatabase to a PostGIS database, the transition should be relatively easy. Keep in mind that you will need to use the ArcSDE Reader to read the data from the Oracle geodatabase instead of the Oracle Spatial Object Reader. Using the Oracle Spatial Object Reader itself may result in some information and data not being read due to the nature of the geodatabase.
When writing to PostGIS you can use the PostGIS Writer, making sure that the correct geometry type for each table/layer is selected.
Since this is a relatively straightforward FME workspace, I recommend using the Generate Workspace function as it will automatically populate all the Readers/Writers in your workspace, and any transformations needed in between. Let me know if you have any other questions!
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.
+13- Safer
- 485 replies
- Best Answer
Hi @sweingar if you're moving data from an Oracle geodatabase to a PostGIS database, the transition should be relatively easy. Keep in mind that you will need to use the ArcSDE Reader to read the data from the Oracle geodatabase instead of the Oracle Spatial Object Reader. Using the Oracle Spatial Object Reader itself may result in some information and data not being read due to the nature of the geodatabase.
When writing to PostGIS you can use the PostGIS Writer, making sure that the correct geometry type for each table/layer is selected.
Since this is a relatively straightforward FME workspace, I recommend using the Generate Workspace function as it will automatically populate all the Readers/Writers in your workspace, and any transformations needed in between. Let me know if you have any other questions!