Home » Language IDEs » ServerTools (WTP) » DataExplorer Inital Thoughts...
| DataExplorer Inital Thoughts... [message #31600] |
Mon, 26 July 2004 15:19  |
 Jeff Duska
Messages: 71
Registered: July 2009 |
Member |
|
|
Here are my initial thoughts on the data submission from IBM.
Really needs to be a 'Data' perspective.
This might heresy in Java world, but could we support native or platform
database connections, such OD BC, OLE on Windows and Open OD BC on
Unix/Linux. This opens access to data sources that might not have jdbc
drivers. Continuing this idea, we should be able to see predefined
connection information. I would expect to see all the user DSN and
system DSN defined in the Microsoft ODBC System Administrator. An other
example would database defined in Oracle's TNSNames file.
We need a method for user to add new drivers or data source types. As an
example, I work with jTDS jdbc driver to gain access to Microsoft SQL
Server databases. There appears to be no simple way to add support for
this driver. I'm guessing that it is expected to be part of the data
properties, but I'd rather see something like jfaceDbc. This
http://www.pratocity.com/jface/img1.html. They have drivers, aliases,
and connections.
The connection wizard needs to become a cheat sheet or a non-modal
dialog. I know I have settings for databases connections in my java
projects. I couldn't view these settings, because the dialog was modal.
Ugh...
When you select 'other...', the individual fields for the connection
string should disabled work with the connection string field. Currently,
they will erase the connection string.
It can be useful to be able to set the connection string other drivers
settings than 'other...'. In my VB days DBAs often provided connection
strings for database. In this use case, the user need to enter the
connection string, but cannot.
It would nice to see support for Oracle Synonyms, Stored Procedures on
all databases. It seems that this would be the perfect place to Oracle
step up to the plate and create a kick a$$ Oracle database Perspective.
There needs to be progress indicator, otherwise the system gives the
impression system is locked up when it is just waiting on a resultset.
A GUI query builder.
A quick and dirty ER diagram like SQL Server Enterprise has or jfaceDbc
SQL History pane needs to be a tab or its own view.
If there are more than 1000 rows, there should be a way to request the
remain rows.
Sample Content should have Java Export Interfaces with at least CSV
provide as an example. This way developers could add exports for XML, HTML.
Right clicking in the Database Explorer could allow have the option to
open an new SQL Window.
I have more ideas, but I out of time right. I'm curious, if we should
start adding these suggestions or feature requests into bugzilla?
Regards,
Jeff Duska
|
|
|
| Re: DataExplorer Inital Thoughts... [message #31641 is a reply to message #31600] |
Mon, 26 July 2004 18:27  |
Haris Peco
Messages: 1072
Registered: July 2009 |
Senior Member |
|
|
Hello
and explorer is slow - i have 400+ table, 400+ fk,pk etc
and connect,reconnect,refresh are more minutes long
Database explorer load all data about tables (column,pk,fk etc) for every
connect
regards
Jeff Duska wrote:
> Here are my initial thoughts on the data submission from IBM.
>
> Really needs to be a 'Data' perspective.
>
> This might heresy in Java world, but could we support native or platform
> database connections, such OD BC, OLE on Windows and Open OD BC on
> Unix/Linux. This opens access to data sources that might not have jdbc
> drivers. Continuing this idea, we should be able to see predefined
> connection information. I would expect to see all the user DSN and
> system DSN defined in the Microsoft ODBC System Administrator. An other
> example would database defined in Oracle's TNSNames file.
>
> We need a method for user to add new drivers or data source types. As an
> example, I work with jTDS jdbc driver to gain access to Microsoft SQL
> Server databases. There appears to be no simple way to add support for
> this driver. I'm guessing that it is expected to be part of the data
> properties, but I'd rather see something like jfaceDbc. This
> http://www.pratocity.com/jface/img1.html. They have drivers, aliases,
> and connections.
>
> The connection wizard needs to become a cheat sheet or a non-modal
> dialog. I know I have settings for databases connections in my java
> projects. I couldn't view these settings, because the dialog was modal.
> Ugh...
>
> When you select 'other...', the individual fields for the connection
> string should disabled work with the connection string field. Currently,
> they will erase the connection string.
>
> It can be useful to be able to set the connection string other drivers
> settings than 'other...'. In my VB days DBAs often provided connection
> strings for database. In this use case, the user need to enter the
> connection string, but cannot.
>
> It would nice to see support for Oracle Synonyms, Stored Procedures on
> all databases. It seems that this would be the perfect place to Oracle
> step up to the plate and create a kick a$$ Oracle database Perspective.
>
> There needs to be progress indicator, otherwise the system gives the
> impression system is locked up when it is just waiting on a resultset.
>
> A GUI query builder.
>
> A quick and dirty ER diagram like SQL Server Enterprise has or jfaceDbc
>
> SQL History pane needs to be a tab or its own view.
>
> If there are more than 1000 rows, there should be a way to request the
> remain rows.
>
> Sample Content should have Java Export Interfaces with at least CSV
> provide as an example. This way developers could add exports for XML,
> HTML.
>
> Right clicking in the Database Explorer could allow have the option to
> open an new SQL Window.
>
> I have more ideas, but I out of time right. I'm curious, if we should
> start adding these suggestions or feature requests into bugzilla?
>
> Regards,
>
>
> Jeff Duska
|
|
| |
| Re: DataExplorer Inital Thoughts... [message #33701 is a reply to message #31641] |
Wed, 28 July 2004 06:55 |
Der Ping Chou
Messages: 36
Registered: July 2009 |
Member |
|
|
Hi all,
snpe, have you try apply schema/table filter so that you can get a set of
tables that you are interested?
Jeff,
You have some great idea there, you definitely should file these in
Bugzilla. Don't let it lost in the e-mail trail.
I have have some comment on you suggestion on ODBC, OLE DB or even Ado.Net
provider - These would require contributor to support Java to COM bridge
to handle native method as well as recordset and statement wrapper. This
would be a big area for people to contribute!
I am surprised that you don't see a progress bar while it is loading info
from database.
Output generating CSV file is something has great value and yet does not
take much to contribute. A low hanging fruit!!!
Regards,
Der Ping
snpe wrote:
> Hello
> and explorer is slow - i have 400+ table, 400+ fk,pk etc
> and connect,reconnect,refresh are more minutes long
> Database explorer load all data about tables (column,pk,fk etc) for every
> connect
> regards
> Jeff Duska wrote:
> > Here are my initial thoughts on the data submission from IBM.
> >
> > Really needs to be a 'Data' perspective.
> >
> > This might heresy in Java world, but could we support native or platform
> > database connections, such OD BC, OLE on Windows and Open OD BC on
> > Unix/Linux. This opens access to data sources that might not have jdbc
> > drivers. Continuing this idea, we should be able to see predefined
> > connection information. I would expect to see all the user DSN and
> > system DSN defined in the Microsoft ODBC System Administrator. An other
> > example would database defined in Oracle's TNSNames file.
> >
> > We need a method for user to add new drivers or data source types. As an
> > example, I work with jTDS jdbc driver to gain access to Microsoft SQL
> > Server databases. There appears to be no simple way to add support for
> > this driver. I'm guessing that it is expected to be part of the data
> > properties, but I'd rather see something like jfaceDbc. This
> > http://www.pratocity.com/jface/img1.html. They have drivers, aliases,
> > and connections.
> >
> > The connection wizard needs to become a cheat sheet or a non-modal
> > dialog. I know I have settings for databases connections in my java
> > projects. I couldn't view these settings, because the dialog was modal.
> > Ugh...
> >
> > When you select 'other...', the individual fields for the connection
> > string should disabled work with the connection string field. Currently,
> > they will erase the connection string.
> >
> > It can be useful to be able to set the connection string other drivers
> > settings than 'other...'. In my VB days DBAs often provided connection
> > strings for database. In this use case, the user need to enter the
> > connection string, but cannot.
> >
> > It would nice to see support for Oracle Synonyms, Stored Procedures on
> > all databases. It seems that this would be the perfect place to Oracle
> > step up to the plate and create a kick a$$ Oracle database Perspective.
> >
> > There needs to be progress indicator, otherwise the system gives the
> > impression system is locked up when it is just waiting on a resultset.
> >
> > A GUI query builder.
> >
> > A quick and dirty ER diagram like SQL Server Enterprise has or jfaceDbc
> >
> > SQL History pane needs to be a tab or its own view.
> >
> > If there are more than 1000 rows, there should be a way to request the
> > remain rows.
> >
> > Sample Content should have Java Export Interfaces with at least CSV
> > provide as an example. This way developers could add exports for XML,
> > HTML.
> >
> > Right clicking in the Database Explorer could allow have the option to
> > open an new SQL Window.
> >
> > I have more ideas, but I out of time right. I'm curious, if we should
> > start adding these suggestions or feature requests into bugzilla?
> >
> > Regards,
> >
> >
> > Jeff Duska
|
|
|
Goto Forum:
Current Time: Thu Apr 25 09:49:38 GMT 2024
Powered by FUDForum. Page generated in 0.02524 seconds |
] 
Search
Help
Register
Login
Home
