Synchronize and filter Oracle and Microsoft SQL Server data
FME works with non-spatial corporate databases, including Microsoft SQL Server, IBM DB2, Netezza, PostgreSQL, Teradata, Ingres, and Oracle. In this demo, you'll see how to use FME Workbench to update Oracle with results from a complex SQL Server query. We'll execute a SELECT statement on a SQL Server database from within a SQLCreator transformer, then execute an UPDATE on an Oracle database from within a SQLExecutor transformer. We'll also perform a data validation step in the middle.
Transformers used: SQLCreator, TestFilter, SQLExecutor
Formats used: Oracle Non-spatial (ORACLE8I_DB), Microsoft SQL Server Non-Spatial (MSSQL_ADO)
For the full webinar on working with non-spatial data in FME, visit http://www.safe.com/learning/webinars...
Watch video Synchronize and filter Oracle and Microsoft SQL Server data online without registration, duration hours minute second in high quality. This video was added by user FME Channel 28 March 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,948 once and liked it 1 people.