Teradata Studio Express 15.00 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.

What's New:

  • Aster 6.0 Support

Added support for the Aster 6.0 Database and embedded the Aster 6.0 JDBC Driver.

  • Aster Smart Loader, Table Load and Export Wizards

Smart Loader, Table Load and Table Export Wizards now support the Aster Database. Users can invoke the load and export wizards from the Data Source Explorer.

  • Aster Table Editor

The Studio Express Table Editor has added support for Aster tables. Users can invoke the Table Editor by selecting the table in the Data Source Explorer and choosing the Data>Edit Data option. The Table Editor supports paging and filtering of data for large tables.

  • Teradata 15.00 Support

Added support for the Teradata 15.00 Database. This includes support for the 15.00 Teradata grammar in content assist, as well as support for JSON data types. Teradata Studio Express 15.00 has also embedded the Teradata 15.00 JDBC Driver.

  • SQL Editor Enhancements

The SQL Editor has been enhanced to provide an Auto-commit toggle, Commit and Rollback toolbar options. This enhancement allows the user to manually manage the "commit" operation on their SQL statements. By default, the Auto-commit option is on. The user can toggle Auto-commit off and manually commit or rollback SQL statements to the database.

Another SQL Editor enhancement is the ability to link a SQL Editor window to a Result Set Viewer window. This allows the user to better manage multiple SQL Editors and Result Set Viewers.

  • Disk Cache

Allows large objects, such as CLOBS, BLOBS, JSON, or large text data types to be cached on disk for Export, Load, and Editing.

Need Help?

For more information on using Teradata Studio Express, refer to the article, Teradata Studio Express. 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 > Teradata Studio Express
  • 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 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 Release Definition Publication ID: B035-2040-014C
  • Title: Teradata Studio, Studio Express, and Plug-in for Eclipse Installation Guide Publication ID: B035-2037-014K

 

Discussion
jorgen.seider 4 comments Joined 03/11
01 May 2014

Hi
I have just started using Teradata Studio (15) and have a question.
Is there a way to make a connection (to Teradata) point directly to an underlaying database, as it is possible within the old Teradata Administrator?
Thanks
Jorgen
 

fgrimmer 486 comments Joined 04/09
01 May 2014

Jorgen, You can specify a database to include in the connection URL. This will become your default database.

jorgen.seider 4 comments Joined 03/11
02 May 2014

Hi
I already tried that, but for some reason it is ignored. The TD Studio database entrypoint is still a the toplevel database.
In JDBC Connection Properties I tried to
  use the Database Name field
  add directly to the connection url (jdbc:teradata://host/database=PROJEKTER), leaving the Database Name field empty
       The Test Connection succed, but the result is the same, I guess it is overwritten.
 
We have a hierarchy of databases. Our TD version is 13.10
The Root Database field in TD administrator (14.10) has not problems with this.
 
BTW. Is it possible to attach documents to this type of conversation?
         Screendumps or parts of it , is a great awy to cummunicate.
 
Jørgen

fgrimmer 486 comments Joined 04/09
02 May 2014

Jorgen, Setting the default database does not change the Data Source Explorer tree root that is displayed. To change the databases that are displayed, you can add a filter to the Databases folder or change the Data Source Explorer Load options in the Preferences.

jorgen.seider 4 comments Joined 03/11
13 May 2014

I tried to filter.
When I check the "Selection" checkbox in the filter dialog window, it runs forever. Tried this both on XP and Windows 7. Same result.
I can send you the screen dump of the debug information box, that comes up, when I kill the TD Studio process.

franbig 1 comment Joined 05/14
14 May 2014

Hi, i am new in teradata, i tried to installl teradata express but  there are a problem when i will execute it , the windows is closed and i can´t work in aplication.

fgrimmer 486 comments Joined 04/09
14 May 2014

Jorgen, It can take a long time to get the list of databases and users if the list is large. Try first to change the display to not show hierarchical. Go to Window>Preferences?Teradata Datatools Preferences>Data Source Explorer Load Preferences and uncheck the 'Show Databases and Users in Hierarchical Display'

fgrimmer 486 comments Joined 04/09
14 May 2014

Francisco, Are you trying to install Teradata Express or Teradata Studio Express? These are two different products.

jorgen.seider 4 comments Joined 03/11
15 May 2014

Thanks that helped a lot.
When I cannot have default dabase with hierarchy like in TD Administrator, this is okay.
But I guess it will take some time to get rid of the Administrator :-)

