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 databases, whether desktop or client-server ones (provided you have ODBC driver installed). This is very convenient, since most organizations use several different types of databases installed and each stores data in different formats and with varying parameters. Having a program that can get data from various sources is often essential. Furthermore, in addition to letting you quickly switch between different data sources, DTM SQL Editor lets you see database schema and results of the query execution. There are three versions of the DTM SQL editor [download].
DTM Data Generator. Database developers and administrators know the testing
routine very well. One of the most unpopular tasks is creating data sets for testing new databases.
On average, it takes several hours to several days of dull work, since each data set has to be created
manually (copying and pasting at best), then different parameters have to be changed one by one to make
sure everything works correctly.
DTM Data Generator is a simple, powerful and fully customizable utility that generates data for database testing purposes. The great advantage of this software is that it is capable of creating a wide variety of test tables and supports user-defined templates. This data can then be easily inserted into a database. There are several ways of filling databases - randomly, by a mask, or with data from another table. Importantly, settings for each table are controlled separately. One data pack may contain multiple tables, each with own rules, value range and parameters, which makes using the tool very convenient. In addition, the program is capable of creating SQL statements for any operation. There are three main versions of the tool and runtime version. [download].
DTM Schema Reporter is a reporting tool for database schema. The program creates reports in RTF, HTML, XML, CHM, PDF or plain text formats and supports all common database interfaces - ODBC, IDAPI, OLE DB or Oracle Call Interface. This utility helps technical writers and database administrators create a report of any complexity level within seconds. Also, you can alter table order in the report and manually add annotations to the individual tables. There are two versions of the tool. [download].
DTM Migration Kit. Most companies running multiple databases have to deal with complex data migration issues. After all, importing, exporting or migrating data between different sources is very complicated and time consuming, especially if these data sources store data in different formats. This is where DTM Migration Kit comes to the rescue. This simple yet powerful data migration tool can work fully automatically after being set up only once. In addition to simple import, export or migration operations, the program supports setting custom transformation and flow control rules. Furthermore, DTM Migration Kit works with unified interfaces of ODBC, OLE DB, and IDAPI as well as with Oracle Call Interface. It is capable of importing data from plain text, Microsoft Access databases, Microsoft Excel spreadsheets, Paradox files, DBF (dBase and FoxPro) files and exports data to plain text, RTF format (compatible with Microsoft Word and Open Office Writer), HTML, XML, as well as is capable of creating sets of SQL statements. Importantly, the export of large binary objects (also known as BLOBs) is supported as well [download].
DTM Data Editor is a data viewer and editor for database professionals who are tired of wasting their time on mundane tasks. The program uses form-based interface and works with any ODBC, OLE DB, IDAPI or OCI data source. SQL statements are generated automatically and can by modified later. For a table that has the foreign key - primary key relation, there are options to enter values manually or select them from a list, which is much faster. [download].
DTM DB Stress is a utility for stress testing the server parts of information systems and applications, as well as DBMS and servers themselves. This tool allows you to create and configure a continuous set of requests to the server of the OLAP (query execution) and OLTP (adding, modifying and deleting data in the database) types. At the same time, the user can flexibly change both the number and the priority of this or that type of requests to a database or an application. There are three versions of the tool and a few plugins: Performance Counters, Show Execution Plan. [download].
DTM Data Modeler is a CASE tool for database developers that supports both forward and reverse engineering. It is an easy-to-use tool allowing you to work both with logical and physical data models in the form of an entity-relationship diagram. The product is intended for database architects and developers and works with data sources via the ODBC, IDAPI, OLE DB or OCI interface, which means compatibility with all modern DBMS. Along with basic model properties (sets of entities and relationships between them), the program allows you to create indexes and triggers on the physical level corresponding to the tables of the database that is modeled. [download].
DTM Data Scrubber is a set of intelligent tools for data verification (audit) and scrubbing (cleaning). Depending on user-defined rules and data properties, the program either creates a report about the actual state of affairs or performs database data correction. [download].
DTM Data Comparer is a visual tool for data comparison and synchronization. The program successively views the contents of both tables basing on the order of ascending of unique key values and shows differences or creates synchronization script. [download].
DTM Schema Comparer is a tool for comparing and synchronizing database schemas. The comparison process supports tables, views, indexes, triggers and stored procedures. The visual representation of database schemas as a tree makes the comparison process more comfortable. [download].
DTM Query Reporter is a reporting tool for database query. This utility helps technical writers, developers, and database administrators create a report based on database query within seconds. [download].
DTM DB Event is a database monitoring and management tool. This utility allows the user to define a few situations (events). For each event, the user can define what the program should do if the event occurs. [download].
DTM Flat File Generator. Easy to use tool that helps any developer or QA engineer to create test data file. It supports tab-delimited, CSV, fixed width, and custom separated output files. The generator has powerful import and export file structure features. [download].
DTM Test XML Generator. The tool is a powerful generator for XML documents with structure defined by user and random but realistic data. More than 30 predefined generators with powerful pattern engine. The rich import XML structure options are available. [download].
DTM Data Generator for JSON produces JSON or BSON files with defined structure in a bulk manner. Fast and easy structure editor and smart import options help the user to generate the test set in a few clicks only. [download].
DTM Database Content Analyzer is a statistical tool for database content. It collects a few dozens of most interesting data: database objects size, value frequency, clusters, etc. This tool replaces and extends "Statistics" report of obsolete versions DTM Schema Reporter.[download].
DTM ODBC Manager is a free simple and easy-to-use ODBC Data Sources manager. The program allows you to export data source definitions into a file and then restore it on a local or remote system. DTM ODBC Manager is an indispensable tool for DBA or developers who have to transfer data source definitions between computers and is a perfect addition to the system ODBC Administrator.[download].