DTM SQL editor is a set of powerful database management tools that allow you to achieve two goals: to have unified access to different types of databases and to have a set of solutions that makes processing your data easy.
DTM SQL editor gives database users, developers and administrators an ability to access different desktop or client-server databases (provided you have the ODBC, OLE DB or the IDAPI driver or the OCI interface installed).
DTM SQL editor is especially convenient, since most organizations use several different types of databases and each stores data in different formats and with varying parameters. Having a program that can get data from various sources is essential. In addition to quickly switching between different data sources, DTM SQL editor lets you see the database schema and the results of the query execution.
The program gives you a powerful set of tools to edit SQL scripts and to build SQL statements using a convenient wizard-like interface. The program also includes a connections manager, a database schema viewer, an option to view the execution history and other handy tools conveniently integrated in a single user interface.
The application supports clipboard and data export tools. It can export data to plain text, HTML or XML documents, and Microsoft Excel spreadsheets. You can also save the results of your query as a set of SQL statements.
The other advantages of DTM SQL editor are: one-click access to the file history and the history of the scripts you executed, syntax highlighting, multilevel Undo/Redo features and integrated search and replace tools. The program s step-by-step SQL builder (query builder) is the most intuitive and natural way to build complex SQL statements visually without submersing yourself into SQL.
DTM SQL editor supports plug-ins and comes with an SDK (software developer kit), which allows you to significantly increase the range of possible applications of this program.