ODBC 3.x Reader/Writer

The ODBC 3.x reader enables FME to access databases accessible via Open DataBase Connectivity (ODBC).

Tip See the SQLCreator and the SQLExecutor transformers in FME Workbench. These transformers allow arbitrary Structured Query Language (SQL) statements to be executed against any database.

ODBC 3.x Product and System Requirements

Format	Platform			Operating System
Reader/Writer	FME Desktop License	FME Server	FME Cloud	Windows 64-bit	Linux	Mac
Reader	Available in FME Professional Edition and higher	Yes	Yes	Yes	Yes	No
Writer	Available in FME Professional Edition and higher	Yes	Yes	Yes	Yes	No

Reader Overview

FME considers a database dataset to be a collection of relational tables.

The tables must be defined in the workspace before they can be read. Arbitrary WHERE clauses and joins are fully supported.

Writer Overview

The ODBC 3.x writer module stores attribute records into a live relational database. The writer provides the following capabilities:

Table Creation: The writer uses the information within the FME workspace to automatically create database tables as needed.