Teradata Manuals
Note Teradata database support is not enabled by default and requires the Teradata extension to be installed prior to use. Please see the section on for details. The Teradata Database is a commercial relational database (RDBMS) that specializes in parallel processing and scalability.
From version 12.0, Teradata has added geospatial support, closely following the SQL/MM standard (SQL Multimedia and Applications Packages). Geospatial support was available through an add-on in version 12.0 and became standard in version 13.0. GeoServer connects to a Teradata database via JDBC. For more information on Teradata and the Teradata Database system, please go to.
Tessellation Tessellation is the name of Teradata’s spatial index. In order to activate tessellation for a given layer, an entry (row) needs to be placed in the SYSSPATIAL.tessellation table. Note If you don’t Teradata in this list, the extension has not been installed properly. Please ensure that the steps in the have been followed correctly. On the next screen, enter in the details on how to connect to the Teradata database. You will need to include the following information: Option Description Workspace Name of the workspace to contain the database. This will also be the prefix of any layers server from tables in the database.
Data Source Name Name of the database in GeoServer. This can be different from the name of the Teradata database, if desired.
Description Description of the database/store. Enabled Enables the store. If disabled, no layers from the database will be served. Host Host name where the database exists. Can be a URL or IP address. Port Port number on which to connect to the above host. Database Name of the Teradata database.
User User name to connect to use to connect to the database. Passwd Password associated with the above user. Namespace Namespace to be associated with the database. This field is altered automatically by the above Workspace field.
Expose primary keys Exposes primary key as a standard attribute. Max connections Maximum amount of open/pooled connections to the database.
Min connections Minimum number of open/pooled connections. Fetch size Number of records read with each interaction with the database. Connection timeout Time (in seconds) the connection pool will wait before timing out. Validate connections Checks the connection is alive before using it. Primary key metadata table Name of primary key metadata table to use if unable to determine the primary key of a table. Loose bbox If checked, performs only the primary filter on the bounding box.
Teradata 15 Manuals
TessellationTable The name of the database table that contains the tessellations estimatedBounds Enables using the geometrycolumns/tessellation table bounds as an estimation instead of manual calculation. Max open prepared statements The maximum number of prepared statements. When finished, click Save.
Teradata (JNDI) in the list of readable stores On the next screen, enter in the details on how to connect to the Teradata database. You will need to include the following information: Option Description Workspace Name of the workspace to contain the database. This will also be the prefix of any layers server from tables in the database. Data Source Name Name of the database in GeoServer. This can be different from the name of the Teradata database, if desired.
Description Description of the database/store. Enabled Enables the store. If disabled, no layers from the database will be served. JndiReferenceName JNDI path to the database. Schema Schema for the above database. Namespace Namespace to be associated with the database. This field is altered by changing the workspace name.
Expose primary keys Exposes primary key as a standard attribute. Primary key metadata table Name of primary key metadata table to use if unable to determine the primary key of a table. Loose bbox If checked, performs only the primary filter on the bounding box. When finished, click Save.
Teradata Manuals
Hello Abhishek, you can find documentation (Installation Guides, Programming Guides, Operations and Service Guides, Reference Manuals) on Teradata products at this site: It is the ultimate source for anything Teradata products related. And last tip: as you are new to Teradata database i would recommend you starting here: (Home Data Warehousing Teradata Database Introduction to Teradata) Regards, Tomas.
Comments are closed.