gd186007 4 comments Joined 03/13
18 May 2014

java version "1.7.0_51"
the version of jre is higher than the version of request(1.6)
then install process couldn't finish
 

fgrimmer 486 comments Joined 04/09
19 May 2014

@gd186007, Are you installing on Windows or Mac? We have seen a problem with that specific version of the Windows JRE (1.7.0_51) where the PATH is not updated with the location of the JRE bin directory.  Does the java -version command return the correct version of the JRE? If not, can you update the PATH to include your JRE bin directory?

madhugraju 6 comments Joined 05/11
22 May 2014

Hello, the mac version of the download for Teradata studio 15 does not have the collect statistics, Data Compare or the Smart loader wizard.  Is this by design or am I missing something?  
The tool only contains Administrator, Query Development and Data Transfer.  
Appreciate your help.

fgrimmer 486 comments Joined 04/09
22 May 2014

Madhukar, The menu options on the new Teradata Studio 15.00 have moved a bit. The Collect Statistics is associated with the Teradata Administrator perspective. Choose that perspective, then locate the table or column to collect stats on, right click and open the Teradata>Statitics menu option. The Compare object dialog was replaced with the Compare With Wizard. Compare With menu option is provided for all three perspectives. Choose the object, right click and choose Teradata>Compare With. The Smart Loader is associated with the Data Transfer perspective. Choose that perspective. Then locate the database or schema (if Aster) and right click on the Tables folder. Choose the Teradata (or Aster)>Data Transfer menu option. Choose the Source as External File (Smart Loader). Sorry for the confusion. We hope the new perspectives make it easier to navigate the UI and focus on certain tasks.

Chrispen 3 comments Joined 05/14
22 May 2014

Is there a version that runs on MAC OSx 10.9 (Mavericks). All I see are downloads compatible up to 10.8.
 
Thanks,
Nicole

fgrimmer 486 comments Joined 04/09
23 May 2014

Nicole, we have not certified on Mac OSX 10.9. We are currently working on getting this certified.

Harald Wieber 1 comment Joined 10/07
28 May 2014

Hi Francine,
I'm using TD-Studio on different Systems (Customer/my Laptop). Is there an easy way to move the custom Keys from one system to another system?
Kind regards
Harald

fgrimmer 486 comments Joined 04/09
28 May 2014

Harald, Any custom key bindings would be stored in your workspace. Can you maintain the same workspace between the two systems?

madhugraju 6 comments Joined 05/11
28 May 2014

I am using this on a mac OSx 10.9 without any issues.  My only complaint is that it is very slow in its response as compared to SQL assistant/Teradata Administrator.  Maybe that is why it is not certified for 10.9 and not to be used on 10.9.

madhugraju 6 comments Joined 05/11
28 May 2014

Is there any option where I can provide a default database and not have to browse through the entire database hierarchy every single time?  Does the tool execute queries against the dictionary every time we browse through the hierarchy or is it cached locally and consumed from there?

fgrimmer 486 comments Joined 04/09
28 May 2014

@Madhukar, We have not begun testing on Mac OSX 10.9. Is the slow response time you are seeing in scrolling?
Also, you can filter the list of databases or choose Data Source Explorer Load Preferences (in Window>Preferences>Teradata Datatools Preferences) to minimize the list.
Queries are executed to obtain the metadata and create the objects. Once created, they are cached. Object are created from browsing the Data Source Explorer or opening the object in the Object Viewer or via the dialogs when requesting objects.

madhugraju 6 comments Joined 05/11
28 May 2014

Francine, thank you for your response.  Login as well as the overall experience is slower as compared to SQL Assistant and Teradata Administrator.
Is there a custom filter that I can specify to only load a single database or databases below a single hierarchy? 
I see a limitation in the current options provided and was hoping we can have a custom filter where we only load what we want.
Thank you

fgrimmer 486 comments Joined 04/09
28 May 2014

