EMS Data Import for PostgreSQL is a desktop application designed to simplify and automate the process of importing data into PostgreSQL databases. It supports a wide range of source formats, including MS Excel, MS Access, DBF, XML, TXT, CSV, MS Word, RTF, ODF, and HTML. The tool offers both a graphical wizard for step-by-step configuration and a command-line utility for automation. It enables users to map fields, adjust import parameters, and handle multiple tables or views, making it suitable for both routine and complex data migration tasks. The application also supports SSH and HTTP tunneling for secure connections and provides options for batch inserts, different import modes, and automatic table creation.

Key Features

Import from Multiple Formats Import data from 10 popular file formats into PostgreSQL tables.

• Supports Excel, Access, DBF, XML, TXT, CSV, Word, RTF, ODF, HTML
• Handles different field types and data structures

Batch and Flexible Import Modes Choose how data is imported to suit different scenarios.

• Insert All, Insert New, Insert or Update, and other modes
• Batch insert commands for maximum speed

Visual and Automated Operation Configure imports visually or automate via command-line.

• Step-by-step wizard for easy setup
• Command-line utility for scripting and automation

Advanced Configuration and Security Fine-tune import parameters and ensure secure data transfer.

• Adjustable parameters for each file
• SSH and HTTP tunneling support

Table Creation and Parameter Saving Automatically prepare database structures and reuse settings.

• Automatic creation of table structure if needed
• Save and reuse import parameters from wizard sessions

Benefits

Efficient Data Migration Simplifies and accelerates the process of moving data into PostgreSQL.

• Reduces manual effort with automation and batch processing
• Handles large volumes and complex data mappings

Flexibility and Customization Adapts to various data sources and project requirements.

• Supports multiple file formats and import modes
• Customizable import settings for each scenario

Reliability and Security Ensures data integrity and secure connections.

• Supports UNICODE and secure tunnels
• Handles field mapping and structure creation accurately