Skip to main content
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(

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!


Reply