Licensing options for this format begin with FME Desktop Professional Edition.
Overview
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 Workbench. These transformers allow arbitrary Structured Query Language (SQL) statements to be executed against any database.
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.