[KLUG Members] Looking for JDBC data import utility

Adam Tauno Williams members@kalamazoolinux.org
19 May 2003 11:16:09 -0400


We were using IBM AGS Server Studio here until our trial license ran
out.  Very nice app, but at $849 a seat it is a little steep (cough).

So now that it stopped working I went scrounging about for a JDBC data
manipulation program and found - http://www.minq.se/products/dbvis/
It is a very good and solid program (actually crashes less often than
the AGS product, which was really rare).    Actually it does a couple of
things AGS didn't, such as on-the-fly resorting of query results and
error messages that usually go so far as to indicate the real source of
a problem (SHOCK!).

But what it lacks is a data import feature,  which our QC guys *LOVED*
in the AGS product.  You could match file columns (delimited) to data
base fields with a nifty wizard, etc...

Now something like that just has to have been written and lying out
there somewhere.  If anyone can point me at some URL I'd appreciate it.

We strongly prefer a JDBC based product as the ODBC Win32 drivers for
real databases are a royal disaster, and being JAVA they can run the
same app anywhere on anything.