Was this helpful?
Drop/Create Sheet
Truncate Sheet
If the Add BeforeTransformation Map Events option is not selected, the data is appended to the target.
14. Click Finish.
The Map Editor displays the new target connector with all the required information.
15. (Optional) Click Connect. The connection is established with the target.
You can now run the map.
Setting Up Multimode Target Connector Without Using Multimode Wizard
To set up the multimode target connector without using the multimode wizard:
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. Close the displayed Multimode Wizard.
4. 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).
5. Click 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.
6. 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.
7. 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.
8. Click the Mapping tab and then do the following:
a. In the Simple view, right-click a target field and select Set Actian Key to set the key field to perform an update or delete operation for the target. You may set more than one key field, which will be in priorities with the orders of these key fields.
b. Click the Advanced View icon.
In this view, the Mapping tab is split into four quadrants. To complete setting up the tables or sheets, in the Target tree view, navigate to All Record Types node and/or the All Record Instances node:
All Record Types: Select this node if you want to add one or more record layout(s) to the map (if the table or sheet does not exist) and build the schema manually. See step 17 for creating new record types.
All Record Instances: Select this node and open the Properties window from the selected instance grid. In the Properties window, specify the Target Object Name (associated with the record instance) and Target Operation (output modes are insert, update, delete, and upsert). You must set these properties for each record type or instance in the map.
9. To add a new record layout to the map, click All Record Types and then click Add Record Type icon . A new record type is added with a 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.
10. To map the source fields to this new record instance:
a. In the Targets node (lower left quadrant), expand the new 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.
11. To create any tables or sheets that do not exist:
a. Go to the Configuration tab > Map Events section, and click the icon.
The Add Map Events window is displayed.
b. In the Events section, click and select TransformationStarted from the list.
c. On the True Actions tab > Actions section, click and select TableOperation action for the TransformationStarted event.
d. In the Action Parameters section, specify the following:
operation type - Select the value as Create.
target record address - 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.
12. After all the Record Types are created, you must set the Target Object Name and Target Operation properties for each record instance. To set these properties:
a. Click All Record Instances node in the Targets quadrant (lower left quadrant).
The lower right hand quadrant displays the grid or table for All Record Instances. The Properties column displays the icon for each entry in the grid.
b. In the Properties column, click on the icon for the required entry in the grid.
The Properties dialog box is displayed.
c. Change the values for Target Operation (output mode) and Target Object Name as required.
d. Click OK to save the changes.
Repeat this process for each record instance that appears in the grid.
13. Complete mapping the fields to the record instances/layouts and/or add any required EZscript expressions.
14. Define the appropriate events and actions for your map. For each record instance, a separate event and action must be set. For information on adding events and actions, see Managing Events and Actions.
Last modified date: 08/02/2023