applications

Query Service

Version: - Created: 06 Jul 2023

Query Service is a RESTful web service for Teradata Vantage that allows web pages, mobile devices, and scripting languages to query Vantage using HTTP as the wire protocol and JSON as the data interchange format. Since support for HTTP and JSON is available in most programming languages, applications can use this service to access a Vantage database without requiring a driver.The attached package is for on-prem (VantageCore VMware and VantageCore IntelliFlex) customers. VantageCloud Enterprise and VantageCloud Lake already come with a hosted Query Service instance. Please contact support to start using Query Service in VantageCloud Enterprise or VantageCloud Lake environments.For installation instructions in VantageCore environments see Teradata® Query Service Installation, Configuration, and Usage Guide.

Teradata Profiler Plug-in - Express Edition

Version: - Created: 01 Sep 2017

The Teradata Profiler Plug-in is based on the Eclipse plug-in framework and the Teradata Plug-in for Eclipse and Teradata Studio Data Source Explorer (DSE). Teradata Profiler Plug-in enables the user to Profile Teradata and Aster tables/columns via the DSE as well as create projects containing analyses. The descriptive statistics available with the Teradata Profiler Plug-in provide a variety of functions to statistically analyze and explore data tables in a Teradata or Aster database. This is a complete version of the Teradata Profiler for Eclipse, without an evaluation time limit, however, it is limited in use to up to 40 GB of "connected" data. (Note that the validation of the 40 GB limit for the Express Edition requires SELECT access to the dbc.allspace view in Teradata or EXECUTE permission on the nc_relationstats SQL-MR function in Aster for the user.) ► NOTE: This version requires the Teradata Plug-in for Eclipse 15.10.01.00 or greater (available here) if using with Eclipse. To install the Teradata Profiler Plug-in via the Eclipse Update Site process, bring up Eclipse and run the Software Updates process. From the main menu, select Help then Install New Software... In the Work with field, select the Add... button. Enter Profiler Update Site in the Name field and the Teradata Profiler Plug-in for Eclipse URL (http://downloads.teradata.com/download/cdn/applications/profiler/profiler-05.04.02/update/site.xml) as the Location. Click OK Select all of the Teradata Profiler Plug-in for Eclipse features to install. Click Next to proceed with the installation. When the Feature License Agreement appears, select I accept the terms in the license agreement, and then click Next. When prompted click Finish to continue the installation. A warning message may appear regarding unsigned JAR content. Click OK to continue. When a message appears asking if you want to restart Eclipse, click Yes. To install from a local Teradata Profiler Plug-in for Eclipse Update Site, download the zip file locally. Refer to the User Guide for further instructions on installing Teradata Profiler Plug-in for Eclipse. For installation in Teradata Studio or Teradata Studio Express, you will need the ProfilerPluginForEclipse.zip file (download above). Extract the files and simply copy thejar file from the "ProfilerPlugin-Express\update\plugins" folder and paste into the Teradata Studio or Teradata Studio Express "plugins" directory (ususally found under c:\Program Files\Teradata\Client\15.10). Note, with Teradata Studio Express the Profiler windows will all display in the bottom panel (next to the SQL History). This is because the Teradata Studio Express does not have a perspective that Profiler can open its windows in. If desired, you may drag the Profiler windows to other locations within Studio Express for better viewing. Teradata Profiler Plug-in for Eclipse contains open source components. The zip file contains the source code (as required) and licenses for these components. This package does not contain proprietary Teradata source code. For help getting started using the Teradata Profiler Plug-in, refer to the User Guide. Readme Teradata Profiler Plug-in for Eclipse 05.04.02 release information. Supported Platforms: =============================      Windows Server - Microsoft Windows Server 2008, 32-bit and 64-bit      Windows 7      - Microsoft Windows 7, 32-bit and 64-bit      Windows 8      - Microsoft Windows 8, 32-bit and 64-bit Dependent Eclipse Software: =============================      Eclipse IDE for Java JEE Developers (Kepler 4.3)      Eclipse IDE for Java JEE Developers (Luna 4.4.2)      Eclipse IDE for Java JEE Developers (Mars 4.5) Required Software: =============================      Java Runtime Environment (JRE) version 1.7 or greater      Teradata Plugin for Eclipse 15.10.01 or greater      Teradata Studio 14.10 or greater Supported Teradata Databases Versions: ======================================      Teradata Database 14.10      Teradata Database 15.00      Teradata Database 15.10 Supported Aster Databases Versions:  ======================================      Aster Database 6.0      Aster Database 6.10      Aster Database 6.20 Install Instructions: =============================      Once the dependent and required software has been installed, Teradata Profiler      Plug-in for Eclipse can be installed and configured. Follow this procedure to      install Teradata Profiler Plug-in for Eclipse 05.04.02 using the Eclipse Local      install procedure.      To install Teradata Profiler Plug-in for Eclipse 05.04.02:      1. From the Eclipse main menu, click Help and then click Install New Software….      2. Click the Add… button.      3. Type ”Profiler Local Install” in the Name field and and click on the Local…         button to select the ProfilerLocalInstall folder* as the Location.      4. Click OK to add the site.      5. Select the Teradata Profiler Plug-in for Eclipse and then click Next.      6. When the Feature License Agreement appears, select I accept the terms in the         license agreement, and then click Next. A list of features appears with the         feature version, size, and Eclipse install location.      7. Verify that the information is correct, and then click Finish to continue         the installation. A warning message appears regarding unsigned JAR content.      8. Click OK to continue.      9. When a message appears asking if you want to restart Eclipse, click Yes.      * If your installation contains the ProfilerPluginForEclipse.zip file you will        need to unzip the ProfilerPluginForEclipse.zip into a directory to extract        the ProfilerLocalInstall folder.     For installation in Teradata Studio or Teradata Studio Express, you will need     the ProfilerPluginForEclipse.zip file. Extract the files and simply copy the     jar file from the ProfilerPlugin-Express\update\plugins folder and paste into the     Teradata Studio or Teradata Studio Express plugins directory (ususally found     under c:\Program Files\Teradata\Client\15.10). Known Issues ==============================     TWM-1588: After running a scatter plot on the same column name from two different     tables (e.g. “age”) and attempting to drill down into a column from the graph, we     receive the error: “Duplication of column AGE in a table, derived table, view, macro     or trigger”.     TWM-1163: Profiler Perspective windows do not appear in the proper place in     Teradata Studio Express. This is an issue with Studio Express not having a     perspective for the Profiler Plug-in.

Teradata Warehouse Miner - Express Edition

Version: 05.03.00 - Created: 27 Jul 2017

The latest software available for download here is Teradata Warehouse Miner 05.04.04 Express Edition. This is a complete version of the Teradata Warehouse Miner product set, without an evaluation time limit, however, it is limited in use to up to 40 GB of "connected" data. (Note that the validation of the 40 GB limit for the Express Edition requires SELECT access to the dbc.allspace view in Teradata or EXECUTE permission on the nc_relationstats SQL-MR function in Aster for the user.) To get started with TWM - Express Edition, please download the "TWM Express Introduction" PDF above. This introductory document provides the following information: Limitations of the Express Edition Overview of the TWM family of products General installation and configuration instructions Configuring the tutorial environment Examples of using the product The Release Definition (.pdf, available above) has a list of all new features, fixes, defects, restrictions and dependencies. The complete TWM User Guide 3 Volume documentation set is also included as pdf files above. Before installing TWM 05.04.04, follow these instructions, in sequential order: Uninstall any previous versions of Teradata Warehouse Miner or its derivative products if they were installed. Ensure that a supported 32-bit Teradata ODBC driver from TTU 14.10,15.0, 15.10, 16.0 or 16.10 is installed, available here: ODBC Driver for Windows.  If connecting to an Aster Database, ensure that a supported 32-bit Aster ODBC driver from Aster Client Tools 6.00, 6.10 or 6.20 is installed, available here: Aster Client Tools for Windows.  Install the Teradata Warehouse Miner 05.04.04 Express Edition. Refer to the Installation and Configuration section of the "TWM Express Introduction" document for additional instructions on configuring Teradata Warehouse Miner prior to your first use. For community support for this product, please visit the Analytics forum.