From Ingres Community Wiki

The Ingres Database Workbench (IDW) is a powerful, low-overhead tool that makes Ingres database maintenance faster and easier and simplifies database management tasks. IDW is based on the Eclipse Rich Client Platform (RCP).

• Browse your database objects such as tables, views, procedures and rules.
• SQL editor, includes SQL statement generation tools.
• Easily set up database connection profiles for Ingres and Ingres Vectorwise instances in the cloud.
• Includes sample Reports based on BIRT

• Download it and submit feedback here on : https://sourceforge.net/projects/ingresdbwrkbnch/

Target Market

Ingres VectorWise customers

New Content:

• Port IDW to run on Eclipse Helios 3.6, include Amazon AWS plugins and BIRT plug-ins

• Facelift
  • Add new spash screen and welcome screen, new icons.

• Core Ingres Plug-in
  • Plug-in that contains: The Ingres Preferences page, reusable ingres utility libraries to create database connection profiles, perform debugging using Log4J, file i/o utilities, and Eclipse utilities.
    • When debugging is on the logger will log to C:/ on Windows, /tmp on Linux
  • Added firststart plug-in functionality that creates a db connection profile for Ingres on localhost, with the new Ingres version 9 (see DTP) when IDW starts for the first time.
  • Preference page used to set the Ingres instance id
    • Added a check, when the instance id changes on the preference page, then the default Ingres db connection profile is updated

• Amazon AWS Plug-in
  • Plug-in that automates creating database connection profiles for EC2 instances
  • Integrated button(s) to create a database connection profile for EC2 instances (built for IUA).
  • Added preference page to set the Amazon credentials.
  • If the user presses the button and the credentials are not set, I open the preferences window to have the user set them.

• IDW application Plug-in
  • Created new perspectives: IDW, Ingres EC2 (includes Amazon plug-ins), and ability to open Report Designer plugin.
  • Created new 16x16 icons to open perspectives
  • Added "Run" menu with option to Run an Ingres Sample Report.

• Ingres Application Examples Plug-in
  • Plug-in that allows you to import the Foodmart and Frequent Flyer sample reports. It's a generic plug-in with a defined extension point that example applications or reports can be plugged into and therefore served up from the Ingres Examples Wizard.

• BIRT sample reports
  • Foodmart and Frequent Flyer
  • After importing a report:
    • Open the Report Design perspective
    • Open a help page explaining how to set up the data source and how to run the report.
  • For the Frequent Flyer sample report, ask the user what their Ingres config is. Upon importing, search and replace the default with their config in the sample report.
  • BIRT on Helios requires that you deploy your driver jar file to the following folder. This must be done by the builder or manually.
    • eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_2.6.0.v20100524\drivers

New DTP Content

• Fixed compilation errors from Ingres repository.
• Current driver hard codes driver version 2006. Added versions 9 and 10.

Still to do:

• Create SourceForge site, publish new IDW daily/weekly, allow comments, feature requests
  • Created project: https://sourceforge.net/projects/ingresdbwrkbnch
  • Create an ANT builder for IDW so that it can be built from the repository without Eclipse open.
  • Put IDW on the Ingres Vectorwise AMI http://community.ingres.com/wiki/Ingres_VectorWise_Amazon_EC2_Images

I'd welcome any feedback you have on this! Please email me: mailto:jane.thalen@ingres.com