Teradata Studio Express is a graphical Java program, developed on the Eclipse Rich Client Platform (RCP), that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.
This is a nice tool which can connect many DBs like Aster database, DB2 for LUW, DB2 for i5/OS, DB2 for z/OS, Oracle, SQL Server, Generic JDBC connection and of course TeraData DB.
You can download Teradata Studio from HERE. For more information about Teradata Studio visit HERE. You also need the DB Drivers ( JDBC drivers/jar files ) for connecting DBs from HERE