Teradata Spatial and Non-Spatial (JDBC) Reader/Writer

Licensing options for this format begin with FME Professional Edition.

Note: This chapter refers to both the Teradata Spatial and Teradata Non-spatial Reader/Writer.

Overview

Teradata Spatial is a geometric extension of Teradata since version 13.10 that provides geometry and Spatial Reference System (SRS) handling. The Teradata Spatial reader/writer module enables FME to read geometric data as well as underlying attribute data stored in Teradata.

The Teradata Spatial reader/writer is specifically designed to handle the geometric and SRS portions of the data. The Teradata Spatial reader/writer uses the Teradata JDBC driver.

Note: When reading attribute-only tables from Teradata, you should select the Teradata Non-Spatial reader/writer in Workbench.

This chapter assumes familiarity with Teradata Spatial and Teradata, the attribute and geometry types supported, and its indexing mechanisms.

For more information, please see the Teradata home at http://www.teradata.com/ and the Teradata Documentation at http://www.info.teradata.com/.

Teradata JDBC Drivers

Teradata (JDBC) also requires Teradata JDBC drivers, which are not installed with FME.

You can download the drivers from: http://downloads.teradata.com/download/connectivity/jdbc-driver

The .jar files in the downloaded archive must be placed in FME_HOME/plugins.

For help with installing the JDBC driver for FME, please see Getting Started with JDBC.

Format Resources

Teradata Quick Facts

Feature Representation

Teradata Non-Spatial Parameters

Teradata Spatial Parameters