Since Teradata first introduced native Geospatial capabilities in the database there have been inquiries about how to interoperate with the spatial data via client GIS and visualization tools. In this article we are going to discuss how to view and edit spatial features and attributes maintained within Teradata in real-time by using the GeoServer web services.
The Teradata database currently complies with the Open Geospatial Consortium (OGC), Simple Features – SQL – Types and Functions 1.1 (SFS(TF) 1.1) standard. Since Teradata complies with the OGC standards, customers can integrate with other OGC compliant interfaces, web services, and technologies that adhere to the standard as well. GeoServer (www.geoserver.org) is an open source software server written in Java that allows users to share and edit geospatial data. Designed for interoperability, it publishes spatial data from the Teradata database using these open standards. GeoServer publishes maps and data in standard protocols devised by the OGC. The most common of these protocols are the Web Map Service (WMS) and Web Feature Service (WFS).
The open source GeoServer project has recently added support for Teradata Geospatial, which will allow for full read and write capabilities including the viewing, editing, and deleting of spatial features in the database. Now GIS and visualization tools can interoperate with Teradata spatial data in real-time via the GeoServer web services. The Teradata extension for GeoServer has also been optimized and customized for Teradata including the use of Querybanding and Tessellation support.
The GeoServer and Teradata documentation provides detailed instructions about how to download, install, and configure GeoServer with Teradata. It also contains Teradata database considerations, configurations, and set-up instructions, including information about setting up tessellation index tables for optimal performance. The documentation also covers how to connect popular visualization tools such as Google Earth and uDig to GeoServer to view and edit features in Teradata.
Download GeoServer and Teradata - Your Geospatial Data Served on the Web (.PDF, 5.2MB)
This document has been developed in conjunction with OpenGeo (http://www.opengeo.org), which is one of the primary contributors to the GeoServer project, and provides enterprise support, services, and training.
The sample shapefile data referenced in the document can be found here: http://files.opengeo.org/states.zip
Information about the Teradata extension for GeoServer and connection instructions can be found at:
Information about the Teradata extension and connection instructions for uDig, the open source desktop GIS tool, can be found at:
Once the data is served in GeoServer, connecting to it means to connect to WMS and WFS services. The following document points to online resources for instructions on how to connect various GIS and visualization tools via these OGC services, including esri ArcGIS for Desktop and Explorer, MapInfo Professional, AutoDesk MapGuide Studio and Map Server, uDig, QGIS, Google Earth, and gvSIG.