All Forums Tools
dkarr 4 posts Joined 07/09
17 Jul 2009
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.

fgrimmer 553 posts Joined 04/09
17 Jul 2009

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.

dkarr 4 posts Joined 07/09
17 Jul 2009

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.

lucky 6 posts Joined 12/08
17 Jul 2009

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.

Mikec 28 posts Joined 03/09
17 Jul 2009

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).

Mikec 28 posts Joined 03/09
17 Jul 2009

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.

standalone 17 posts Joined 08/08
20 Jul 2009

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

standalone 17 posts Joined 08/08
20 Jul 2009

btw, it work on eclipse 3.5

dkarr 4 posts Joined 07/09
21 Jul 2009

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.

dkarr 4 posts Joined 07/09
21 Jul 2009

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.

fgrimmer 553 posts Joined 04/09
22 Jul 2009

As Mike mentioned, the Teradata Plug-in is very easy to use and quick to install. There is an all-in-one Eclipse 3.4.1 JEE download, then add Teradata Plug-in and you are ready to browse your Teradata Database.

aradford 1 post Joined 07/09
22 Jul 2009

I get an error in 3.5 when I right click on the sql editor.

An error has occurred when activating this view
org/eclipse/datatools/sqltools/routineeditor/ProcEditorInput

I'm using dtp 1.7. Maybe thats my problem.

So, I'm really jazed about parsing a sql statement into xml. How does it work?

fgrimmer 553 posts Joined 04/09
24 Jul 2009

Again, make sure you are running on 3.4.1 and, yes, DTP 1.6.1 for the Teradata plug-in for Eclipse 13.00.00.

There are 2 features regarding XML Services. One that can run a SQL statement and provide the XML Schema Definition, XSD, file for the result set.
There is also a feature for creating an XSLT , XML Stylesheet Transformation, from a given SQL statement. There use the Teradata XML Services tool set.

Is that what you are looking for?

przemb 2 posts Joined 06/09
06 Aug 2009

Hi, Is there a way to connect with squirrel to teradata in ansi transaction mode ?

LewisDawson 54 posts Joined 11/08
12 Aug 2009

przemb,

Use the TMODE connection parameter in the URL of your system to connect to Teradata in ASNI transaction mode:

jdbc:teradata://yourSystemName/TMODE=ANSI

srinsowmya 9 posts Joined 08/09
24 Aug 2009

Can some one pls tell me How to avoid prompting during the uninstallation of three packages tdicu,cliv2 and TeraGSS on solaris.sprac64?

srinsowmya 9 posts Joined 08/09
24 Aug 2009

how do i install and uninstall Teradata GSS cleint Package on HPUX.IA64 TeraGSS_hpux-ia64_06.02.02.22?

Mikec 28 posts Joined 03/09
25 Sep 2009

It's finally here SQL Assistant Java Edition (Alpha Version). Check out Francine's article at http://developer.teradata.com/tools/articles/sql-assistant-java-edition and get access to Teradata from Windows, Linux and Mac....

a1_singhal 1 post Joined 01/10
07 Jan 2010

I have installed teradata for VMware Player along with Vmplayer version 3.0 on my window 7 -64 bit. I want to work with teradata sql assistant and that too i have installed but i'm not able to make connection with database. I have add a cop entry in Host file 127.0.0.1 localhost dbc dbccop1 DemoTDATcop1 but still it is not working. Even i'm not getting anything while using the URL : https://127.0.0.1/8333/ui. Please help me.

ChinaGuy 41 posts Joined 09/09
09 Jan 2010

is your sql assistant installed on your host machine or in your VM?

stevecold 2 posts Joined 06/10
02 Jun 2010

How to use SQL Assistant to connect to SQL Server 2K5. I am getting the below error when I made the connection.

Error creating SQL Model Connection connection to New Generic JDBC. (Error: null)

java.lang.NullPointerException
at org.eclipse.datatools.connectivity.sqm.internal.core.util.DatabaseProviderHelper.getCatalogDatabase(DatabaseProviderHelper.java:37)
at org.eclipse.datatools.connectivity.sqm.internal.core.util.DatabaseProviderHelper.setDatabase(DatabaseProviderHelper.java:47)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:672)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.(ConnectionInfoImpl.java:644)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163)
at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

