Setting Up Targets Using Multimode Connectors
Multimode connectors provide the functionality that is required to write the source data to multiple database tables or Excel sheets with different target modes or operations (insert, update, or delete) within the same map. This saves time in terms of additional map development and maintenance. For each table or sheet you want to write to, you will need the following:
• A schema (record and field definition) for the table
• An operation (delete, insert, update, and upsert)
• An object name (the name of the table you want to write to)
When you select a multimode connector, the only available output is Multimode. This means that if you want to update, append, or delete records with a multimode connector, you have to use the event actions.
This section provides information about the following: