Teradata Studio 15.10 is now available for download. Teradata Studio is an administration tool for creating and administering database objects. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX. It is built on top of the Eclipse Rich Client Platform (RCP) which allows Teradata Studio to benefit from the many high quality Eclipse features available while focusing on value-add for the Teradata Database.
Teradata 15.10 Support
Added support for Teradata 15.10 Database and embedded the Teradata JDBC 15.10 driver.
Provides support for Query Bands within the Connection Profile. Also provides support for Query Bands within the Database PROFILE object when created using the Administer Profile dialog.
Studio 15.10 provides an option to add one Database/User at a time to the Data Source Explorer (DSE). By setting the Data Source Explorer Load Preference to 'User Choice', the Add Database menu option appears for you to enter the name of the Database or User to add to the DSE tree. Another DSE improvement is that ability to set the ROOT of the DSE tree. By checking the Data Source Explorer Load Preference option 'Show Databases and Users in Hierarchical Display', the Set Root menu option appears for you to enter the name of the Database or User you wish to be the root of the DSE tree.
Studio 15.10 also provides Data Source Explorer load performance improvements. Two new options are available in the Data Source Explorer Load Preferences, 'Load tables space and journal details' and 'Load View Columns Data Types'. Unchecking these options will improve the time it takes to load the Tables and Views folder in the DSE.
Studio 15.10 added a new preference for the Result Set Viewer to allow reuse of the Result Set Viewer tab. Checking this option will cause the Result Set Viewer to reuse the current window with the new result set generated by the SQL Editor. Also added to the Result Set Viewer is a new toolbar button to clear all Result Set windows.
This feature allows the user to send the query result set data to a file instead of displaying it in the Result Set Viewer. The user will set the Results Handler value on the SQL Handling Preference page. When the next query is executed, the Export Data Wizard is invoked for the user to specify the export file location and file options.
Added enhancements to the SQL History View Preferences to allow users to select the columns displayed and control the number of rows loaded in the SQL History View.
Smart Loader and Teradata Load have added an option to allow the user to specify the OS line separator or a fixed width column delimiter, as well as providing the user better control over the handling of errors in the load input file. When an error occurs trying to load the row of data, the error row is stored in an error file. An option has been added to stop the load after 'n' number of errors has occurred. The user can also restart the Teradata Load, specifiying the row number of the input file to start the load from.
Teradata Load has also added a preview panel to show a sample of the load input file based on the file options (such as column delimiter, string delimiter, encoding) chosen. This will help the user to verify that the file options are correct before starting the load.
Added support for Aster 6.10 Database and embedded the Aster JDBC 6.10 driver. Studio 15.10 also includes an Aster 6.10 Parser to detect syntax errors and provide content assist for SQL statements within the SQL Editor, along with SQL formatting and Outline view support.
Provides Aster Administration user interface for creating and dropping Database, Schema, Role, User, Table, and View objects, as well as granting and revoking privileges for all Aster objects.
Provides support for Templates View of Aster analytics templates. Users can drag and drop analytic functions from the list in the view to the SQL Editor to display a template for that analytic function.
These features will use the new Aster 6.10 DISPLAY command to generate and display the DDL for Aster Database objects. The menu options are provided in the Aster menu when in the Administrator perspective.
Provides support for comparing two Aster database objects. The user selects an Aster object in the Data Source Explorer and then chooses the Compare With option from the Aster menu. This invokes the Aster Compare dialog for the user to select the object to compare with. The two objects' DDL are displayed side-by-side in the Eclipse Compare Editor.
Provides additional templates for Teradata, Aster, and Hadoop tables using the Generate SQL menu option.
Added administration support for Teradata FOREIGN SERVER objects. A user interface is provided to create, drop, and alter FOREIGN SERVER objects for Teradata Database version 15.00.02.04 and above.
Added support for Hortonworks Knox connections, Cloudera support for Hadoop to Teradata Smart Loader, and SQL-H support for Hadoop to Aster Smart Loader. Also added is HiveQL support using the HiverServer2 JDBC driver that comes embedded with Studio. HiveQL support will allow users to execute HiveQL statements in the SQL Editor and display the result set data in the Result Set Viewer.
Studio 15.10 provides an install configuration file that allows distribution centers to create a configuration file, containing connection profile definitions, that is loaded during the install. This feature is provided with the Windows Studio install package.
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). To ask questions or discuss issues, refer to the Teradata Studio Forum and post your question.
Online Help can be accessed within Teradata Studio:
Reference Documentation can be found on the download page or at: www.info.teradata.com
Cannot Export Result Set
Using "Teradata Studio 15.10 - 64-bit" on Windows 7 64-bit, in the 'Teradata Result Set Viewer', clicking the 'Export result set to an external file' button causes TDS to hang for about 2 minutes; after which nothing happens. Same thing happens when clicking the 'Toggle Result Set' button. Any advice would be greatly appreciated.
Dave, I haven't heard this issue before. How big is the result set? What format were you exporting to CSV , Excel? Can you open an incident and submit the error logs? One thing to try is to restart Studio with a clean workspace and see if something was corrupt. To do this, you can just rename the old workspace directory, located in your USER directory and called workspace-studio. Thanks.
I'm trying to familiarize myself with the Administrator perspective of Studio. In Teradata Administrator, I am able to right click on a user and see all of that user's role memberships.
I am not able to do that in Studio... at least so far. Am I missing something?
Kimberly, Since the roles are created at the Database level, they are shown when the Database node is selected. While in the Administrator perspective, select the Database node in your Data Source Explorer. In my case, I logged in as dbc so my Database Source Explorer shows DBC next to the database node. Select the node and the Roles tab will appear in the Object Viewer. You can view the existing roles, create a new role, or add a user to an existing role.
I upgraded from Teradata Studio 14.10 to 15.10 on Mac OSX 10.9.5. The install completed successfully but when I launch it, the splash screen comes up and nothing happens :(
java version "1.6.0_65"
Java(TM) SE Runtime Environment (build 1.6.0_65-b14-462-11M4609)
Java HotSpot(TM) 64-Bit Server VM (build 20.65-b04-462, mixed mode)
Gopal, We have seen problems with JRE 1.6. Can you upgrade to JDK 1.7 or later to see if that resolves the problem? With Mac OSx, you must install the JDK, as the Mac OSx version of the JRE is missing libraries needed for Java applications.