FME can read from and write to Teradata databases versions 12 and 13.
Prerequisites:
-
FME must be 32 Bit
-
Java must be installed on your machine because it is used by Teradata tools.
-
To write to Teradata, The FME Edition must be one of FME Oracle, FME SQL Server, FME Smallworld or FME Server. Any FME edition above Base can read from Teradata.
-
The Teradata Tools and Utilities - Windows Installation Package contains all of the Teradata client components necessary to read and write Teradata in FME. At time of writing the installer for this package could be found here: http://downloads.teradata.com/download/tools/teradata-tools-and-utilities-windows-installation-package. Please see the format documentation at http://docs.safe.com/fme/html/FME_ReadersWriters/Default.htm for detailed steps on installing the components.
-
A reboot after installing these tools is recommended.
Note: The teradata tools need access to java.exe and it may be necessary to add the path to java.exe to your Windows PATH variable.
Limitations
FME's Teradata reader/writer uses the Teradata 12 interface, and so may not be able to read some of the larger geometry objects supported by Teradata 13. If you experience this limitation, please see the ODBC section below.
Using Teradata in FME
In FME the reader and writer named
Teradata Spatial should be available when the above prerequisites are met. The reader will need the Teradata database host name, database name, user and password. The writer will need these as well as an ODBC connection to the Teradata database
ODBC
FME can also read and write to Teradata through the ODBC reader/writer. However some customization of the workspace will be required in order to extract spatial information and use spatial queries, so this should be attempted only if you are having problems reading large geometries from Teradata 13. Please contact support@safe.com for more information.