Convenient tool to query progress database

I've not used TOAD in ages, so this might not be what you are looking for, but Squirrel SQL client is pretty good. You can get it free from:

http://squirrel-sql.sourceforge.net/

or you can use any SQL client that uses ODBC/JDBC to connect to the database.

Hello, might you have quick steps on how to establish the connect from Squirrel to the Progress OE10.1B db? I have lost as to what driver I should be using and creating the alias. I am not even sure I have the JDBC components for my Progress install though the Progress documentation states I should. I have OE SQL Client Access installed having choose a COMPLETE install. I do not find %DLC%\bin\JdbcProgress.dll. as the doc seems to indicate I should.

Having said all that .. my understanding is I should be able to use the JDBC ODBC Bridge in Squirrel? I am trying that but no luck .. may just be that my connection URL is incorrect. If you have an example, would be greatly appreciated.

You might find these useful http://www.oehive.org/node/954 and http://www.oehive.org/node/1025 . While the focus there is specifically on Enterprise Architect, pretty much the same applies to any OE database.

Note that in a production environment, one may have server considerations which are not stated here. At a minimum, you need to have the database started with -S, but in a multi-user environment you might want to also set up separate brokers for SQL and do some tuning.

Of course, the ideal tool for poking around an OpenEdge database is ABL ... but maybe you are more familiar with SQL

Database navigator (from OEA or Sonic) uses an older version of squirrel internally. This is the information it currently uses for connections.

For the newer jdbc drivers from DataDirect the driver class name is

com.ddtek.jdbc.openedge.OpenEdgeDriver

The connection URL is something like:

jdbc:datadirect:openedge:///java/util.jar

Hi,

You may want to look at www.nuvusoftware.com - they supply a query tool that interrogates the Progress Database via raw sockets (no ODBC or JDBC connection required).  The tool has a built-in report writer - and other features similar to Crystal Reports.

Regards

Brian

For a free, non-SQL solution, you might want to look at this http://www.oehive.org/node/1670

http://www.oehive.org/node/1670

tamhas wrote:
For a free, non-SQL solution, you might want to look at this http://www.oehive.org/node/1670

the above link does not open 

Probably a case of being replaced by a newer release.  Probably this: http://www.oehive.org/project/DataDigger