Convenient tool to query progress database - Forum - OpenEdge RDBMS - Progress Community

Convenient tool to query progress database

 Forum

Convenient tool to query progress database

  • Hi,

    Please let me know which is the convenient tool to query progress database similar to TOAD.

    Thanks,

    Rajesh K

  • 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

    Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice  http://www.cintegrity.com

  • 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

    Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice  http://www.cintegrity.com

  • 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

    Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice  http://www.cintegrity.com