Studio 15.12 Available for Download

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Teradata Employee

Studio 15.12 Available for Download

Teradata Studio Express, Teradata Studio, and Teradata Plug-in for Eclipse 15.12 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 15.12:

  • New Hadoop Connection Profile Wizard

Provides a better user interface for managing Hadoop connections. Combines Hortonworks, Cloudera, and General Hadoop connection into a single wizard. Also added SSL option for Knox and LDAP security option for Hadoop JDBC connections.

  • Hadoop Presto Support

Provides support for Presto JDBC with Hortonworks and Cloudera Hadoop connections. Studio supports Presto version 141t.

  • Hadoop Smart Load from External Files

Provides Smart Load support to load data into a Hadoop table.  This feature uses WebHDFS to copy the file from the client system to the Hadoop system. Then uses JDBC to CREATE the table and LOAD the file into the Hadoop Database table. Only .txt, .csv. and .tsv file formats are supported. Note: You must check the box when creating your Hadoop Connection for Smart Loader (File Import/Export in Hadoop).

  • Hadoop Data Load and Export

Provides support for data load and export to and from Hadoop tables. The Hadoop Data Load feature uses WebHDFS to copy the file from the client system to the Hadoop system. Then uses JDBC to LOAD the file into the Hadoop Database table. Only .txt, .csv, and .tsv file formats are supported. Note: You must check the box when creating your Hadoop Connection for Smart Loader (File Import/Export in Hadoop). The Hadoop Data Export feature executes a SELECT statement to pull the data from the Hadoop system and store in the destination file on the client system.

  • User Interface Enhancements

Provides additional UI enhancements that include:

  • Color code EXPLAIN results and support for multiple EXPLAIN statements
  • Separate Query Band for Fast Load/Export
  • Row Count for Teradata Result Sets
  • Result Set Viewer provide whole column selection
  • Preference for Default JDBC Properties

Provides a preference to set the default JDBC properties used when creating new connection profiles. The current default JDBC properties include: CHARSET=UTF8 and TMODE=ANSI. The user can change the default properties using the Connection Options preference page. Any new connection profiles will use the new default JDBC properties. These properties can also be set at install time using the Preferences configuration file.

  • Export Option to include SQL Statement and Result Status

Provides an option to include the executed SQL statment and the result status in the exported file. This option can be set in the Export Preferences page.

  • Navigator Set Root (Studio Only)

Provides the same Set Root capability in the Studio Navigator View as provided by the Data Source Explorer. This allows the user to change the root of the Databases and Users hierarchical tree display. In the Navigator, right click on the Databases category and choose the Set Root menu option.

What's new in Teradata Studio Express only:

  • Open Property Form

The Object View has been removed from Studio Express. Instead, users can display detailed information about database objects by using the Open in Property Form option. Select the object in the Data Source Explorer, then right click and choose the Open in Property Form menu action. This will display the object details in a form-based user interface. Within the form press the vertical tabs to display the detailed information for the database object.

Need Help?

For more information on using Teradata Studio Express, refer to the article, Teradata Studio Express or Teradata Studio Express User Guide (available on the Teradata Studio Express Download Page).

For more information on using Teradata Studio, refer to the article, Teradata Studio or the Teradata Studio User Guide (available on the Teradata Studio Download Page).

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-086K
44 REPLIES
Enthusiast

Re: Studio 15.11 Available for Download

How do we setup Studio and Studio Express to utilize SSO?

William Miteff
Teradata Employee

Re: Studio 15.11 Available for Download

If using Kerberos, you need to set up the credentials. Here is a section from our Studio Help Content:

Kerberos Authentication

