With native connections to RDBMS databases, this tool is used to design and execute queries against SQL Server, Sybase, Oracle, Interbase, Informx, DB2, Firebird, SQL Base, PostgreSQL, MySQL and ODBC. Resulting datasets may be edited directly making this a very unique query tool. Even complex queries may be used to edit a resulting dataset. The resulting dataset may also be exported to text, Excel, or HTML and may also be emailed or printed directly prom the program. An SQL query may also contain parameters which will trigger a parameter dialog. Parameters may be plain text, date or a database lookup field, making analysis of data very powerful. Queries could be designed manually or using an intuitive query builder. The tool is designed for speed of usage and certain parameters may be remembered such as login details for the next session. SQL may also be saved for retrieval at a later stage. Multiple query windows could be opened and the system also shows a list of tables in the database. THIS IS THE IDEAL TOOL FOR A DATABASE ADMINISTRATOR, MAKING HIS TASK EASY!
|