EMS Data Import 2007 for DB2 3.0

EMS Data Import 2007 for DB2 3.0 lets you quickly import your data from MS Excel, MS Access, DBF, TXT, CSV and XML files to DB2 tables.

It provides adjustable import parameters, including: source data formats for all the fields and destination data formats for the selected fields, commit options, number of records to skip, etc.

DB2 Data Import includes a wizard, which allows you to set all the import options for different files visually, and a command-line utility to execute import in one-touch.

Major Benefits:

1. FREE One Year of Maintenance already included!
2. FREE software updates and upgrades during Maintenance period!
3. FREE and unlimited Technical Support during Maintenance period!
4. Reasonable pricing for Maintenance renewal – from 20% per Year!
5. Volume discounts when buying two or more copies of one product
6. Cross-selling discounts on related products

Major Features:

1. Import from 10 most popular formats: MS Excel 97-2007, MS Access, XML, DBF, TXT, CSV, MS Word 2007, OpenDocument Format and HTML
2. Importing data to one or several tables or views from different databases
3. A number of import modes - Insert All, Insert New, Insert or Update, and others
4. Adjustable import parameters for each source file
5. Saving all import parameters set on current wizard session
6. Command-line utility to import data using the configuration file
7. Powerful visual options module
8. User-friendly wizard interface

Enhancements:

1. The new “Native” method of import is added which includes two algorithms – Single Commands and Batch Insert. Single Commands mode serves to generate and execute single SQL commands on the server; whereas Batch Insert uses native commands for a particular server: BULK INSERT (SQL Server), LOAD DATA INFILE (MySQL) and COPY (PostgreSQL). With the help of Native mode your data can be imported dozen (!) times faster compared to Universal mode which was used in the previous versions.
2. Unicode support. Now you are able to import Unicode data (for SQL Server, MySQL, PostgreSQL).
   
3. Import from new formats is available now:
   
   • MS Excel 2007
   • MS Word 2007
   • HTML
   • Generic XML
   • Open Document Format (Open Document Text and Open Document Spreadsheet)
4. Now there is a short field type description next to field names that appear in different lists. This option is enabled by default. When necessary, it can be disabled from Tools>Preferences.
   
5. Utility source code significantly optimized, work speed increased.
   dentity fields support implemented (for SQL Server).
   
6. Ability to import data from text files containing TAB symbols as a separator is added.
   
7. Other small improvements and bugfixes. 
   

Requirements:

• 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
• Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
• 64 MB RAM (128 MB or above is recommended)
• 20MB of available HD space for program installation
• Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
• Microsoft Mouse or compatible pointing device
• DB2 Run-Time/Administrative Client 8.0 or higher
• DB2 for Linux, UNIX and Windows