|
Data Management Center
 Data Management Center is certified by Microsoft : "Works with Vista" and "Works with Windows Server 2008" 
This tool is what you always wanted when you were thinking of working & Importing or Exporting Data : a dream come true ?
The main problem in the world of Data Manipulation - Transfers is STRUCTURES.
Indeed, normally it is easy to transfer data from one Table to another IF you know the structure of your Tables AND IF you have the possibility to implement these structures in your application.
This tool will let you Visualize - Manipulate - Clone - Horizontalize all your Data WITHOUT knowing any Source or Destination Table Structures : it will read it from the files themselves and let you handle all necessary actions.
You will be able - for example - to open a client's Data Base and import all or part of their data in your application's Tables (different Structures - you just have to do your column mappings)....
You will also be able to open a Table in ANY format and to CLONE it's structure to ANY SQL (or to TPS - DAT - DBF) .....
You will be able to open ANY source Table and decide to "Horizontalize" the Data to a specific Structure in ANY destination Format
You will be able to use this tool to just open ANY table and Visualize it's content (also to export this data to many predefined formats (HTML - PDF - Word - CSV - XLS etc ... directly from the List Box )
A simple double-click on any DAT - DBF or TPS table in Windows Explorer will open the file for you with DMC with all the features attached to this new Multi Format Viewer.
DMC comes in THREE VERSIONS :
DMC Viewer : This version will let you Open, Read, Query, Modify and Export Data from ANY Table wether it is an MDB, a DBF, an XLS, a TPS (etc...) or even any SQL table
(all the Enterprise features are included in this version but are limited to evaluation mode)
Enterprise : This version will let you do all Data Manipulations you might need plus all of the Viewer features
DMC Portable : This version which you CREATE directly from within your copy (reserved to multi copy licenses) enables you to carry a copy of DMC on an USB key or a Memory Card with you ....
A command line (Runtime version) is included in ALL versions to let your clients benefit of all the power of DMC without really having to use it!
Key Benefits with DMC
| • | Knowledge of SQL syntax is NOT required, all is automatically done for you. |
| • | Rapid data migration across databases ensuring data integrity with no loss of data. |
| • | Migrate & Transfer data across databases deployed on different platforms (Windows or Unix or Linux). |
| • | Migrate & Transfer data locally or on distant servers. |
| • | Provides an uniform approach for migration across different databases. |
| • | Save you specific settings & mappings in Profiles for further use and time saving. |
| • | A few clicks will let you clone ANY Source structure to SQL or to TPS (with a user modifiable script) |
| • | Easy to Install and Easy to Use tool with user friendly WIZARDS & intuitive User Interface. |
| • | Generate any quantity of random test data. |
| • | Open an existing Table, launch or restore a saved Query to obtain a subset, then export this subset 'as is' directly to many predefined formats |
| • | Use DMC Viewer as a very powerful Multi Format Viewer replacing many different separate softwares |
| • | Use DMC Viewer to open ANY table and add / delete records (TPS and Ms SQL - MySQL only) on the fly |
| • | Use DMC Viewer to open ANY table and modify any column in any record etc... |
| • | Use DMC Viewer to EMPTY any Table (all) or to BUILD all the Key's (TPS & DAT) |
| • | Use DMC Portable to work at your clients sites |
| • | Use DMC as an SQL environment Tool (switch between ALL registered DB's and list Tables - Key's & Columns - use a Query Builder - Direct Viewer access etc ...) |
| • | Use DMC as Table Updater : for example, keep your Price Lists current from any odd source files ....
When and How can DMC help you? |
| • | Moving data to a new database : Cloning to SQL will create and copy data from one database to another (even across heterogeneous databases) |
| • | Upgrading to new version of the database : Move data from one version of the database to another (ie: SQL Server to Oracle) |
| • | Filtering Data (data sub setting) : Migrate - Copy data based on simple as well as complex criteria(s). |
| • | Data (transformation): Migrate table and data applying wide range of mapping options. |
| • | Options include, data type mapping, selecting specific columns, column mappings etc., that can be applied during migration |
| • | Adding new data to existing database : Copy or add new data to existing tables in a database |
| • | If you have data stored in any structure and simply need to quickly visualize it (deciding how many records to edit) |
| • | If you have data stored in any structure and need to get it transferred into a different structure |
| • | If you need to migrate your data from ANY source to SQL or TPS - use the powerful feature of Cloning tables |
| • | If you need to create (and use immediately) a new TPS or SQL table - use the Creation Wizard |
| • | If you need to be able to have a TPS table created from a TXT structure file |
| • | If you need to be able to export to a text file (CSV or TXT) any existing data |
| • | If you want to be able to filter records from being transferred using all the power of mappings |
| • | If you have data stored in a table and need to modify some records and transfer only those records to the same or different Structure |
| • | If you have a new client who wants his own data integrated in your application tables |
| • | If you have existing data and need to merge it in other existing data |
| • | If you need to get instantly a Table converted to TPS and be able then to import that table in your dct |
| • | If you need to send some data in XML - WORD - HTML - PDF - XLS etc... format to a client (filtered & mapped if need be) |
| • | If you need to get on the fly a TXT file of the structure of your Tables |
| • | If you need to Horizontalize your data (transfer x records to x columns in 1 record) |
| • | If you need to have only one reliable tool to access ANY and ALL of your Data Tables |
| • | If you need to visit clients and work on their Data : use the Portable Version |
| • | If you need to work on ANY SQL DB and Tables without changing tools for each SQL (Queries on Single or Multi Tables and export subsets - Viewer - Data Generator etc....) |
| • | If you need to UPDATE a Table with values from other tables (use the UPDATE mapping feature) |
| • | If you need to have your clients use DMC to transfer data from a command line argument Runtime Version |
Supported Structures
| • | Import & Export : ASCII - BASIC (Text Files & CSV) - Clarion (DAT) - Topspeed (TPS) - Dbase (DBF) - ODBC (SQL's) - Excel (XLS) - Access (MDB) |
| • | Export Only : Extended Markup Language (XML) - (plus : PDF - HTML - CSV - WORD - XLS) |
| • | Clone SOURCE : ALL Formats |
| • | Clone DESTINATION : TOPSPEED (TPS) - Clarion (DAT) - DBase Foxpro Clipper (DBF) - ODBC (SQL's) |
| • | Visualize your Data : ALL Formats |
IMPORTANT Vista Note : under this OS you HAVE to run DMC as Administrator (for ODBC connection rights) and DMC is compiled in such a way to let you use it without having to bother about settings (it runs elevated).
| 
