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 Appendix A - Uniform Resource Identifier.
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 - Creates a new target file or table, or overwrites both the data and the structure of an existing file or table.
• Append - Keeps the existing records and adds new records to an existing file or table, or adds records to an empty table.
• Update - Searches an existing target file for a match in the key fields that you have defined in Add Target Fields to Match dialog box and updates the data in the specified manner. This option is available when you have selected an ODBC, dBASE, or SQL target connector.
• Delete And Append - Preserves the target schema and the relationships between tables (if you have defined them) and discards any existing records. This option is available when you have selected an ODBC or SQL data source.
• Delete - Searches an existing target file for a match in the key fields that you have defined in Add Target Fields to Match dialog box and deletes data in the specified manner. This option is available when you have selected an ODBC or SQL target.
• Multi - Allows manipulation of multiple target tables. This is the only option available when you have selected a multi-mode connector such as SQL Script or Oracle 8.x multi-mode.
6. If you make any changes to the properties, click Refresh. For information about the target connectors and their properties, see 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 source or target files, click Refresh icon to prompt Map Designer to read the structure of the data from the new file. The following message is displayed:
9. Click Save to save the connection.