EMS Data Import for DB2 is a software tool designed to facilitate the import of data from multiple file formats-including MS Excel, MS Access, DBF, XML, TXT, CSV, MS Word, RTF, ODF, and HTML-directly into IBM DB2 database tables. It offers both a visual wizard for step-by-step configuration and a command-line utility for automated, scriptable imports. The tool supports various import modes and provides flexible options for mapping data fields and managing import sessions.

Key Features

Multi-format Data Import

• Supports importing from 10 popular file formats (Excel, Access, DBF, XML, TXT, CSV, Word, RTF, ODF, HTML).
• Enables import into one or multiple DB2 tables or views.

Flexible Import Modes

• Offers modes like Insert All, Insert New, Insert or Update.
• Allows customization of import behavior per file.

Visual Wizard and Command-Line Utility

• Step-by-step wizard for configuring import options visually.
• Command-line tool for batch or scheduled imports using configuration files.

Adjustable Import Parameters

• Customize source and destination data formats for each field.
• Set commit options, record skipping, and more.

Session Management

• Save import parameters from current wizard sessions for reuse.
• Supports automatic creation of table structures if needed.

Benefits

Streamlined Data Migration

• Reduces manual effort in transferring data to DB2.
• Minimizes errors with visual and automated tools.

Increased Flexibility and Control

• Accommodates diverse data sources and import scenarios.
• Enables both one-time and recurring import tasks.