EMS Data Import for Oracle

What is EMS Data Import for Oracle?

EMS Data Import for Oracle is a powerful tool for importing data into Oracle tables from MS Excel, MS Access, DBF, XML, TXT, CSV, MS Word, RTF, ODF, and HTML files. It provides adjustable import parameters, including source data formats for all target Oracle fields and data formats for selected fields, confirmation options, number of records to ignore, etc. Data ImportforOracle includes a wizard, which allows you to set all import options for Oracle for different files visually and a command-line utility to perform the import to the Oracle 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.
• Multiple import modes - Insert all, insert new, insert or update and others.
• 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.

System requirements

300 MHz processor; Recommended 600 MHz (MHz) processor

Microsoft Windows NT4 com SP4 ou posterior, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows 2008 Server, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8, Microsoft Windows 8.1, Microsoft Windows 10

64 MB of RAM or more; 128 MB or more recommended

20 MB 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 is recommended

Microsoft mouse or compatible pointing device

Oracle Client 8.1.7 ou superior

Possibility to connect to any local or remote Oracle server as a destination and an ADO-compatible source