DataMate Connect 1.0

DataMate Connect 1.0 brings you a powerful tool which is featured with rich database exploration, manipulation and automation.

With DataMate Connect, the user has the finest data exploration, manipulation and automation tool available. There are many many database tools available that are good database managers - but for their specific database type only. They do not connect to other database types which makes copying data between databases very difficult and usually involves a CSV export and import. Often these tools have no automation features and the import/export facilities are often difficult to use at best. Automated scripts are the ideal tool for repetitive tasks.

With DataMate Connect, you'll be able to script the exposed .NET object model to accomplish anything you might need to do. You can use anything from the entire .NET object model - a very powerful scripting language. DataMate Connect is not meant to be a database manager. For database management, you are best off using the database manager tool which is specifically designed for that database.

Major Features:

1. Multiple database connections at once.
2. Easy Drag/Drop table copy - to the same database or to any other. For example, copy a table from a SQLite database to a SQL Server database with a simple drag/drop.
3. Easy CSV data import and export facilities (using wizards).
4. uperior Data grouping DataGrid component - easily group on any column, and any number of columns.
5. Support for all major "enterprise" databases, e.g. SQL Server, Oracle, MySQL.
6. Support for the "file-based" databases - SQLite and SQL Sever Compact Edition (CE).
7. .NET object scripting - create scripts to do repetitive tasks.
8. Connect to any OLEDB/ODBC remote database via webserver (either PHP or ASP).
9. Extensible. Create your own .NET User Controls to be added into DataMate Connect. For example, a component to graph data from SQL queries in DataMate Connect. Write any number of .NET components to be loaded into DataMate Connect by your users.
10. All file formats are supported:
    • UTF-8
    • UTF-16
    • Windows CodePage.