fgrimmer 553 posts Joined 04/09
07 Jun 2010

SQL Assistant Java Edition does not currently support SQL Server. The ability to support database connections other than Teradata is on our list of enhancements but currently Teradata is the only database supported.

rehnaraj 11 posts Joined 06/10
07 Jun 2010

I have installed SSQL Assistant Java Edition but unable to connect to database.Please guide me.M a beginner

rehnaraj 11 posts Joined 06/10
07 Jun 2010

this is the error m getting :----
eclipse.buildId=unknown
java.version=1.6.0_01
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86

Warning
Sat Jun 05 22:42:09 PDT 2010
Error creating JDBC Connection connection to New Generic JDBC. (Error: com.teradata.jdbc. testdriver)

java.lang.ClassNotFoundException: com.teradata.jdbc. testdriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.net.FactoryURLClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:205)
at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:104)
at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:53)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:72)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnectionFactory.createConnection(JDBCConnectionFactory.java:53)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:355)
at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:166)
at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

fgrimmer 553 posts Joined 04/09
07 Jun 2010

It looks like you have chosen the 'Generic JDBC' connection profile type. When creating a Teradata Database connection, choose the 'Teradata Database' option from the New Connection Profile dialog.

rehnaraj 11 posts Joined 06/10
07 Jun 2010

When creating a Teradata Database connectionI have chosen the 'Teradata Database' option from the New Connection Profile dialog.

select driver from topdown list==Teradata embedded JDBC driver (default)

Database server name ----testing
User name[@Domain]------testing
Password---------------------testing
Authentication mechanism--Password Protected
Database---------------------testing
Save password----checked

JDBC connection properties (default)
CHARSET=UTF8
TMODE=ANSI

checked---connect when the wizard completes.

ERRROR M GETTING

eclipse.buildId=unknown
java.version=1.6.0_01
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86

Error
Sat Jun 05 23:05:08 PDT 2010
Unhandled event loop exception

org.eclipse.swt.SWTException: Failed to execute runnable (java.util.ConcurrentModificationException)
at org.eclipse.swt.SWT.error(SWT.java:3884)
at org.eclipse.swt.SWT.error(SWT.java:3799)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:137)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3885)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3506)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at com.teradata.sqla.Application.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
Caused by: java.util.ConcurrentModificationException
at java.util.AbstractList$Itr.checkForComodification(Unknown Source)
at java.util.AbstractList$Itr.next(Unknown Source)
at org.eclipse.datatools.sqltools.sqleditor.SQLEditor.fireConnectionProfileAttached(SQLEditor.java:2174)
at org.eclipse.datatools.sqltools.sqleditor.SQLEditor$4.run(SQLEditor.java:1468)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134)
... 22 more

eclipse.buildId=unknown
java.version=1.6.0_01
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -os win32 -ws win32 -arch x86

Warning
Sat Jun 05 23:04:09 PDT 2010
NLS unused message: StatusTextProvider_update_count_single in: org.eclipse.datatools.sqltools.result.ui.PluginResources

rehnaraj 11 posts Joined 06/10
08 Jun 2010

Kindly help me plz

Chuckbert 78 posts Joined 07/09
08 Jun 2010

rehnaraj,

I have recreated the situation that you have encountered.

I first created a connection profile using the Generic JDBC connection with the invalid driver class name "com.teradata.jdbc. testdriver" that you specified. With this connection profile, I see the same stack trace in the Error Log you you have reported. Since the driver class name is invalid, the resulting exception is expected.

The SQL Scratchpad Connection profile type was set to Generic JDBC_1.x.

I then created a connection profile using the Teradata Database. I then selected the Teradata_12.x entry from the Type list in the SQL Scratchpad's Connection profile. Because the Error Log was displayed, I noticed that there was a new entry that contains the same exception that you posted late last night.

