The data import process is transformation data from desktop format to database system storage. In the context we dwell with automated process only: the user provides source and target storage and import properties, if necessary.
The data import is one of the most important parts of the data management workflow. There are reasons to import data:
Currently, DTM Migration Kit supports direct import from following formats: text files, DBF files, Paradox files, Microsoft Excel spreadsheets, Microsoft Access data files. Also, the import tool offers large object import from binary files.
The kit was designed as a tool for import automation. That means the user allowed to create a few import rules, unite them to project file and run it by schedule. Also, the migration software offers simple transformation functions for more complex data import process. There are character encoding modification, column mapping, source row selection modes, etc.
For example, the user can import results of the query execution to make some modifications instead of direct data import. Also, he or she can define that the program should import new rows only.
DTM Migration Kit can create new target table based on the structure of data to be imported. Otherwise, the user allowed to select existing table. The column mapping can be allied in this case. If necessary, the migration kit can remove all existing rows from the target table.