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:
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.
Provides support for Presto JDBC with Hortonworks and Cloudera Hadoop connections. Studio supports Presto version 141t.
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).
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.
Provides additional UI enhancements that include:
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.
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.
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:
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.
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:
Reference Documentation can be found on the download page or at: www.info.teradata.com
If using Kerberos, you need to set up the credentials. Here is a section from our Studio Help Content:
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:
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.
com.sun.security.auth.module.Krb5LoginModule required ;
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?
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.
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?
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?
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:
@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.
Thanks Isharma! Would the service look something like this:
queen name: queen.customer.local
KDC = windc1.customer.local