@Madhukar, If you right click on the Databases folder and choose Filter you can select the database you want. Uncheck the 'disable filter' and select the database you want to load in the DSE. If you have a large number of databases and user, change the DSE Load Preference to uncheck the 'Show databases and users in hierarchical display'.

AB75151 2 comments Joined 06/09
31 May 2014

Hello,
I tried to do a fast load through TD studio express, I am able to succesfully load data up until 5 million records. But anything above 5 million, it is giving no errors.. All I see is an error box with no description.
 
Thanks!
PV

AB75151 2 comments Joined 06/09
01 Jun 2014

Another observation, A file with 6M records, doing Prod copy to test env. I am able to load it through 15 but not through 14. Again, error with no error description. Blank Dialogue box comes up with a close button. Thats it.

fgrimmer 486 comments Joined 04/09
02 Jun 2014

@AB75151, Just to clarify, the blank dialog box appears with version 14 but not 15? Was the 5 million load also tried on version 14 or 15?

jvanoppen 1 comment Joined 07/11
17 Jun 2014

I have encountered a formatting issue when copying and pasting blocks of text from TD Studio into MS Word.
When you highlight text in TD Studio and paste it into Word the entire block of text remains highlighted and the actual text is blocked and cannot be seen. The only option is to paste it in as plain text and lose the benefit of viewing the code with color formatting of the SQL statements.
The solution is to do an additional step to first copy the text into SQL Assistant and then recopy and paste it into Word. When you hightlight text in SQLAssistant and paste it into Word it will copy the color formatted text without any background coloring to show the text block was highlighted.
Can you add this as a bug fix for a future release to simplify the copy/paste process out of studio and into Word.

fgrimmer 486 comments Joined 04/09
17 Jun 2014

Jan, I think the problem is that the text is highlighted so when it is pasted into Word, it is obscured. Try turning off the 'Highlight current line' option in the preferences. This option is located under General>Editors>Text Editors page. Uncheck the option.

Qw3ry1on1 1 comment Joined 06/14
20 Jun 2014

In the editor, highlighting a string of text (be it a field name, table name for example) and having all occurrences that are the same be highlighted as well. This is extremely useful to me for development and debugging SQL code.
Teradata Studio may have this already, if so where is it, if not is there a plug in or any additonal suggestion(s)?

m.knauss 1 comment Joined 07/09
20 Jun 2014

Is there a way to have Teradata Studio automatically check for updates and then prompt for download/install like on other applications?  I checked under the "Help" menu where I usually see this function but did not see it there. 

fgrimmer 486 comments Joined 04/09
20 Jun 2014

@Qw3ry1on1, Take a look at the Syntax Coloring preferences under Window>Preferences then go to Data Management>SQL Development>SQL Editor>Syntax Coloring for current options for coloring words in the SQL Editor.

fgrimmer 486 comments Joined 04/09
20 Jun 2014

@Martie, There is not a current option for automatically checking for updates within Studio. But if you install Eclipse and our Teradata Plug-in for Eclipse you can set up automatic updates through the Preferences>Install/Updates. Most of the input from our Studio customers is that they want to control updates. But I will add this to our list of future Studio features.

Chrispen 3 comments Joined 05/14
08 Jul 2014

I am trying to download this on my MAC but keep getting an error when it gets to the Validating Files part. On the Install Teradata Studio Express screen it says: "The installation failed. The installer encountered an error that caused the installation to fail. Contact the software manufacturer for assisstance."
Any help getting this installed would be helpful.
Thanks,
Nicole

fgrimmer 486 comments Joined 04/09
08 Jul 2014

Nicole, Which version of Mac OSX? Do you have the Apple JRE 1.6 installed?

Chrispen 3 comments Joined 05/14
11 Jul 2014

OSX 10.9.3 and yes I do have JRE 1.6 installed

fgrimmer 486 comments Joined 04/09
14 Jul 2014

Nicole, We have not certified with Mac OSX 10.9.

Gyanendra 6 comments Joined 03/11
23 Jul 2014

Hi Francine,
Is there any way to get password from TD wallet in TD Studio 15.0? If not, will it be included in future versions?
Thanks,
Gyanendra

