Setting Up Multimode Target Connectors with Compatibility Mode Off
You can set up a multimode target connector in a map in the following ways when compatibility mode is off:
Setting Up Multimode Target Connector Using Multimode Wizard
You can use the Multimode Wizard when you select a multimode connector from the list of connectors on the
Targets tab. Once the connector is selected, the Multimode Wizard appears and assists in configuring the connection. If you want to setup the multimode target connector without using the wizard, then close the wizard and perform the steps provided in
Setting Up Multimode Target Connector Without Using Multimode Wizard.
Note: The Multimode Wizard is available for all Multimode Target connectors except for the JSON and XML-DMS connectors. Also, only single record targets are currently supported within the Wizard (multi-record layouts must be configured manually).
The wizard will assist in performing the following tasks:
• Specifying connection details: Provide information such as server details, user ID and password, and connector properties.
• Selecting target objects: You can write to a new object or one or more existing objects, but cannot perform both.
• Choosing a target schema: You can associate a schema with the target object using one of the available options:
• Use source schema: When creating a new object, you can use this option to apply the schema that has been defined on the source connection, to the new target object.
• Use existing Table(s): When the Existing Table(s) option has been selected in the wizard, this option applies the existing schema(s) for the selected objects.
• Use an external schema: Manually browse and select a saved schema from disk.
• Manually create schema: Create a single record layout with one field. You can manually add more fields to this schema from the Mapping tab.
• Selecting operations, objects, and keys: By default, the operation is Insert. The other operations are update, upsert, and delete. Object is the table or sheet you are writing to. If the operation is not Insert, then the keys (fields) are required.
• Setting auto-mapping and BeforeTransformation Event options:
• You can automatically map the fields from source to target using the Match by Name or Match by Position options. If the source connector is not defined, then you cannot automatically map the fields.
• BeforeTransformation event: You can add a BeforeTransformation event to initialize the objects. When this event occurs, you can either drop and create an object or truncate (replace) the object.
If you do not specify the BeforeTransformation event, then when the map is run, the engine appends records to the target object.
To setup multimode target connector using the Multimode wizard with compatibility mode off:
1. In the Map Editor, on the Sources tab, select the required source connector, specify the connection information and click Connect.
2. On the Targets tab, select the required multimode connector from the Choose Connector drop-down menu.
The Multimode Target Wizard is displayed.
3. Specify the target session details such as Server, Data Source, User ID, Password, and the connector properties and click Next.
4. After you have specified all the target session details, click Next.
The Target Sheets/Tables window is displayed.
Note: If the connector is Excel-based, then it is Target Sheets. For other multimode connectors, it is Target Tables.
5. Select one of the following:
• New Sheet/Table
• Existing Sheet(s)/Table(s)
6. If New Sheet/Table option is selected, then in New Sheet Name/New Table Name, specify a name for the sheet and click Next.
7. If Existing Sheets/Tables option is selected, then in Select Existing Sheet(s)/Table(s) section, select the check box for the required sheets/tables and click Next.
The Target Schema window is displayed.
8. Select one of the following to choose the schema origin:
• Use source schema: Use the schema provided in the source.
• Use existing Sheet(s)/Table(s): Use the existing schema(s) for the selected sheet(s)/table(s).
• Use an external schema - Use an external schema by specifying the file in the External Schema option.
• Manually create schema - Default record and field will be generated by the wizard. The layout will be displayed on the right hand side of the dialog. You can manually edit the schema on the Mapping tab.
The selected schema origin table is displayed on the right-side of the window.
9. Click Next.
The Multimode Operations window displays with All Instance Records table for the target.
10. Specify the following for each record or use the default values:
• Target Operation - Select Insert, Update, Delete, or Upsert.
• Target Object Name - Click within the cell to modify the object name. Also, specify the keys (fields).
11. Click Next.
The Auto Mapping and Before Transformation Event Options window is displayed.
12. To automatically map the fields from source to target, in the Target Field Auto-Mapping Options section, select the Auto map from source to target. The following options are available:
• Auto map field by Name - Map fields from source to target by name automatically.
• Auto map field by Position - Map fields from source to target by position automatically.
If the Auto map from source to target option is not selected, then you must map the fields manually on the Mapping tab.
13. To initialize the sheets/tables, in the Sheet Initialization Options section, select Add BeforeTransformation Map Events. The following options are available: