What tool (SQL Assistant?) do I use to browse a Teradata database?

Tools
Fan

What tool (SQL Assistant?) do I use to browse a Teradata database?

I'm not going to be using Teradata much, but I may need to browse a particular Teradata database. What tool do I need to install (MS Windows XP) so I can do that? I've heard of "SQL Assistant", but I just can't find it anywhere. I wouldn't mind using the Eclipse plugin, but I tried to install it on Eclipse 3.5, and I got errors trying to install the plugin.
35 REPLIES
Teradata Employee

Re: What tool (SQL Assistant?) do I use to browse a Teradata database?

You can use the Teradata Plug-in for Eclipse, currently supported on Eclipse 3.4.1.
There is an article that will help you get started at: http://devxweb.td.teradata.com/tools/articles/getting-started-with-teradata-plug-in-for-eclipse

The article will reference links to the Eclipse downloads. Hope this helps.
Fan

Re: What tool (SQL Assistant?) do I use to browse a Teradata database?

Not really. I'm using Eclipse 3.5, and it fails to install in that environment. As it's likely not ready for 3.5 yet, I figured I'd need to use some other tool, like this "SQL Assistant" that I've heard about, but which I can't find an installer for.
Enthusiast

Re: What tool (SQL Assistant?) do I use to browse a Teradata database?

SQLAssistant is part of the Teradata Tools and Utilities (TTU) pack. The installer for it can be found on the TTU CD which you (or your DBA) should have received if/when you purchased Teradata.

If you don't have access to that you could try any other free or open source SQL client. For example, DBVisualizer or SQuirrel. Just download the JDBC driver from the Downloads section and add it as a driver to your client. Then you can connect and away you go.
Teradata Employee

Re: What tool (SQL Assistant?) do I use to browse a Teradata database?

Teradata Express Edition 12.0 — Teradata Software for Evaluation and Development (available at http://www.teradata.com/t/teradata-12.0/) includes Teradata Tools and Utilities (TTU) 12.0 - the full collection including load & unload utilities, database management, administration and drivers. SQL Assistant is part of the bundle so you can get it that way.

However, the Eclipse Plug-In is way cooler.

Why not install Eclipse 3.4.1. in a different directory from the default Eclipse one, and then install the Plug-In against that installation (I'm sure you can have multiple Eclipse Installs on a machine and you can probably run two different ones at the same time if you want).
Teradata Employee

Re: What tool (SQL Assistant?) do I use to browse a Teradata database?

Check out http://developer.teradata.com/tools/articles/teradata-express-edition-12-0 to see how to get and Install Teradata Express Edition.

Also Check out http://developer.teradata.com/applications/articles/the-friday-night-project-4-tza-db-and-tza-user for some screen shots of the plug-in in action.
Enthusiast

Re: What tool (SQL Assistant?) do I use to browse a Teradata database?

I think this is the right URL for getting started with eclipse plugin: http://developer.teradata.com/tools/articles/getting-started-with-teradata-plug-in-for-eclipse
Enthusiast

Re: What tool (SQL Assistant?) do I use to browse a Teradata database?

btw, it work on eclipse 3.5
Fan

Re: What tool (SQL Assistant?) do I use to browse a Teradata database?

When I install it, I get the following error, although I've seen this for other plugins, so I guess it's not really specific to the Teradata plugin:

An error occurred while installing the items
session context was:(profile=epp.package.jee, phase=org.eclipse.equinox.internal.provisional.p2.engine.phases.Install, operand=null --> [R]com.teradata.datatools.branding 13.0.0.200905061113, action=org.eclipse.equinox.internal.p2.touchpoint.eclipse.actions.InstallBundleAction).
Error while loading manipulator.
Error while loading manipulator.
Fan

Re: What tool (SQL Assistant?) do I use to browse a Teradata database?

In addition, I found it was relatively easy to set up SQuirreL for Teradata. The bad, and fatal, news is that it was so impossibly slow to do anything while viewing our Teradata database from SQuirreL, it's essentially unusable. As I don't have that problem with our Oracle databases, I conclude it's likely a configuration issue with our local Teradata database, and it's also likely that no matter what client tool I use, it will be impossibly slow.