fgrimmer 486 comments Joined 04/09
23 Jul 2014

We currently do not have support for Teradata Wallet but it is planned for future release. 

kurmarao1 7 comments Joined 02/14
29 Jul 2014

Don't we have a teradata tool ,which has inbuilt C/C++/VC++ compilers to executes the Stored procedures?.. Thanks..

fgrimmer 486 comments Joined 04/09
29 Jul 2014

Kurmarao, With Teradata Studio or Studio Express, you can execute (Run... menu option) C/C++/VC++ stored procedures. But we don't include compilers for C/C++/VC++. You must build them and load outside the tool. That functionality is on our list of future features but currently low priority.
We do provide tools to help build and load Java stored procedures as part of our Teradata Plugin for Eclipse product.

raja.banerjee 1 comment Joined 08/14
2 months ago

Do we have a step by step guid of installation including creation of seting up dbc database.
I have installed Teradata express 15. Now i need to install the utilities. Do let me know how do i go about it
 
Thansk
Raja Banerjee
 

fgrimmer 486 comments Joined 04/09
2 months ago

Raja, This article is for Teradata Studio Express, which is a client tool for connecting to Teradata Database (or Teradata Express). Please post your question to the Cloud Computing Forum (http://forums.teradata.com/forum/cloud-computing).

2 months ago

Hi Francine, I just upgraded to Studio Express 15 and it seems more than half the time a few minutes after starting, typing in the SQL editor feels like it's on time delay. It's almost unusably slow. I'm on Mac OS 10.9.4, Macbook Pro with 16GB Ram, connecting to a TD 14.10 instance. I've already modified the Eclipse memory settings to no effect (see below). Any ideas? Any way to downgrade to 14.10? Thx!
 

-Xms1024m

-Xmx1024m

-XX:MaxPermSize=1024m

fgrimmer 486 comments Joined 04/09
2 months ago

Claus, If you are having a delay when typing in SQL Editor, you can try turning off code assist. Go to the Tools menu and untoggle the Code Assist Autoactivation option. Code assist is gathering information about next possible word in SQL statement. If you have a lot of databases it can cause delay.

lzapata 3 comments Joined 02/12
1 month ago

Hi Francine,
I have found an issue in this release 15.00 which didn't happen in previous ones. When I drag a list of columns in a table from the "Data Source Explorer" tree to the editor, the comma, which should be between columns, is misplaced following the qualifier of the table.
E.g.:
ALMHECAMORTIZATIONMES_V.FECHAREGISTRO_MDALMHECAMORTIZATIONMES_V., POSITIONID_ID....
Notice the table name is ALMHECAMORTIZATIONMES_V and the result is messy.
This issue is solved by unchecking "Qualify names for drag and drop in SQL Editor" but I need this option on beacuse 2 reasons: first, I work with a lot of distinct databases; and, second, I am used to qualify the columns in SQL with the name of its table/view
Thanks,
Luis

lzapata 3 comments Joined 02/12
1 month ago

Hello;
I am going through several troubles with Parameters in the Sql Editor:
1) Although I use "named parameters" and I reuse the same parameter in several places of a query, the dialog window asks me an independent value for each use in the same query (then, why using named parameters instead of the simple question mark?).
2) I don't find in help topics the file format to specify parameter values "from file" (the dialog window for configuring parameters).
Regards,
Luis

fgrimmer 486 comments Joined 04/09
1 month ago

Luis, We have fixed these issues, drag and drop names and having to repeat named parameters in the Configure Parameters dialog. The 'From File' option for Configure Parameters allows you to specify a file that contains the value for that column. We will enhance the Help to describe this option.

vbdcb 3 comments Joined 12/09
1 month ago

Hi Fran, I need your help. I must be dense - I cannot find in Teradata Studio 15 where to change the colors of SQL keywords in the SQL Editor. Can you point me in the right direction? Thanks!

fgrimmer 486 comments Joined 04/09
1 month ago

David, Go to Window>Preferences>Data Management>SQL Development>SQL Editor>Syntax Coloring. You can also type in a 'filter text' into the Preferences box, such as the word 'coloring' to search for the preference page.

