Transforming non-spatial Oracle data to spatial SQL Server data

In this demo, we have a non-spatial Oracle database that contains coordinate information in two columns. You'll see how to use FME to convert this non-spatial data into a spatial SQL Server dataset. The primary key and other important attributes are extracted, and the coordinate values are transformed into points. We then reproject the points so they're in the correct coordinate system. The results can be previewed in SQL Server 2008.

You'll also see how to execute a SQL statement before or after a translation.

Transformers used: AttributeCopier, SchemaMapper, 2DPointReplacer, CoordinateSystemSetter