Insert Data

The Insert Process obtains data from an Extract File and copies that data to a destination (one or more tables in a database). The destination can be any database located on any server in your network, including the source database. Because the object definitions are included in the Extract File, you can clone the original database, if needed.

To Insert extracted data, you create an Insert Request that contains the specifications for the Insert Process. You can process the Insert Request immediately, or use the Insert Request as a template for application‑generated jobs run from the command line, using overrides as appropriate.