vbdcb 3 comments Joined 12/09
1 month ago

Awesome! Thanks!

vbdcb 3 comments Joined 12/09
1 month ago

Next question - I'm getting an error when trying to run the SQL Formatter. The error text is "SQL Formatter Exception occurred. See error log for more details".  Where would the log file that it references be?

fgrimmer 486 comments Joined 04/09
1 month ago

David, Typically a formatter problem occurs because the SQL fails the Parser. If there is red squiggly in the SQL then there are parser errors. Make sure you have the correct connection profile selected in the SQL Editor. You can show the Error Log view (WIndow>Show View>Other>Error Log) or logs are stored in the workspace directory (in the .metadata/.log and .metadata/Teradata/teradata.log).

jlasheras 3 comments Joined 08/12
4 weeks ago

Hi Francine,
Excuse me if this question has been answered before, but I couldn't find any reference to my problem.
Please, which are the SELECT access rights a Teradata user needs on DBC specific views of the Data Dictionary in order to display complete information on the Data Source Explorer?
I've tried to grant SELECT on DBC.TablesV, DBC.ColumnsV and DBC.IndicesV, without success, I guess I may be missing one or more additional views.
It works well if I grant access to the complete DBC to our end users, but our security officers don't authorize this, as a user could be accessing information considered sensitive, DBQL views for instance.
Thank you in advance for your help.
Best regards.
- Jorge
 
 

fgrimmer 486 comments Joined 04/09
4 weeks ago

Jorge, By default, Studio and Studio Express will use the 'V' views when accessing the Teradata Data Dictionary for information about the database objects. You can change it to use the 'VX' views in the Teradata Datatools Preferences page for more secure access. Note that the queries take a bit longer with the 'VX' views. To change to the 'VX' views, go to the Windows>Preferences, then the Teradata Datatools Preferences page.

jlasheras 3 comments Joined 08/12
4 weeks ago

Thanks so much for your prompt reply, Francine.
By trial&error I've found I was missing DBC.DatabasesV in my previous list (of course!)
So SELECT access right for the following Data Dictionary views must be granted to the end users in order Data Source Explorer trees can be populated by Studio Express:
DBC.DatabasesV, DBC.TablesV, DBC.ColumnsV, and DBC.IndicesV
Thank you
- Jorge
 

kennyg 2 comments Joined 07/09
3 weeks ago

I'm looking for information on the parameters "TeradataStudio.exe -data" switch. Studio Help file does not have any information on it's use.

fgrimmer 486 comments Joined 04/09
2 weeks ago

Kenneth, Sorry about the missing Help information. It is in the Installation Guide (under Changing the Workspace Directory Location section), but will add to Help as well.
Changing the Workspace Directory Location on Windows Systems
Modify the shortcut that launches the program to change the workspace directory location.
1. Right click the Teradata Studio shortcut on the desktop and select Properties.
2. Add the –data option and new location for the workspace to the end of the Target field:
-data workspaceLocation.
 
Changing the Workspace Directory Location on Linux Systems
1. Specify the new directory in the command line program execution string as shown in
the following example:
./opt/teradata/TeradataStudio/TeradataStudio –data /home/guestUser/MyWorkspace
 
Changing the Workspace Directory Location on Mac Systems
1 Open the Terminal application.
2 Specify the new directory in the command line program execution string as shown in
the following example:
/Applications/TeradataStudio/Teradata/Studio.app/Contents/MacOS/TeradataStudio –data /Users/guestUser/Documents/MyWorkspace.

kennyg 2 comments Joined 07/09
2 weeks ago

Francine,
Thx., for the help.
Ken
 

jb186040 1 comment Joined 07/12
1 week ago

I use to have a viewer where I could monitor running queries and cancel them if needed. I no longer see the viewer and I can't find it in HELP.  How can I activate the viewer again and what is it called?

fgrimmer 486 comments Joined 04/09
1 week ago

James, The running queries can be monitored in the Progress Monitor view. To open this view, click on the Window toolbar>choose Show View>Other... Then choose General>Progress. The executing SQL is shown and can be canceled by clicking the red box cancel icon.
You may have clicked the option to Run in Background for executing SQL.

You must sign in to leave a comment.