User Guide : Designing and Executing Map : Setting Up Target Data : Specifying Connector, Parts, and Properties
 
Share this page                  
Specifying Connector, Parts, and Properties
To specify the connector, parts, and properties:
1. In the map file, click the Targets tab.
2. In the Target Properties section, specify the following:
 
Property Name
Description
Name
Displays the default name of the target. To change the name, click within the text box and type the required name. The updated file name is displayed in the Select Target drop down list and Map Navigator.
Description
Type a description for the target.
Properties
The property is Schema Mismatch. Select the required value:
Treat as Error (default value)
Use Map Schema
Use Connection, Match by Position
Use Connection, Match by Name
3. In Target Connection section, do one of the following:
From the Choose Connection drop-down list, select a connector.
In Or Connection, click Browse and select an existing connection or dataset file.
Connection parts are displayed on the left. The related connector properties are displayed on the right side in tabular format.
When you specify the connector, the following sections appear on the Targets tab:
Confirm Schema
Define Filters
Define Sample
Define Update and Delete Key Options
4. Based on the selected connector, connector parts are displayed.
The following table provides the list of parts and the descriptions. Based on the selected connector, a subset of these parts are displayed. Provide the necessary information to connect to the selected connector.
Part Name
Description
Target File/URI
Click Browse and specify the target file or URI. For information about URI, see URI Connections.
You can also right-click, select Paste macro and choose a macro.
You cannot paste workspace-level and project-level macrosets and macros. You can only paste local macros that are specific to a map or process.
Target File
Click Browse and specify the target file.
Owner
Specify the owner.
Database Directory
Name of the database directory.
Target Database
Name of the target database.
User ID
User ID to connect to the target database.
Password
Password to connect to the target database.
Note:  While passwords are masked in the UI, they are stored as plain text. They can be viewed when the artifact is opened in a text or JSON editor. Hence, it is recommended to use encrypted macros for all passwords in DataConnect.
Target Table
Name of the table in the target database or name of the new table that you want to create.
Enter a table name if you want to create a new table (make sure to add a BeforeTransformation/"Create Table" Event/Action on Configuration Map Event)
Target Table/View
Select the table name or the view
Database
Name of the database on the server.
File
Displayed for connectors where data resides in files.
Sheet
Displayed for excel connectors.
Target Data Source
ODBC Data Source Name.
Web Service URL
URL of the CRM web service.
Organization
Predefined organization that can access Microsoft Dynamic CRM data.
Member
Member of the selected file in SAS Transport Format connector.
Target Database Alias
Database (alias) name.
System Name
Name of the Pivotal system.
System URL
URL of the Pivotal system.
HTTP User ID
User ID to the Pivotal CRM system.
HTTP Password
Password to the Pivotal CRM system.
5. From the Select Output Mode drop-down list, select one of the following:
Replace
Append
Delete And Append
Multimode
For information about these modes, see Target Output Modes.
6. If you make any changes to the properties, click Refresh. For information about the target connectors and their properties, see Map Connectors.
Note:  For properties that have boolean values such as True or False, double-click on the property name to change the value. For example, if the connector is ASCII Delimited, then if you double-click on the Header property, the value changes to True. You can also select the value from the drop-down list.
7. Click Connect.
The connection with the target data is established and Connect is grayed-out.
8. If you change Target Connection information, click to prompt Map Designer to read the structure of the data from the new file. The following message is displayed:
Refresh can result in invalid expressions or lost event/actions due to field name changes. Do you want to continue?
Select or deselect the Save the map before continuing option and click OK to save the map.
Target Output Modes
The Target Output Modes are:
Replace - Creates a new target file or table, or overwrites both the data and the structure of an existing file or table. The Replace output mode is the only output mode that allows you to change the target schema. You can use the Replace output mode option with a new file or a table, if:
File or table does not exist, then Map Designer creates it using the specified layout on the Mapping tab.
File or table already exists, then the Replace mode deletes the file (or drops the table), and then recreates it using the specified layout on the Mapping tab.
You are creating a new target file or table
You want the target file to have defined Target Schema
Note:  Table settings and data are not applicable or important
When you drop a table, you also drop any indexes or constraints that the table may have.
Append - Keeps the existing records and adds new records to an existing file or table, or adds records to an empty table.
Note:  If you are working with flat files as your targets, then only Replace and Append output modes are available.
Delete And Append - Preserves the target schema and the relationships between tables (if you have defined them) and discards any existing records. It truncates the table but preserves the indexes or constraints the table may have. You can use Delete and Append output mode option if the table does not exist, then the table will be created automatically.
Usually, when mapping to a database, you will choose an existing table from a drop-down of the tables that the database contains. After you choose a table, the Target Output Mode defaults to Append and the structure of the table is defined on the Mapping tab. You can change the Output Mode to Delete and Append and map your target fields on the Mapping tab.
Multimode - Allows manipulation of multiple target tables. When you select a multimode connector, the only available output is Multimode. Hence, if you want to update, upsert, append, or delete records with a multimode connector, then you must set the Target Operation in the Advanced view for the record instance.
In any single output mode, when the transformation runs (such as insert, delete, upsert, or update), one type of operation is performed at a time. With Multimode, you can run many actions in the same transformation each time the transformation runs.