0 - 33 of 33 tags for teradata studio

Teradata Studio is an administration toolkit that helps users to create and administer database objects. It also provides a SQL Editor and Result Set Viewer for retrieving and displaying data fron your Teradata Database systems (Teradata, Aster, and Hadoop). It is built on the Eclipse Rich Client Platform (RCP). For more information on Teradata Studio, refer to the article Teradata Studio.

Hello:
I installed Teradata Studio 15.11. For Data Source Explorer to list less objects, from Windows--Perferences--Teradata Datatool Preferences -- Data Source Explorer Load Preference, I try to select User Choice (includes DBC) for What to load. However, this option is grayed out.
I don't have the problem with the version 15.10.

How can I save/export my Teradata Studio application preferences in the event I want to share them with a co-worker or make a backup?

Windows Version 15.10.11

I can't fin a setting within Studio that gives me another display setting than the US.
For decimals/money etc I want "999.999,99". Where '.' is 1000 separator and ',' is decimal separator.
This is the default Systems settings for me. But Studio overrides them.
Anyone?

For some reason Studio has started freezing up over the last day.  I will be working in Studio and then suddenly I will get the pinwheel spinning forever and the application stops responding.  I have updated to the most recent version of studio and still experience the same behavior.  Nothing has changed on my system in the last couple of weeks.

I was installing the latest 15.10.01.01 on my windows VM and Defender detected a Trojan on the setup.exe file ? I've since stopped the install and cleaned up the files.  Probably need to have this validated by someone quickly ?
See screen shot I've uploaded on this post.
 
Todd 

Just downloaded the Profiler package and performed the necessary copy of JAR files to the terdata studio plugins folder.

I'm on OSX 10.11.2 and the latest studio 15.10.01 launches and just stops at the splash/logo box.  No GUI or anything... I've got JRE 1.6 installed and previous version worked just fine before this one.  Any thoghts?

Teradata is without a shadow of a doubt, the worst database client software available, it is slow, clunky, crashes frequently, and if a connection to a database drops, it ends up in an endless loop of "connection lost" errors that can only be termiated by force-quitting the entire program, loosing valuable work.

Hi,
I'd like to connect to a Oracle database using Teradata Studio 15.0.01 but I'm missing the tab "New Profile Connection Types" in "Window" - "Preferences" - "Teradata Datatools Preferences".
Any ideas?
Regards
Daniel

When I run a query

ALTER TABLE tablename DROP COLUMN columnname;

from my SQL Assistant, It runs file, but when I run the same in Studio it fails to run.

ALTER TABLE tablename DROP  columnname;

runs fine in STUDIO.

 

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.

Installed TD Studio 15.10 and am trying to create a new Connection Profile.  I select Teradata database and then move tto the "Specify a Driver and Connection Details" page, but it's blank.  I unfortunately can't attach a screenshot, but the dialog box is just completely empty so I can't specify a driver or any connection details.

  1. Teradata Studio doesn't display total row in row limit dialog

SUBSTING function is giving error in Teradata Studio which was working fine in Teradata SQL Assistant.
My Query is like this : SEL SUBSTRING('ABC',1,2)
I do not want to use SUBSTR instead of SUBSTRING as it involves making changes in a lot of Queries. Please suggest a work around for this issue.
 
Thanks!
Anirudh

Hi,
 
I've just got TS working (finally) and have come across the following which I think is a bug.
In "Preferences / Result Set Preferences" one option is 'Long Text Boundary Size', default of 150.
The help for this says 'Enter the boundary size for display of long text values. Zero (0) indicates no truncation will occur.'

I am using the Mac version of Teradata Studio and I am not finding a way to refresh the data source view.  Specifically, I have created a table in the database, and it does not show up.  I know it is there because I can query from the table.  On a PC, I would just right click and refresh.  However I am not sure how to accomplish this task on my Mac.

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

 

Hi
after Installation of Teradata Studio 14.10.01 we encountered a huge number of requests to DBC; apparently from Teradata Studio requesting information on database objects (~200,000 requests in this case within a day).

Hello @ll,

I'm new on Teradata and I'm facing some troubles trying to connect to a TD12 using Teradata Studio 14.
I have this error:

Get a quick start on Teradata Studio and Teradata Studio Express with these usage videos. The overview and connection videos apply to both Teradata Studio and Teradata Studio Express. The others apply to Teradata Studio only: Create Database, Create Table, Move Space, Smart Loader, Copy Objects, and Transfer Data.

Hi all,
this is not about error/issue, more-like it is about hint/note for future improvements.
When there is prepare phase for testing, we have to drop several tables/databases and load them with test data. So in total we are executing around ~5000 of total statements (lenght around 60 000 up to 300 000). So far so good. 

Teradata Studio's Copy Object Wizard allows users to copy objects by simply dragging the object from the Data Source Explorer tree and dropping it into the destination node in the Transfer View tree. Often users have created objects in their test database and wish to copy it to production, or copy objects from production into their test data lab environment. Database objects can be copied within the same database server or to a different database server. You can copy more than one object at a time by selecting multiple objects from the Data Source Explorer and dragging them to the Transfer View tree. Due to the external code location, External Stored Procedures and User Defined Functions can not be copied.

The Copy Object Wizard also allows you to filter out columns or column data when copying tables. You can also copy table data to an existing table, providing a map of source columns to destination columns.

Teradata Studio 14.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.

Hi,

Hi,
I am using Teradata studio express in Macbook pro.
The Application is abruptly closing every time I try to open it.
It was working for almost a day after upgrading the SQL Client.
I've reinstalled the application and restarted the system. yet it is not working.

Teradata provides three Eclipse-based client tools, Teradata Studio, Teradata Studio Express, and Teradata Plug-in for Eclipse. All three products are built from the same code base and provide connectivity to your Teradata Database, but each has a different end user focus.

Teradata Studio Express 14.02 now supports Aster database connectivity. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Aster database systems. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.

Teradata Studio 14.02 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.

Hi, we would like to use TD studio (version 14.01) which looks like very interesting and powerfull tool. However it seems that the tool does not support stored procedures. At least, we haven't been able to run any stored procedure yet. The Studio returns an error message:

Teradata Studio 14.01 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.

Teradata Studio is a client based graphical interface used to perform database administration tasks on Teradata and Aster Databases, as well as copying data between Aster, Teradata, and Hadoop Database Systems. Teradata Studio is built on the Eclipse® Rich Client Platform (RCP), taking advantage of the RCP framework for building and deploying native GUI applications. It extends the Eclipse Data Tools Platform (DTP) to enhance Teradata Database access. Teradata Studio can be run on Windows, Linux, and Mac OSX operating systems. The Eclipse platform is designed as an open tools platform but architected so that its components (or a subset of its components) can be used to build RCP applications. This allows Teradata Studio to benefit from the many high quality Eclipse features available while focusing on value-add for Teradata.

With the Studio 15.11 release, a new user interface was introduced in the Administration Perspective. Refer to the article, New Studio Administration User Experience for more information.

In addition to this article, there is a Teradata Studio User Guide document now available on the Teradata Studio Download page.