tools

Version: 13.00.00.00 - Created: 18 Dec 2009

Teradata SQL Assistant Java Edition (SQLA-JE) provides an information discovery tool that retrieves data from Teradata Database systems and allows the data to be manipulated and stored on the desktop. It is built on the Eclipse Rich Client Platform (RCP). For more information on SQLA-JE, refer to SQL Assistant Java Edition. SQLA-JE contains several open-source components, and a package containing the source code and licenses for these components is available for download. This package does not contain proprietary Teradata source code. README SQL Assistant Java Edition 13.00.00 release information. Supported Platforms: ============================= Windows Vista - Microsoft Windows Vista Enterprise, 32-bit and 64-bit Windows XP Professional - Microsoft Windows XP Professional, 32-bit and 64-bit Windows Server - Microsoft Windows Server 2003, 32-bit and 64-bit - Microsoft Windows Server 2008, 32-bit and 64-bit Windows 2000 - Microsoft Windows 2000, 32-bit Ret Hat Server - Red Hat Advanced Server 2.1, 3.0, and 4.0, 32-bit - Red Hat Advanced Server 4.0, 64-bit Red Hat Platform - Red Hat Advanced Platform 5.0, 32-bit and 64-bit SUSE Linux Enterprise - SUSE Linux Enterprise 9, 32-bit and 64-bit - SUSE Linux Enterprise 10, 32-bit and 64-bit Apple Mac - OSX 10.5 and 10.6 Supported Teradata Databases Versions: ============================= Teradata Database V2R6.0 Teradata Database V2R6.1 Teradata Database V2R6.2 Teradata Database 12.0 Teradata Database 13.0 Required Software: ============================= Java Runtime Environment (JRE) version 1.5 or greater Install Instructions; ============================= Download the SQLA JE zip file from the download site. For Windows install: 1) Unzip the Teradata SQLA JE package to your local file system. 2) Run the setup.exe to launch the Teradata SQLA JE installation. 3) Provide the path to where you would like to install Teradata SQLA JE. The default location is C:\Program Files\Teradata\Client\13.0\Teradata SQL Assistant Java Edition. When SQLA JE is started, a 'workspace directory' is created in your home directory (C:\Documents and Settings\USER\workspace). This directory contains workspace files, including the SQL project folder and .log file. For Linux install: 1) Unzip and untar the Teradata SQLA JE package to your local file system. gunzip teradatasqla__linux_i386.13.00.00.00-1.tar.gz tar -xvf teradatasqla__linux_i386.13.00.00.00-1.tar 2) Change directories (CD) to the teradatasqla.13.00.00.00 directory cd teradatasqla.13.00.00.00 3) Switch to Super User or Root and execute the RPM (Package Management) command to install SQLA JE on Linux. su ./sqlajeinstall teradatasqla-13.00.00.00-1.i386.rpm 4) Provide the path to where you would like to install Teradata SQLA JE. . The default location is /opt/teradata. When SQLA JE is started, a 'workspace' directory is created in the location where you launched SQLA JE (sqla) from. This directory contains workspace files, including the SQL project folder and .log file. Note: To check whether Teradata SQLA JE is installed or not, run the following command: rpm -qa teradatasqla To remove the Teradata SQLA JE product from your Linux system, run the following command: rpm -e teradatasqla For Mac OS Install: 1) Unzip the Teradata SQLA JE package to your local file system. 2) Double click on the Teradata SQL Assistant Java Edition.pkg package to invoke the SQLA JE installer 3) You can change the install location or use the default install location, which is the /Applications/teradatasqla folder. When SQLA JE is started, a 'SQLA' folder is created in the user's Documents folder. This folder contains the workspace files, including the SQL project folder and .log file. Running SQLA JE: ============================= Windows: Double click the Teradata SQL Assistant Java Edition desktop icon shortcut. Linux: Update your path variable to include the teradatasqla directory. Execute sqlaje. Mac: Execute SQL Assistant Java Edition in the teradatasqla directory.

Version: 13.01.00.00 - Created: 10 Nov 2009

