Teradata Studio Express 14.01 is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems. 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 Express to benefit from the many high quality Eclipse features available while focusing on value-add for the Teradata Database.
A new Find button has been added to the Data Source Explorer (DSE) toolbar to find a database object in the DSE tree. Find can also be invoked by entering Ctrl+F shortcut key. The Find operation will open a dialog for you to enter the search value and select a database object type. It will start the search relative to the selected object in the DSE. For example, if you have selected a connection profile node, the find operation will search all of the schemas on that Teradata server. If you have selected a specific schema (or database), the Find operation will search only that schema. Upon locating the object, the Find will select the object in the DSE. If the Teradata View is opened and in focus the object will be opened in the Teradata View.
A Find Next option has been added that will find the next object in the DSE tree that matched the previously entered search value and object type. Find Next uses the F3 shortcut key.
Advanced Find Dialog
An Advanced Find dialog is also provided that allows you to choose more detailed find options and presents the list of all objects that match the search value. The Find dialog contains an Advanced Find button to invoke the Advanced Find dialog. The dialog allows the user to select the specific connection profiles or schemas to search, the type of objects for which to search, and a limit on the number of objects found. The search result list is presented in the Teradata View.
A Filter option has also been added to the lists that are displayed in the Teradata View for Schemas, Tables, Macros, Stored Procedures, Indexes, User Defined Functions, User Defined Types, and Views. The user can filter the lists by a starting value, ending value, or containing value.
For more information on using Teradata Studio Express, refer to the article, Teradata Studio Express.