FAQs on database connectivity | Teradata Studio/Studio Express - Database Connectivity FAQ - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Teradata Studio
Release Number
September 2022
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

How Teradata Studio/Studio Express connects to databases?

Teradata Studio/Studio Express uses JDBC to connect to Teradata Database, Aster Database, or Hadoop system. ODBC is not supported with Teradata Studio/Studio Express. The Teradata JDBC driver, Aster JDBC driver, and HiveServer2 (v0.13) JDBC driver come embedded in the Teradata Studio/Studio Express product. Refer Database Connectivity for detailed information.

How to change the user password in Studio Express?

To change the user password in Teradata Studio/Studio Express:
  1. Right-click the database node from the Data Source Explorer tree.
  2. Go to Teradata > Change Password.
  3. Enter the current password, new password, and confirm the new password in the respective fields.
  4. Click OK.

How to connect to non-Teradata databases?

Teradata Studio/Studio Express can connect to DB2, Oracle, or SQL Server databases. Select the database types from the New Profile Connection Types (Window > Preferences > Teradata Datatools > New Profile Connection Types) to enable the connection types. When you proceed for creating a new connection profile, the selected non-Teradata databases appear in the Connection Profile Types. Refer Database Connectivity for detailed information.

How to add a database?

In Teradata Studio/Studio Express, the Data Source Explorer view provides the database tree with its database objects presented in folders, such as Databases, Tables, Macros, Views, and others.

To add a database:
  1. Go to Window > Preferences > Teradata Datatools > Data Source Explorer Load.
  2. Deselect Show Databases and Users in Hierarchical Display.
  3. Select User Choice.
  4. Click Apply.
  5. Go to the Data Source Explorer view and right-click the Databases folder.
  6. Select Teradata > Load Database. Add Database dialog box opens.
  7. Enter the name of the database.
  8. Click Add. The new database appears under the Databases folder.

Why and how to set the root location of the database tree?

If you prefer to display the database tree in a hierarchical format (nesting child databases and users) but still reducing the number of databases and users displayed in the tree, you can set the root of the database tree. This restricts the display to your database or user and its child databases and users.

Why and how to create a database tree filter in Data Source Explorer?

You can set a filter on the folders in the Data Source Explorer to filter out unwanted database objects. This filter also applies to the Tables, Views, Stored Procedures, and User-Defined Functions.

To create a filter:
  1. Right-click a folder in the Data Source Explorer view and select Filter. The Filter dialog box opens.
  2. Deselect Disable filter.
  3. Select any of the following ways to set a filter:
    • Expression: Filter through expressions in the Name drop-down menu.
    • Selection: Select the objects from the list to be included or excluded in the display.
  4. Click OK to apply the filter in the Data Source Explorer view.