Data Management Center is certified by Microsoft :
This tool is what you always wanted to have available when you were thinking of "Working on Data"
Data Management Center will let you Visualize - Manipulate - Clone - Transfer all your Data at Table or DB or Folder level : it will read the Structure from the files-tables themselves and let you handle all necessary actions (or do it for you in most cases).
You will be able - for example - to open a client's Data Base Table and import all or part of their data in your application's Tables (different Structures - you just have to do your column mappings - but can use the auto link mode)....
You will be able to open a Table in ANY format and to CLONE it's structure to ANY SQL (or to TPS - DAT - DBF) ..... and then transfer all or part of your Data
You will be able (during a data transfer to ANY SQL Table) to perform EXTERNAL TABLE lookups to use the resulting values in the destination column selected
You will be able (during data Transfers) to link multiple conditions together and also to link them each to single or linked multiple Functions so as to normalize (or clean) your data.
You will be able to read ANY Table and Visualize it's content (also to export this data to many predefined formats (HTML - PDF - Word - CSV - XLS etc ... directly from onscreen display)
(a 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 Multi Format Viewer )
You will have - in the same application - a complete multi SQL environment enabling you to View & Modify (sql queries you write) ANY SQL Data Base and all related TABLES and VIEWS
You will be able to COMPARE structures between any single Tps-Dat or SQL Table to any Tps-Dat or MULTIPLE SQL table(s) inter schema tasks are possible
DMC comes in 3 Editions :
Viewer Edition : This Edition will let you Open, Read, Query, Modify (Mass Update) and Export Data (predefined formats only) 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 Edition but are limited to evaluation mode)
Enterprise Edition : This Edition will let you do all Data Manipulations you might need (plus all of the Viewer features)
Runtime Engine Edition : This Edition will allow you to distribute to YOUR clients a small footprint DMC engine which YOUR application can "call" to allow end-users to perform Projects you ship.
The Portable feature (included in both Viewer and Enterprise Editions) enables you to CREATE directly from within DMC copies (of the licensed Edition) to carry DMC on an USB key or a Memory Card with you ....
A command line option is included in both Viewer and Enterprise Editions to run saved projects on your machine.
DMC is compiled so as to use ALL the memory your machine can offer (depending on the needs of course) ie. : it can take advantage of more than the Microsoft fixed 2 Gb limit
Key Benefits with DMC
| • | Knowledge of SQL syntax is NOT required (except for manual sql queries) , 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 an SQL Query Builder (save subsets to tables) - switch to Full Viewer etc ...) |
| • | Use DMC as Table Updater : for example, keep your Price Lists current from any odd source files .... (using the Update possibility in column mappings) |
| • | Take advantage of the full support for SQL BLOB columns |
| • | Use the possibility to read - transfer or even create GUID columns in Pervasive and Ms SQL and SQL Anywhere and PostGreSQL |
| • | Use DMC to work in Viewer on Tables with Multi Columned Primary Keys (even changing those column values from the key) |
| • | Use DMC and define yourself the CHAR SET to use so as to be fully compliant with all foreign characters (Greek-Chinese etc...) |
| • | Use Data Transfer with Conditional Mappings AND perform at the same time on the same column Mapping Options such as Functions - Operations - Concatenations etc .... |
| • | Pre Visualize immediately the destination data AFTER applying your mapping options and BEFORE transferring the data (save time) |
| • | Export the FILTERED Transferred Data list (for example on all NOT Transferred ones) |
| • | Use DMC to perform SQL DB level Backups (create "insert" scripts for all or selected Tables) and have them zipped (password protected) and sent via FTP anywhere you need. |
| • | Use DMC to perform SQL DB level or TPS-DAT FOLDER level (multiple files at the same time) clone to SQL Tasks |
| • | Use DMC to generate for you a single TXD or DCTX (clarion language) file of ALL Tables cloned during such a Task. |
| • | Use DMC to perform SQL DB level or TPS-DAT FOLDER level (multiple files at the same time) Data Transfer to SQL Tasks |
| • | Use DMC to perform External Table LOOKUPS during a Data Transfer task when working on SQL tables (use data stored in Table B while transferring data to Table A from ANY source) |
| • | Use all the power of DMC directly on your clients machines to perform any Task you predefine with the Runtime Engine Version (from Viewing tables to Data transfers or SQL Backups etc...) |
| • | Use PostGre SQL server side DEFAULTS during Data Transfer Tasks |
| • | Import - Export saved Projects and Profiles (for the runtime engine or between users) |
| • | Use Functions (like SUBSTRING) in a Condition during mapping Options when Transferring data. |
| • | SQL Server side DEFAULTS are now usable (in PostGreSQL to start) from DMC - let the server do the work! |
| • | Compare STRUCTURES between a Tps-Dat-SQL Table to another Tps-Dat-SQL Table |
| • | Compare STRUCTURES between a complete SQL DataBase to another SQL DataBase |
| • | Compare STRUCTURES between an SQL Table and Multiple SQL Tables (inter-schema compares are also possible) |
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 |
| • | If you need to Export data from a Windev HyperFile to any other format |
| • | If you are cloning a Table to SQL and your Source File contains DATE and/or TIME columns declared as LONG columns - DMC will detect those and offer you to change the Type in SQL |
| • | If you need to perform external lookups during any SQL data Transfer |
| • | If you want to let your end-users have an SQL Backup feature from your own application (Runtime Engine) |
| • | If you want to let your end-users visualize any Table from within your application (Runtime Engine) |
| • | If you want to perform data tasks directly on your end-users machine (Price List updates in your tables from ANY source etc...) from your own application (Runtime Engine) |
Supported Structures
| • | Import & Export : ASCII - BASIC (Text Files & CSV) - Clarion (DAT) - Topspeed (TPS) - Dbase FoxPro Clipper (DBF) - ODBC (SQL's) - Excel (XLS) - Access (MDB) - Windev (HyperFile) |
| • | 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) (except WD HyperFile) |
| • | Visualize your Data : ALL Formats |
IMPORTANT : ALWAYS BACKUP YOUR DATA BEFORE WORKING ON IT - THIS WILL AVOID ALL EVENTUAL PROBLEMS YOU MIGHT CREATE WITH A MISUSAGE OF THIS TOOL !