The Teradata Plug-in for Eclipse is based on the Eclipse plug-in framework and Data Tools Platform (DTP). Teradata Plug-in for Eclipse enables Eclipse DTP to operate with the Teradata Database and value-added features. To install the Teradata Plug-in for Eclipse 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 Add... Enter the Teradata Plug-in for Eclipse URL (http://developer.teradata.com/dl/tdide/tdide-13.01.00/update/site.xml) as the Remote Site URL. Select the parts of the Teradata Plug-in for Eclipse that you require (typically everything) and proceed with the install. To install from a local Teradata Plug-in for Eclipse Update Site, download the zip file locally.

Version: 13.00.00.00 - Created: 11 May 2009

The Teradata Plug-in for Eclipse is based on the Eclipse plug-in framework and Data Tools Platform (DTP). Teradata Plug-in for Eclipse enables Eclipse DTP to operate with the Teradata Database and value-added features. The Teradata Plug-in for Eclipse Release Definition is located at: http://www.info.teradata.com/eDownload.cfm?itemid=091280002 To install the Teradata Plug-in for Eclipse via the Eclipse Update Site process, bring up Eclipse and run the Software Updates process. Enter the Teradata Plug-in for Eclipse URL ( http://www.teradata.com/datatools/update ) as the Remote Site URL. To install from a local Teradata Plug-in for Eclipse Update Site, download the Teradata Plug-in for Eclipse Update Site zip. System Requirements File Name: idetools__windows_i386.13.00.00.00.zip File Size: 10,345 kb Product Version: 13.00.00.00 Operating System Support: * Microsoft Windows 2000 Professional Server and Advanced Server, with sp4, running on Intel x86 * Microsoft Windows XP Professional, with sp2, running on Intel x86 * Microsoft Windows XP Professional, with sp2, running on Intel Xeon with EM64T (32-bit) * Microsoft Windows Server 2003 Enterprise and Standard Editions, with sp2, running on Intel x86 (32-bit) * Microsoft Windows Server 2003 Enterprise and Standard Editions, with sp2, running on Intel Itanium (32-bit) * Microsoft Windows Vista, running on Intel x86 (32-bit) Required Eclipse Downloads: * Eclipse 3.4.x *EMF+SDO+XSD 2.4.x *GEF 3.4.x * DTP 1.6.x Teradata JDBC Driver for Teradata 13.0 or greater Teradata Release Support: V2R6.0.x, V2R6.1.x, V2R6.2.x, R12.0, R13.0 Release Date: 5/12/2009 12:00:00 PM Installation Refer to the Release Definition for further directions on installing required Eclipse components. How to install this package as a local update site: 1. Run the self-extracting executable. 2. Extract the files to a folder. 3. Go to the installation area where you installed Eclipse and double click on the eclipse.exe file to start Eclipse. Eclipse will prompt for a workspace location. 4. Click the location where Eclipse should store its data files. To keep from seeing this prompt each time, check the box to automatically use the designated workspace. Note: A Help menu will appear. To cancel the help menu, click the "X' at the top left hand corner of the menu. 5. To install Teradata Plug-in for Eclipse, go to the Help menu and click 'Software Updates...'. 6. Choose the 'Available Software' tab. 7. Click the 'Add Site...' button. 8. Click the 'Local...' button and in the Browse For Folder window, locate the directory where idetools__windows_i386.13.00.00.00.zip was unzipped. A Name and URL displays that reflects the location. Click OK to continue with the installation. 9. The Teradata Update Site is included in the list of sites. Make sure the box is checked, then click the Install button. 10. The Feature License Agreement appears. Check "I accept the terms in the license agreement" and click Next. A list of features appears with the feature version, size, and Eclipse install location. Verify that the information is correct and click Finish to continue the installation. 11. The Feature Verification screen appears. Click the Install All button. Click Yes to restarting Eclipse message. Running the Eclipse Data Source Explorer: 12. Go to the Window menu and click Show View>Other. 13. Open the Connectivity folder and click Data Source Explorer then click OK to launch the DSE in the bottom portion of the Eclipse screen. 14. Move the DSE over to the left hand area of the screen for more room. This can be done by clicking and then dragging the Data Source Explorer folder over to the Package Explorer area and letting go.