When using Kerberos authentication, you must provide a security configuration file (TeraJDBC.config and specify its location in a Java property. The format of the TeraJDBC.config file is specified in the Teradata JDBC Users Guide. The location of this file needs to be specified in the java.security.auth.login.configure property variable. For Single Sign on also add javax.security.auth.useSubjectCredsOnly=false. You can also add the location of the krb5.ini file. Using java.security.krb5.conf=<loacation>. Add these property variable to the .ini file as follows:

-Djava.security.auth.login.config=c:/TeraJDBC.config

-Djavax.security.auth.useSubjectCredsOnly=false

-Djava.security.krb5.conf=C:\teradata\krb5.ini

where c:/TeraJDBC.config is the location of the TeraJDBC configuration file. The .ini file (TeradataStudioExpress.ini, TeradataStudio.ini, or eclipse.ini) is located in the same directory as the executable for Teradata Studio Express, Teradata Studio, or Eclipse. You must run knint to initialize your Kerberos credential before launching the product.

You want to check your krb5.ini file located under C:\Windows or C:\winnt or if specified in .ini.

Sample TeraJDBC.config:

com.sun.security.jgss.initiate

{

com.sun.security.auth.module.Krb5LoginModule sufficient

useTicketCache=true;

};

other

{

com.sun.security.auth.module.Krb5LoginModule required ;

};

Re: Studio 15.11 Available for Download

i have a question.

I installed  teradata studio

I commended "select"

But result data was character that was Borken

table was created by  LATIN NOT CASESPECIFIC char option 

AND I USE UTF8   TO CONNECT  JDBC CONNECTOR

how can I resolve this problem?

Teradata Employee

Re: Studio 15.11 Available for Download

Is the characters supported by the Teradata Database? If you are storing characters in a LATIN column that are supported by the Teradata Database for the server-side LATIN character set, then the you should be able to retrieve those characters using CHARSET=UTF8 or CHARSET=UTF16.

But, if you are storing characters in a LAIN column that aren't supported by the Teradata Database for the server-side LATIN character set, then you will not be able to retrieve those characters in a supported manner. You can use the unsupported scheme of omitting the CHARSET connection parameter and specifying the unsupported CLIENT_CHARSET=<JavaCharsetName> connection parameter.

Teradata Employee

Re: Studio 15.11 Available for Download

Hi, 

I'm from the InfoSec team and I am tryinng to configure SSO for Aster (using Dell Quest on Aster).  I do not know what entry to put for "Service Name" or "JAAS Login Configuration"  I have searched the drives for jaas.conf, but it does not exist.  Can you send me the info on both entries--esp the jaas.conf contents?

Thanks!

Enthusiast

Re: Studio 15.11 Available for Download

Hi Francine,

I am missing some functionality already in SQLA... with Oracle SQL developer any SQL statement that is correctly closed with ";" can be executed seperately via a shortcut (ctrl+enter). In Studio there is no such option. When working daily with SQLA/Studio and every time opening a new SQL window or highlighting the SQL code that you want to run is... annoying.

Feature request or am I overlooking something?

Teradata Employee

Re: Studio 15.11 Available for Download

The service name is the name of the queen node + the KDC: ncluster/name-of-queen-node.KDC

The jaas.conf file needs to sit on the system that Studio is installed on. The contents should be:

Client {

     com.sun.security.auth.module.Krb5LoginModule

     useTicketCache=true;

};

Teradata Employee

Re: Studio 15.11 Available for Download

@Johannes, There are shortcut keys for executing statements in the SQL Editor, such as Ctrk+Alt+X to Execute All (like SQLA Execute), Alt+X Execute Selected Text, F5 to Execute as Individual Statements (like SQLA's Execute in Parallel), Alt+S Execute Current Statement. The only one you must highlight the SQL is for Execute Selected Text.

You can also execute the SQL in a SQL without having to Open the SQL File by right clicking on the file in the Project Explorer and choose 'Execute SQL Files'.

Ctrl+Enter is already used to invoke code assist in the SQL Editor. 

Teradata Employee

Re: Studio 15.11 Available for Download

Thanks Isharma!  Would the service look something like this:

queen name: queen.customer.local

KDC = windc1.customer.local

Service=ncluster/queen.windc1

Thanks!