DTM SQL editor is a set of powerful Banque de données management Outils 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 Banque de données users, developers and administrators an ability to access different Bureau 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 Banque de données schema and the results of the query execution.
The program gives you a powerful set of Outils to edit SQL scripts and to build SQL statements using a convenient wizard-like interface. The program also includes a connections manager, a Banque de données schema viewer, an option to view the execution history and other handy Outils conveniently integrated in a single user interface.
The application supports clipboard and data export Outils. 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 Outils. 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.