This exception appears to be innocuous. After the exception was logged, I executed the SQL that is in the SQL Scratchpad it ran successfully.

I appears to be a situation that is encountered when switching from an invalid connection profile to a valid one. But it doesn't appear to affect the operation of the program.

Let us know if you still are having problems when using a connection that is defined with the Teradata Database connection profile that successfully connects to the database system.

rehnaraj 11 posts Joined 06/10
08 Jun 2010

Database server name ----testing
User name[@Domain]------testing
Password---------------------testing
Authentication mechanism--Password Protected
Database---------------------testing
Save password----checked

@chuckbert
"the connection status to to database is Disconnected"

error i am getting when i tried running SQL on SQLscrathcapad :-------

Could not connect to testing.
Error creating SQL Model Connection connection to testing. (Error: com.ncr.teradata.TeraDriver)
com.ncr.teradata.TeraDriver
Error creating Teradata Database connection to testing. (Error: com.ncr.teradata.TeraDriver)
com.ncr.teradata.TeraDriver

rehnaraj 11 posts Joined 06/10
08 Jun 2010

M not able to successfully connect to database

rehnaraj 11 posts Joined 06/10
08 Jun 2010

kindly guide me to connect to the database.

In the connection profile
Type---Teradata_13.X
Name--testing
Database--- (Status:Disconnected)

fgrimmer 553 posts Joined 04/09
08 Jun 2010

Are you using the Teradata Embedded JDBC Driver? In your message above, it shows the old classname com.ncr.teradata.TeraDriver which the embedded driver (version 13.00.00.20) does not use. If so, can you try creating a new connection profile and use the Teradata Embedded JDBC Driver. There is more detailed documentation on creating a connection in the article SQL Assistant Java Edition, at http://developer.teradata.com/tools/articles/sql-assistant-java-edition

rehnaraj 11 posts Joined 06/10
08 Jun 2010

@FGIMMER----Iam using teradata embedded JDBC driver.I referred to http://developer.teradata.com/tools/articles/sql- assistant-java-edition.but still i am getting error....

I have deleted all older connections and tried creating a new connection (new_teradata) but still it gives an error that

"creating connections to new_teradata has encountered problem.could not connect to new_teradata.and it is giving the old error

rehnaraj 11 posts Joined 06/10
08 Jun 2010

Could not connect to new_teradata.
Error creating SQL Model Connection connection to new_teradata. (Error: com.ncr.teradata.TeraDriver)
com.ncr.teradata.TeraDriver
Error creating Teradata Database connection to new_teradata. (Error: com.ncr.teradata.TeraDriver)
com.ncr.teradata.TeraDriver

shaoqiang0327 2 posts Joined 05/10
11 Jun 2010

use Teradata SQL Assistant Java Edition,witch like the Eclipse

alexfed 1 post Joined 04/11
07 Apr 2011

I am getting this error when executing a query. The only way to reslove is to restart the tool. After a few minutes of use this error pops again.

'Launch Teradata ResultsetViewer' has encontered a problem:

The stack trace:

!ENTRY org.eclipse.ui 4 0 2011-04-08 11:55:20.397
!MESSAGE Unhandled event loop exception
!STACK 0
java.lang.NullPointerException
at com.teradata.datatools.dtp.teradataview.view.ViewContainer.activateCurrentItem(Unknown Source)
at com.teradata.datatools.dtp.teradataview.view.ViewContainer.handleSelection(Unknown Source)
at com.teradata.datatools.dtp.teradataview.view.ViewContainer$2.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1027)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1012)
at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:770)
at org.eclipse.swt.custom.CTabFolder.setSelection(CTabFolder.java:3256)
at org.eclipse.swt.custom.CTabFolder.destroyItem(CTabFolder.java:647)
at org.eclipse.swt.custom.CTabItem.dispose(CTabItem.java:165)
at org.eclipse.swt.custom.CTabFolder.onMouse(CTabFolder.java:2205)
at org.eclipse.swt.custom.CTabFolder$1.handleEvent(CTabFolder.java:327)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3910)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3503)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at com.teradata.sqla.Application.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)

You must sign in to leave a comment.