EMS Data Import for PostgreSQL

What is EMS Data Import for PostgreSQL?

EMS Data Import for PostgreSQL is a powerful tool for importing data into PostgreSQL tables from MS Excel, MS Access, DBF, XML, TXT, CSV, CSV, MS Word, RTF, ODF, and HTML files.

It provides adjustable import parameters, including source data formats for all PostgreSQL target data fields and formats for the selected fields, commit options, number of records to ignore, etc. Data Import to PostgreSQL includes a wizard, which allows you to set all PostgreSQL Import Options for different files visually,  and a command-line utility to perform the import to the PostgreSQL database in one touch.

Core features

• Import from the 10 most popular formats: MS Excel, MS Access, XML, DBF, TXT, CSV, MS Word, OpenDocument Format, and HTML.
• Importing data to one or more tables or visualizations from different databases.
• Special batch insertion commands allow you to import data at the maximum possible speed.
• Multiple import modes - Insert all, insert new, insert or update and others.
• Secure Shell (SSH) and HTTP encapsulation support.
• UNICODE support.
• Adjustable import parameters for each source file.
• Saving all import parameters defined in the current wizard session.
• Automatic creation of the table structure.
• Command-line utility for importing data using the configuration file.
• Powerful module of visual options.
• Amazon RDS support for PostgreSQL, Amazon Redshift.

System requirements

Microsoft® Windows XP, Microsoft® Windows 2003 Server, Windows® 2008 Server, Microsoft® Windows Vista, Microsoft® Windows 7, Microsoft® Windows 8, Microsoft® Windows 8.1, Microsoft® Windows 10

512 MB of RAM or more

50 MB of available HD space for program installation

Possibility to connect to any local or remote PostgreSQL server