I want to replicate oracle tables with SDO_GEOM data types to a Snowflake data warehouse without any transformations before. Just a straight up replication of the complete table, including the SDO_GEOM data field. Can Safe FME do that?
+13- Safer
Hi @miguel this is certainly possible with FME. Using the Oracle Spatial Object Reader, you can read/import in records from Oracle tables and then write/output them to a Snowflake data warehouse using the Snowflake Spatial Writer. FME will deal with all the geometry for you, so you won't need to go in manually and touch the SDO_GEOM data type.
If you're new to FME Form (our desktop product), you can try using the Generate Workspace function that's available when you open up a brand new FME Workbench window. Let me know if you have any further questions!
Hi @miguel this is certainly possible with FME. Using the Oracle Spatial Object Reader, you can read/import in records from Oracle tables and then write/output them to a Snowflake data warehouse using the Snowflake Spatial Writer. FME will deal with all the geometry for you, so you won't need to go in manually and touch the SDO_GEOM data type.
If you're new to FME Form (our desktop product), you can try using the Generate Workspace function that's available when you open up a brand new FME Workbench window. Let me know if you have any further questions!
Hi @danminneyatsaf, thank you for the response. That is helpful. As a follow up, can FME do the same with Esri ST_GEOM data type fields in an Oracle dB table? (This question is also posted to the community, I should have combined to the two data types into one question.)
+13- Safer
Hi @danminneyatsaf, thank you for the response. That is helpful. As a follow up, can FME do the same with Esri ST_GEOM data type fields in an Oracle dB table? (This question is also posted to the community, I should have combined to the two data types into one question.)
The same would apply for the ST_GEOM data type fields in an Oracle database table. If your data is stored in an Enterprise Geodatabase, then you would want to use an ArcSDE Enterprise Geodatabase Reader instead of the Oracle Spatial Object Reader to read in the data before writing it to Snowflake. Again, FME will handle all of the geometry for you.