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.

Need Help?

For more information on using Teradata Studio Express, refer to the article, Teradata Studio Express.

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-056K
Discussion
wmmiteff 8 comments Joined 02/11
13 Jun 2016

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

fgrimmer 660 comments Joined 04/09
13 Jun 2016

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 ;
};

cbs200000 1 comment Joined 11/14
15 Jun 2016

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?

fgrimmer 660 comments Joined 04/09
17 Jun 2016

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.

sluebke 3 comments Joined 01/12
22 Jun 2016

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!

Johannes Vink 3 comments Joined 08/14
22 Jun 2016

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?

isharma 3 comments Joined 06/12
23 Jun 2016

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;
};
 

fgrimmer 660 comments Joined 04/09
23 Jun 2016

@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. 

sluebke 3 comments Joined 01/12
23 Jun 2016

Thanks Isharma!  Would the service look something like this:
queen name: queen.customer.local
KDC = windc1.customer.local
Service=ncluster/queen.windc1
Thanks!

sluebke 3 comments Joined 01/12
23 Jun 2016

Thanks Isharma!  Would the service look something like this:
queen name: queen.customer.local
KDC = windc1.customer.local
Service=ncluster/queen.windc1
Thanks!

isharma 3 comments Joined 06/12
23 Jun 2016

the service name should look something like this according to your info: ncluster/queen.customer.local.WINDC1.CUSTOMER.LOCAL
just a note - i believe the KDC needs to be entered in caps

Johannes Vink 3 comments Joined 08/14
28 Jun 2016

Hi Francine, alt+s is what I was looking for! Working nice. I did indeed overlook this one. Thanks.

04 Jul 2016

Being new to Eclipse, is there any way to install additional features/plug-in's in TD studio?  Looking to install Python features.  Plug-in's are available on the web.
BTW, I haven't programmed in a long, long time so consider me a newbie when it comes to the IDE's.
Thanks.
G.
 

Garrett Sienkiewicz

fgrimmer 660 comments Joined 04/09
05 Jul 2016

Garrett, Teradata Studio does not support adding Eclipse plugins. You would want to install Eclipse (version 4.5.2) and then install our Teradata Plug-in for Eclipse. The Teradata Plug-in for Eclipse includes all of the functionality as Studio.
I believe there are tutorials for using Teradata Python libraries that should help.

Joao Fialho 2 comments Joined 11/14
31 Jul 2016

Hi

where can I find the "References" functionality in the new Administration Perspective?

BI Lead Developer
Business Intelligence, Agile Data Labs
Maersk Line IT
A.P. Moller – Maersk A/S

fgrimmer 660 comments Joined 04/09
31 Jul 2016

We are working on getting this feature into the new Administration perspective for our 16.00 release.

Joao Fialho 2 comments Joined 11/14
01 Aug 2016

When is to be expected the new 16.00 release?
Thank you!
 

BI Lead Developer
Business Intelligence, Agile Data Labs
Maersk Line IT
A.P. Moller – Maersk A/S

fgrimmer 660 comments Joined 04/09
01 Aug 2016

We are still in the planning phase for 16.00 and currently looking at December timeframe.

JosephJFuller 2 comments Joined 04/14
16 Aug 2016

I think I read somewhere that we could use viewpoint portlets with Teradata Studio 15.11, true?  That would be really handy!

Joe Fuller

fgrimmer 660 comments Joined 04/09
16 Aug 2016

Joe, I am not aware of that capability. It may be possible to somehow open a browser inside Studio but that is not currently provided. 

JosephJFuller 2 comments Joined 04/14
17 Aug 2016

thanks, just wanted to check.  We are getting requests for users to be able to monitor their own queries. We were concerned that the viewpoint servers couldn't handle the additional workload of so many users logged on, so this seemed like an interesting solution. 

Joe Fuller

wuchen7325 2 comments Joined 01/16
27 Aug 2016

Seems like a bug when I turn on the cache databases.
After I trun on the cache, the filter doesn't work anymore,
it always show all the table objects and ignore the filter.

wuchen7325 2 comments Joined 01/16
27 Aug 2016

Sounds like issue with data transfer. After I  use smart load once. It stop working. Not load new data, Just hanging there. No error message. Who should I ask for support?

fgrimmer 660 comments Joined 04/09
29 Aug 2016

Mark,  I recreated your issue with the Cache and DSE Filter. I will open a JIRA for that to get fixed. Please open an incident for the smart load issue so we can gather more information on this problem. You can open an incident through Teradata Support, Teradata at Your Service (T@YS).

gbethardy 1 comment Joined 01/15
31 Aug 2016

how do we make this work with the latest version of java?

Regards,
Greg Bethardy

fgrimmer 660 comments Joined 04/09
31 Aug 2016

Greg, If you have a version of Studio prior to 15.11, the path to your JRE was stored in the TeradataStudio.ini file. The .ini file is located in your install directory. You can change this to reflect the new location of your JRE. In Studio 15.11 we have removed this parameter if you use the default location for your JRE.

rajasekhar t 1 comment Joined 08/16
05 Sep 2016

hi, please help...
how to install sql assitant on windows 7 64-bit . 
 
 
Thanks
Rajasekhar
 

sblanco5 1 comment Joined 09/11
08 Sep 2016

Hi,
I'm using the Teradata Studio Version 15.11, version 32 and 64 bits, and I was testing the option to load a volatile table.
My table is very simple:

CREATE VOLATILE TABLE PRUEBA

 (NUM_LIQ VARCHAR(15))

 PRIMARY INDEX(NUM_LIQ)

 on commit preserve rows

 ;

 

I put on commit preserve rows otherways the data is erased when the transaction finishes.

 

The problem is I try to load several thousands of rows, and I get this error:
java.lang.StackOverflowError
In the analysis phase I seems the tool uses fastload to load the volatile table.
Is it normal that I get this error?  
Can I  fix the problem with any java, configuration?  I used both versions 32 and 64 bits.
Any throughs?
Thanks
Santiago
 

fgrimmer 660 comments Joined 04/09
08 Sep 2016

Santiago, Can you include the entire stack trace? I am not aware of any problems with loading a volatile table.

You must sign in to leave a comment.