|
|
|
Product Line and Roadmap
Information presentation and modification
| Database Schema |
View option |
Modification option |
| Object Tree |
DTM SQL editor, DTM Schema Inspector DTM Data Editor *)
DTM Data Modeler *)
DTM Schema Comparer *)
|
N/A |
Report (Word, HTML, text, XML, CHM, PDF, Excel) |
DTM Schema Reporter |
N/A |
| ER-model |
DTM SQL editor DTM Schema Reporter DTM Data Generator |
DTM Data Modeler |
| Data |
View option |
Modification option |
| Data Grid |
DTM Data Editor DTM SQL editor |
DTM Data Editor |
Report/Export (Word, HTML, text, XML) |
DTM SQL editor, DTM Migration Kit DTM Query Reporter |
N/A |
| Import/Migration |
|
DTM Migration Kit |
| SQL statements |
DTM SQL editor |
DTM SQL editor |
Options and Features
| Option/Feature |
Supported by |
| Export: query results | DTM SQL editor DTM Migration Kit DTM Query Reporter |
| Export: table rows | DTM SQL editor DTM Migration Kit |
| Export: a few tables | DTM Migration Kit |
| Export Automation, bulk export | DTM Migration Kit |
| Data Import, Import Automation | DTM Migration Kit |
| Data/Schema Migration | DTM Migration Kit |
| Random Data Generation | DTM Data Generator |
| Data and BLOBs modification | DTM Data Editor |
| Data Audit | DTM Data Scrubber |
| Data Cleaning/Scrubbing | DTM Data Scrubber |
| Data Comparison | DTM Data Comparer |
| Data Synchronization | DTM Data Comparer |
| Database Schema Comparison | DTM Schema Comparer |
| Database Schema Synchronization | n/a |
| Database Stress Testing | DTM DB Stress DTM Data Generator *) |
Legend:(New option in existing product) (New product)
* - partial supported
Products descriptions
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. 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 two
versions of the tool. [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
even 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
[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), 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 data that has 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 DBMSs 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.
[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 DBor 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
compare 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
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 Schema Inspector is a database schema browsing and management tool. This
utility helps the user to navigate a few schemas from different databases or servers at one time.
[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 is occur. [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 DBAs or developers who have to transfer data source definitions between
computers and is a perfect addition
to the system ODBC Administrator.
[download].
|
|
|