Introduction 00:00

Tutorial: Getting Started with Oracle 04:48

Viewing and Inspecting Oracle Data 07:14

Converting from Oracle 15:50

Converting to Oracle: Create, Drop or Truncate a Table 35:52

Converting to Oracle: Write to an Existing Table 52:45

Converting from Oracle to Shapefile 58:20

Tutorial: Updating Databases 01:06:50

Updating Databases: Using Change Detection to Set fme_db_operation 01:07:40

Working with Database Transformers 01:29:52

The FeatureMerger 01:36:35

The DatabaseJoiner Transformer 01:46:06

Simple join to a Database Table 01:47:33

The FeatureReader 02:07:06

The SQLExecutor and SQLCreator Transformers 02:29:30

The InlineQuerier Transformer 02:55:47

The FeatureWriter 03:07:20

FME Desktop for Databases (Oracle) Training Course

Prerequisites

This course is designed for proficient users of FME. It assumes a good familiarity with the concepts and practices of FME; at least those covered by the FME Desktop tutorials, and preferably the FME Desktop Basic Training Course.

Overview

Although this course will be using an Oracle database, the topics are applicable to most other FME-supported databases. This is a key course for FME users intending to work with databases.

Training Resources

Download Video (1.5GB)
Right-click and Save Link As