Setting Up Multimode Target Connector with Compatibility Mode On
To setup a multimode target connector when compatibility mode is on:
1. In the Map Editor, on the Source tab, select the required source connector, specify the connection information and click Connect.
2. On the Target tab, and select the required multimode connector from the Choose Connector drop-down menu.
3. Specify the connection information that is required to connect to the required database or file. For example, Target Database Alias, Data Source, User ID, and so on for a database connection and File for Excel (xlsx).
4. Click 
icon next to Schema Selector.
icon next to Schema Selector. The Multimode Table/View Selector dialog is displayed. Select the required table schema. The selected table schema provide the required structure to visually represent the table(s) or file(s) as a record layout (named as selected table name plus "_1") on the Mapping tab. A default Target record layout R1 is automatically created when the target connector is selected. Make sure to select the Replace existing layouts option on the dialog, if you want to use the selected table (file) as a record layout.
If you want to write to a new table or file using a schema that does not exist, then perform step 7 and 8 to add additional record types to your map.
5. Specify the values for the connector properties if the default values are not appropriate. For more information about connector properties, see the connector specific topics available in the Map Connectors section.
6. Click Connect.
The connection is established with the target. You can now map the source fields to the target. If you want to disconnect from the target, click Disconnect.
7. In the Map editor, click the Mapping tab and then click the 
Advanced View icon.
Advanced View icon. In this view, the Mapping tab is split into four quadrants.
8. To add a new record layout to the map, click All Records and then click Add Record icon 
. A new record type is added with the default Name and Length as 0. You can edit the Name in the target grid (lower right quadrant). The Length is automatically updated after the fields are mapped to this new record type.
. A new record type is added with the default Name and Length as 0. You can edit the Name in the target grid (lower right quadrant). The Length is automatically updated after the fields are mapped to this new record type. 9. To map the source fields to this new record instance:
a. In the Targets node (lower left quadrant), expand the record instances until you see the required record instance (selected table name plus “_1”).
b. Click the required record instance to display the record layout in the lower right quadrant.
c. Navigate to the appropriate view in the Sources node in the upper left quadrant and drag/drop those fields to the new target.
10. To create any tables or sheets that do not exist:
a. Go to the Configuration tab > Map Events section, and click the 
icon.
icon.The Add Map Event(s) window is displayed.
b. Select BeforeTransformation and click Next.
c. In the Actions section, click 
and select Create table action for the BeforeTransformation event.
and select Create table action for the BeforeTransformation event. d. In the Action Parameters section, specify the following:
– target name - Select the value as Target.
– record layout - Select the record.
– table name - Select the appropriate table or sheet name. You may have to add additional operations to drop or truncate this table if the map is run multiple times.
e. Click Finish to close the window.
11. For each record instance, a separate event and action must be set. For information on adding events and actions, see Events and Actions for XML Maps (When v9 Compatibility Mode is Enabled).
12. Complete mapping the fields to the record instances/layouts and/or add any required EZscript expressions.
Last modified date: 08/02/2023