• DbObjectLoader allows to insert, update and delete objects or any links between objects in SmarTeam database from ASCII file or database

• DbObjectReClassificator allows to change class of any object in SmarTeam database
• SmarTeam Query allows to execute query in SmarTeam SQL – the dialect of SQL language, which is based on Oracle SQL

DbObjectLoader

This utility is intended for database load and update. Through using SmarTeam API, it takes into account SmarTeam user’s rights and is independent of underlaying DBMS. The DbObjectLoader allows you valuate attributes from input stream by using regular expressions. You can also apply regular expressions filter to skip some data from your input source. The DbObjectLoader can use data from ASCII file and DBMS, which provide OLE DB interface. It is possible to save the configuration of your current session into a file and then reuse it later. The utility operates in two modes – graphical user interface (GUI) and command line. It is possible to use it in batch routines.

DbObjectReClassificator

The DbObjectReClassificator allows to change class of existing SmarTeam object and update the links it has. Through using SmarTeam API, it takes into account SmarTeam user’s rights and is independent of underlaying DBMS. The regular expressions can be used to valuate new attributes from source object and to define the objects to be processed. The configuration of session can be saved into the file and reused later. The utility operates in two modes – graphical user interface (GUI) and command line interface. It makes possible to use the DbObjectReClassificator in batch routines.

SmarTeam Query

Allows to execute SQL-like queries and address to the SmarTeam objects and attributes if they are ordinary tables and fields. The queries can be saved in to the file and reused later. The GUI give possibility to create and execute queries interactively. COM object allows to embed the this functionality in your own application. This SmarTeam Query operates in SmarTeam environment and Oracle DBMS only.