EMS Data Import for DB2

What is EMS Data Import for DB2?

EMS Data Import for DB2 is a powerful tool for importing data into DB2 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 DB2 target data fields and formats for the selected fields, commit options, number of records to ignore, etc. Data Import for DB2 includes a wizard, which allows you to set all DB2 import options for different files visually, and a command-line utility to perform the import to the db2 database DB2 data with 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

• 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
• DB2 Run-Time / Administrative Client 8.0 ou superior
• IBM DB2 Connect (no case of using servers gives platform z / Series, iSeries, pSeries)