SommerSoft QueryOrganizer 

English main

SommerSoft QueryOrganizer is a tool to simplify the creation of AGRESSO server processes with the Microsoft Visual Basic IDE.  Server processes may be used for versatile tasks like:

  • exchange of data with other systems (import and export)
  • calculation and execution of reports
  • maintaining the database.

The creation of a AGRESSO server process has so far been a rather complicated process and required advanced programming skills.  QueryOrganizer offers an easy-to-use interface to implement AGRESSO server processes coded in Visual Basic.  To simplify the use of SQL code in your server process, a visual interface for registering SQL queries is available.

Typical advantages of using QueryOrganizer are:

  • Easier development:  QueryOrganizer is made as an 'Add-In' to Visual Basic 6.  A visual interface provides better overall view and control of your work and makes changes easy.
  • Automatically generated code:  QueryOrganizer can either generate an application framework or the complete code for your server process.
  • Runtime parsing:  A compiled server process contains a runtimer parser.  This allows you to use parameters and temporary table names in SQL queries.  Parameters and table names will be replaced with values at runtime of the server process.
  • Requires little knowledge of Visual Basic:  QueryOrganizer hides much of the complexity in the communication with AGRESSO.
  • Simplified distribution and version control:  A server process executable file can easily be distributed by copying the file into AGRESSO's server directory (runtime components must be installed).  Visual Basic's can stamp each executable file you create with a version number.
  • Control and flexibility:  You get full access to all features provided with Visual Basic. Each SQL statement can hold up to 32Kb.  DLLs, modules or databases/tables from other systems can easily be used.
  • Faster development:  Our estimates indicate that QueryOrganizer can save up to half of the time ordinarily used to create AGRESSO server processes.
  • Complete integration into AGRESSO:  All created server processes can be completely integrated into AGRESSO and make use of the AGRESSO database connection.

Interested?  Please read more, download a free demo version or contact us for further information.