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.
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.
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 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).
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.
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
btw, it work on eclipse 3.5
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.
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.
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.
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?
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?
Hi, Is there a way to connect with squirrel to teradata in ansi transaction mode ?
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
Can some one pls tell me How to avoid prompting during the uninstallation of three packages tdicu,cliv2 and TeraGSS on solaris.sprac64?
how do i install and uninstall Teradata GSS cleint Package on HPUX.IA64 TeraGSS_hpux-ia64_06.02.02.22?
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....
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.
is your sql assistant installed on your host machine or in your VM?
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)
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.
I have installed SSQL Assistant Java Edition but unable to connect to database.Please guide me.M a beginner
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)
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.
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,
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.
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
kindly guide me to connect to the database.
In the connection profile
Type---Teradata_13.X
Name--testing
Database--- (Status:Disconnected)
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
@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
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
use Teradata SQL Assistant Java Edition,witch like the Eclipse
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)
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.