Overview of this example

The following describes how to convert from CSV to database table format.

  • Conversion from CSV format to database table format

Figure 8.37 Conversion from CSV format to database table format

= Remarks =

In this example, Oracle is used as database, but the download module and installation media contain SQLite3 samples.

To use Oracle, after carrying out Oracle configuration procedures described in DataMagic Installation Manual, change the settings in database connection information as below.

  • Change Product type to Oracle

  • Set Database name or TNS (and Host name and Port No. if Database name is selected)

  • Set User and Password