Specifying Target Connector, Parts, and Properties
To specify the target 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.
Connector 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 |
|---|---|
Server | The server name or the IP address. |
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. Note: You cannot paste workspace-level and project-level macro sets 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 Actian 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. |
Schema Selector | Provides a list of target tables you can use to define a schema. |
Output mode | The target connector might have one or more of the following options. Select one of the following: • Replace • Append • Delete And Append • Multimode For information about these modes, see Target Output Modes. |
5. 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.
6. Click Connect.
The connection with the target data is established and Connect is grayed-out.
7. 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:
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.
For a list of all target connector parts, see Specifying Target Connector, Parts, and Properties.
Last modified date: 07/26/2024