Setting Up Multimode Target Connectors
Multimode connectors allow you to write the source data to multiple database objects with different target modes or operations (insert, update, or delete) within the same map. An object is usually a Table. It can be a Sheet in case of Excel or Entity in case of Salesforce. This saves time in additional map development and maintenance.
Multimode target connectors allow you to:
• Perform multiple operations (insert, upsert, update, or delete) on the same object. However, each operation requires its own record layout.
• Perform the same operation on different objects. Each object requires its own record layout.
• Perform different operations on different objects.
For each target table or sheet you want to write to, you need the following:
• A schema (record and field definition) for the object
• An operation (delete, insert, update, and upsert)
• An object name (example, the name of the table you want to write to)
When you select a multimode connector, the available output mode is Multimode only. This means that if you want to update, append, or delete records with a multimode connector, you must specify the target operation from Target Properties.
For some multimode connectors, objects must be created before the data can be written to them. In this case:
• If the object does not exist, the map needs a TransformationStarted map event with a TableOperation action, listing the table to be created and the record layout (record instance) that must be used to create the object columns.
• If the object exists, you can write to the object with no TransformationStarted event or actions. You can use this event or action if you want to drop, truncate, or create the object every time the map is run. However, this is not mandatory.
The operation and the object being operated on is stored on the record instance (not the record type). You must go to Advanced Mapping view for editing these objects.
Topics:
Last modified date: 12/03/2024