EMS Data Import 2007 for PostgreSQL 3.0

EMS Data Import 2007 for PostgreSQL 3.0 lets you quickly import your data from MS Excel, MS Access, DBF, XML, TXT and CSV files to PostgreSQL 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. Data Import for PostgreSQL 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. Special batch insert commands allow to import data at the maximum possible speed
4. A number of import modes - Insert All, Insert New, Insert or Update, and others
5. Secure Shell (SSH) and HTTP tunneling support
6. UNICODE support
7. Adjustable import parameters for each source file
8. Saving all import parameters set on current wizard session
9. Command-line utility to import data using the configuration file
10. Powerful visual options module
11. 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.
   
6. Identity fields support implemented (for SQL Server).
   
7. Ability to import data from text files containing TAB symbols as a separator is added.
   
8. Other small improvements and bugfixes. 

• 300-megahertz (MHz) Pentium II-compatible or faster processor; 600--megahertz (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 or more; 128 MB or more 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 video adapter and monitor recommended
• Windows compatible mouse or pointing device
• Possibility to connect to any local or remote PostgreSQL server