Teradata SQL Assistant Java Edition release 13.01 is now available for download. SQLA JE provides an information discovery tool for retrieving and displaying data from your Teradata Database systems. 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 SQL Assistant Java Edition to benefit from the many high quality Eclipse features available while focusing on value-add for the Teradata Database.

New features in this release include:

  • Updated for Eclipse 3.5.2 and DTP 1.7.2
  • Advanced authentication to allow for LDAP and Kerberos logon options
  • Option to save the user's logon password
  • Improved JDBC Properties user interface
  • FastExport and FastLoad of table data
  • Parameterized queries that allow for named parameters within your SQL query
  • SQL Templates: SELECT, INSERT, DELETE, UPDATE, and many more
  • Drag and drop object names from the Data Source Explorer into the SQL Editor

For more information on using Teradata SQL Assistant Java Edition, refer to the article, SQL Assistant Java Edition.

Discussion
20 Sep 2010

Each time i shutdown and startup my laptop my Database Connections are gone and i have to create them again. Is there a setting that i am missing or something?

fgrimmer 660 comments Joined 04/09
20 Sep 2010

No, they should not go away. The connection profile information is stored in a metadata file in the workspace directory. If that is being deleted for some reason, then the connection profiles are deleted as well. The default location for the workspace directory is created in your home directory (C:\Documents and Settings\(user)\workspace)

21 Sep 2010

I found the file C:\Documents and Settings\(user)\workspace\sqla and it has size > 0 and contents. I shutdown and startup and C:\Documents and Settings\(user)\workspace\sqla has size 0 and no contents. Any suggestions as to why? I have a workaround of exporting my profiles to a file and importing after each startup. However, i would like to not have to do that each time.

fgrimmer 660 comments Joined 04/09
21 Sep 2010

The files that contains the connection profile information are driverStorage.xml and ServerProfiles.dat and located in the worksapce/.metadata/.plugins/org.eclipse.datatools.connectivity/ directory. What operating system are you running on?

antoniosun 2 comments Joined 09/10
22 Sep 2010

Debian package please

Please consider adding Debian package in your future release please.

As to "why Debian", let me just put it this way, when Google create apps, it first creates Debian packages, rpm packages only comes next. The Linux-friendly internet-giant's decision should mean something.

FYI:

Google Voice and Video Chat Now Available for Ubuntu and Debian Linux
http://www.techtickle.com/google-voice-and-video-chat-now-available-for-ubuntu-and-debian-linux.html

Voice and video chat for Linux, currently supports Ubuntu and other Debian-based Linux distributions only
and RPM support is expected to come soon.

antoniosun 2 comments Joined 09/10
22 Sep 2010

multi-databases

Hi,

I need to access multiple databases within a single database connection.

It's trivial within the traditional Teradata SQL Assistant, but how can I do that in SQL Assistant Java Edition?

thanks

fgrimmer 660 comments Joined 04/09
24 Sep 2010

You can access multiple databases (or schemas) within a single database connection by providing the fully qualified name for the table access in your query. If you don't provide the database name, then it is assumed to be using the default database that you provided with the connection profile.

idolustig 3 comments Joined 09/10
27 Sep 2010

Hi,

Many times the assistant is very slow and even freezes for nearly a minute. This happens when trying to view a schema or it's tables, and even when writing a simple 'select' query. It seems as if the assistant tries to fetch the table(s) properties or something similar, and since there is A LOT of data in our DBs, it takes a while. A long while.

Is there any way of 'loading' this information when starting the assistant? I don't mind waiting for a couple of min each day, at startup for the tool to load and cash all the data.

When we used the 'regular' assistant (not the Java Edition one) things were a lot faster, though less options (like the graphic query builder) were available.

Thanks

fgrimmer 660 comments Joined 04/09
27 Sep 2010

There is information that SQL JE is gathering from the Database about the database objects when loading them in the Data Source Explorer, as well as during syntax checking. The product will access information in the DBC tables, using the basic database views provided. There are additional views (ViewV and ViewsVX) that contain the same information but perform faster. You can switch SQLA JE to use those views by setting the option in the Teradata Datatools Preferences (go to Window>Preferences>Teradata Datatools Preferences). The concern is that not all users have access to those views. If you do have access to those DBC views, you can try changing this option to improve the performance.

Another thing you can do is turn off the syntax checking when entering SQL queries. This can be done by going to Window>Preferences, then Data Management>SQL Development>SQL Editor. Uncheck the 'Enable syntax validation' option. This should speed up the time when entering your query.

Another thing you could do that could possibly help with performance is to collect statistics on your Teradata Database. This is something your DBA would need to do. This would help with index referencing that is occurring in the DBC view.

idolustig 3 comments Joined 09/10
27 Sep 2010

Thanks a lot. I will try your recommendations.
But, since I guess not all users have access to ViewV, and since all our tables are already statistics collected, I'm looking for something more advanced.

Maybe there are some SQL commands I can set to run upon loading TDA JE? Something like "load" which will "force" the tool to load all tables/views I want and cash them? Again, I don't mind waiting for a couple of minutes when the assistant loads, but mind doing so while working...

fgrimmer 660 comments Joined 04/09
28 Sep 2010

There isn't currently a way to specify pre-load statements, but we have something similar on our list of enhancements that are being worked on.

Also, there is another option you can try to speed up the Data Source Explorer schema loading. This is to specify a filter on your Schemas directory. The filter can be added by right clicking on the Schemas folder and choosing the Properties option. Unclick 'disable filters' and enter an expression or select the schemas from the list. I hope this helps.

idolustig 3 comments Joined 09/10
28 Sep 2010

Thanks a lot.

kostek 4 comments Joined 11/09
30 Sep 2011

Hi

What else have to be done to connect to Oracle database?

I defined new driver definition for oracle using ojdbc14.jar.
I can connect to oracle, I can see the database structure in Data Source Explorer but when I try to run sql statement I receive error:

org.eclipse.datatools.sqltools.db.generic.service.GenericSQLService cannot be cast to com.teradata.datatools.dtp.sqltools.db.teradata.services.TeradataDBSQLService

fgrimmer 660 comments Joined 04/09
30 Sep 2011

@kostek, There may be an issue in earlier releases. Make sure that you are running our latest release of SQLA JE 13.11 and create an Oracle connection profile. It requires JRE 1.6. I ran a quick SQL test using Oracle Express 11g and ojdbc6.jar and it was successful.

kostek 4 comments Joined 11/09
03 Oct 2011

Thanks for reply.
I'm using SQLA JE 13.11. After many, many attepts i've just clicked on "execute all statements submitted as one statement Ctrl+Alt+X" icon and now it works :-). So I don't know why "Execute SQL statements as individual statements" causes error?
I've also noticed that for oracle connection drag and drop from Data Source Explorer to SQL Scratchpad doesn't work.
All the rest looks OK.

fgrimmer 660 comments Joined 04/09
03 Oct 2011

I am glad that worked. You call also execute from the SQL Editor/Scrachpad by right clicking and choosing from the Execute menu options.
Extended features have been implemented for Teradata and may not work on connection types other than Teradata.

You must sign in to leave a comment.