15.12 - Using the SQL File Editor - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
15.12
created_date
August 2016
category
User Guide
featnum
B035-2042-086K
The Teradata SQL Editor supports:
  • Teradata Database connection profiles
  • Aster Database connection profiles
  • Hadoop File System connection profiles with JDBC enabled

If you are working with SQL files located on a different type of database, such as Oracle or MS SQL Server, you must work in the SQL File Editor.

  1. Do one of the following:
    • In Project Explorer, right-click the SQL folder.
    • Open the SQL Editor and right-click in the main editor pane.
  2. Select Open With > Other.... The Editor Selection dialog displays.
  3. Select SQL File Editor.
  4. Click OK.
  5. Under Connection Profile, select the Type of database for this connection; for example, Oracle_10 or SQL Server_2005.
  6. Select the Name of the connection profile from the list. Only existing connection profiles display in the list.
  7. Select the Database name from the list. Aster and Hadoop have no database name.
  8. Verify the status of the profile you selected. Status information displays to the right of the Database name. If no connection profile exists for a particular profile type, the Name and Database fields are blank.