Studio 15.11 Available for Download
Teradata Studio Express, Teradata Studio, and Teradata Plug-in for Eclipse 15.11 are now available for download. The Studio family of products provide client based access to Teradata, Aster, and Hadoop.
Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems. Teradata Studio, in addition to the functionality of Studio Express, includes administration features for creating and administering database objects. They are both built on top of the Eclipse Rich Client Platform (RCP) which allows them to benefit from the many high quality Eclipse features available while focusing on value-add for the Teradata Database, Aster Database, and Hadoop platforms. Studio Express and Studio can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.
Teradata Plug-in for Eclipse provides an Eclipse plug-in that includes the same functionality as Teradata Studio along with Dialogs and Wizards to help build Java Web Services, Java Stored Procedures, and Java User-defined Functions. Teradata Plug-in for Eclipse is supported on both Windows and Mac OSX platforms.
What's new in Teradata Studio and Studio Express:
- Connection Management
Provides a preference to limit the number of allowed connections. A connection pool is maintained for each connection profile. The maximum number of connections default value is set to 8 connections, with the minimum number of connections being 2. The Data Source Explorer always keeps one database connection per profile. Each SQL Editor window will hold a connection after the first query is executed. Closing the SQL Editor will release the connection back to the connection pool. Other features that obtain a connection will release the connection after completing its task. Refer to the Connection Options preference page to administer the maximum number of connections per profile.
- Load Teradata Volatile Table
A new 'Import' option is provided on the SQL Editor toolbar to allow you to load data into a Teradata Volatile Table. In using this option, you must first run the CREATE VOLATILE TABLE SQL statement within the SQL Edior. Press the Import button and choose the volatile table to load. This will invoke the Load Data Wizard for importing data.
- Cloudera SQL Execution Support (Impala JDBC Driver)
A new connection profile type, Hadoop Cloudera, is provided allowing for JDBC support within Studio and Studio Express. The Impala JDBC driver is bundled with Studio and Studio Express to allow users to run SQL commands against Cloudera within the SQL Editor. Result sets are displayed in the Result Set Viewer and an entry is placed in the Teradata SQL History.
- SQL Editor Abort Button
Provides an option in the SQL Editor to cancel the running SQL statements.
- New Query List Preferences
Provides more granularity for accessing the Teradata Data Dictionary views when obtaining the metadata for the query lists. Previously, users had to choose between the ViewV or ViewVX used for all query lists. This new feature will allow the user to individually select between these views depending on the list: databases, tables and views, macros and procedures, functions, etc. For example, a user can choose to use the ViewVX (DBC.DatabasesVX) for the databases list but ViewV (DBC.TablesV) for the tables list. The preference page also provides an option to provide a custom view. (NOTE: If choosing the custom view option, you must provide a view that contains the exact same view definiton as the DBC view.)
- Aster Timeout Auto Reconnect Support
Provides automatic reconnection for Aster timeouts. When the Aster session times out, a pop-up message is displayed asking if you want to reconnect to the database. If yes, the user will be prompted for the password and re-connected to the database with a new session.
- Configurable Preferences at Install time
The Windows installation of Studio and Studio Express supports preconfigured preferences that can be provided during the installation process. The feature focuses on those preferences that pertain to database interactions. The Windows media image contains a preferences template file in the /config directory called TeradataStudioPreferences_template.config. Edit this file prior to installation to specify those perferences you wish to intialize, such as query lists views, connection options, query band settings, Data Source Explorer load preferences, and profile connection types. Additional special preferences are also provided, such as disabling the connection profile 'Save Password' option, disabling auto commit in the SQL Editor, or controlling copy, export, and print of result set content. The preferences template also provides an option to lock the preference, preventing the user from changing the preference at runtime.
Refer to the article Studio Preferences: Initialization and Locking for more information on pre-configuring preferences.
What's new in Teradata Studio only:
- Studio Express features
All of the features mentioned above for Studio Express are also provided for Studio.
- New Administration Perspective
The Studio Administration Perspective has an all new look and feel. The display is divided into three main view panes: Navigator View, Filter View, and Object List Viewer. The Navigator View allows you to create, import, or select an existing connection profile. The connectio profile list mirrors the connection profiles contained in the Data Source Explorer. After choosing a connection profile, you are presented with a list of categories to further choose the objects to administer. Double-click on a category to show the list of objects in the Object List Viewer. The Filter View provides a filter service for confining the list of objects displayed in the Object List Viewer. Filters are create per object category and can be combined via AND or OR options. The Object List Viewer displays the lists of objects. Toolbar and Menu actions, such as Create, Modify, Drop, Open, and Show options, are provided to administer the objects.
Refer to the article The New Teradata Studio Administration User Experience for more information on using the new administration perspective.
- New Administration Formshe
Administration forms will replace the administration dialogs that were present in the previous release of Studio. The administration forms are invoked via actions in the Object List Viewer. For example, you can select a Teradata database in the Object List Viewer and press the 'Create Database' action in the toolbar and a 'Create Database' form is opened below the Object List Viewer. The user will enter the database information and press the 'Commit' button to send the request to the database. Similarly, you can display the details of an object by selecting it in the Object List Viewer and choosing the 'Open' object action. In the 'Open' example, the detail information is provided in a read only form.
- Secure Zone Administration Support
Administration of Secure Zones has been added to Studio. Users can display, create, modify, and drop Secure Zones, as well as administer Zone users and guest users.
- Cloudera Connection Options
A new Hadoop Cloudera connection option is provided that supports TDCH, JDBC, and SQL-H services for Hadoop Cloudera.
For more information on using Teradata Studio Express, refer to the article, Teradata Studio Express.
For more information on using Teradata Plug-in for Eclipse, there is an article to help you get up and running. Please refer to Getting Started with Teradata Plug-in for Eclipse.
To ask questions or discuss issues, refer to the Teradata Studio Forum and post your question.
Online Help can be accessed within the plug-in in two ways:
- From the main menu: Help > Help Contents
- Context sensitive help: When a user is in a dialog, they can hit the F1 key to retrieve help text sensitive to where they are within the dialog.
- Also, the Quick Tour provides a quick overview of Teradata Studio Express or Studio features. Go to Help > Welcome.
Reference Documentation can be found on the download page or at: www.info.teradata.com
- Title: Teradata Studio, Studio Express, and Plug-in for Eclipse Installation Guide Publication ID: B035-2037-056K