Once you identify the requirements for moving data from an external data source to a database, you must select the components the script will use to execute the job. Consider the following types of components:
- A producer operator that reads data directly from the external source and places it in the data stream.
or
- A producer operator that uses an INMOD routine or access module to access data from an external source and then pre-process the data before sending it into the data stream.
and
- A consumer operator that takes data from the data stream and writes it to the database.