EMS Data Import for PostgreSQL is a data import tool that allows users to import data to PostgreSQL tables from various file formats such as MS Excel, Access, DBF, XML, TXT, CSV, and more. It offers customizable import settings and can handle a wide range of source data formats.
One of the key benefits of EMS Data Import for PostgreSQL is that it provides you with adjustable import parameters. This means that you can configure source data formats for all fields and destination PostgreSQL data formats for selected fields, as well as customize other elements such as commit options and the number of records to skip. The software also includes a wizard to help you set PostgreSQL import options for different files visually and a command-line utility to execute import to PostgreSQL database in one-touch.
Some of the key features of this software include support for importing from the 10 most popular file formats, importing data to one or several tables or views from different databases, special batch insert commands to import data at maximum possible speed, and several import modes such as Insert All, Insert New, Insert or Update, and others. You'll also appreciate that the software provides support for Secure Shell (SSH) and HTTP tunneling, UNICODE support, and an automatic creation of the table structure.
Finally, EMS Data Import for PostgreSQL stands out for its powerful visual options module. This feature-rich software is an excellent choice for those who need to import data to PostgreSQL tables quickly and efficiently.
Version 3.3:
Added the possibility to automatically form fields when importing from TXT, CSV and XML formats to a new table.
Now the user can choose the necessary encoding, including UTF8, when importing from DBF files.
Other improvements and bugfixes.
Version 3.1:
- Importing data from the text of XML documents embedded nodes
- Ability to explicitly specify the data file for the console version using the -datafile= parameter
- Auto-recognition of columns and autofill of table fields for TXT files
- Other minor improvements and bugfixes
Version 3.0:
- The new “Native†method of import is added which includes two algorithms – Single Commands and Batch Insert.
- Import from new formats.
- Utility source code significantly optimized, work speed increased.
- Unicode support.
- Other improvements and bugfixes.
Version 3.1:
- Importing data from the text of XML documents embedded nodes
- Ability to explicitly specify the data file for the console version using the -datafile= parameter
- Auto-recognition of columns and autofill of table fields for TXT files
- Other minor improvements and bugfixes
Version 3.0:
- The new “Native†method of import is added which includes two algorithms – Single Commands and Batch Insert.
- Import from new formats.
- Utility source code significantly optimized, work speed increased.
- Unicode support.
- Other improvements and bugfixes.
Version 2.2:
- The ability to import data from VisualFoxPro DBF format added.
- The amount of memory consumed is significantly decreased when importing large files.
- Other improvements and bug-fixes.