 |
| ||||
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 Manipulate - Clone - Horizontalize all your Data without knowing any Source or Destination Table Structures. Data Management Center reads the data directly from the files themselves and lets you handle all the necessary mappings.
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.
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 ListBox ).
Here are some key features of "Data Management Center":
· Supports migration & transfer of data across SQL Server, MySQL, Oracle, IBM DB2, SQL Anywhere, PostgreSQL, Pervasive SQL, Firebird , MS Access.
· Migration & Transfer of data from Excel, DBF, DAT, TPS and CSV (Comma Separated Value) files into databases.
· Migrates tables, indexes, constraints (depending on destination SQL) along with data .
· Supports advanced features for Data mapping during migration
· Criteria based data migration (data subsetting) is supported when migrating to any database.
· User can set the filter criteria for record(s) or column(s) based on which, only the rows matching the criteria (subset) will be migrated.
· If multiple criterias are set for a column, then the order in which they are defined will be used while migrating the data.
Limitations:
· The number of records you can insert is limited.
What's New in This Release: [ read full changelog ]
· DMC is now available from a "Web Access" Gateway for Demo or Enterprise level "one-time jobs"
· "Web Access" Enterprise license with SQL servers [MsSQL - MySQL - PostGre SQL and Firebird] & FTP access
· NEW licenses for all Non Clarion Users (NO "Port to SQL" task)
· ONLY the [Clarion] Enterprise and [Clarion] Runtime Engine licenses include the "Port to SQL" task
· Support in "Port to SQL" for arrayed columns in ALIAS Tables
· Support during Data Transfers : multiple conditions and the first record does NOT meet the condition
· SQL Test servers are now deployed on TWO distant servers [US] and [EU] (geo localized from your IP)
· Menu Files/Settings "Main Options" TAB "Check default ODBC connections" button to use these SQL distant servers
· Changed screen design in "Port to SQL" task to accept resolutions like 1320x768
· Corrected a bug when working with Oracle on a DATE Column
· Corrected a bug during a Backup SQL DB task with Non Binary Blobs
· Changed code to better support during Port to SQ...
