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 See Also: |
3. In Target Connection section, do one of the following:
• From the Choose Connector 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 a list of parts and their descriptions. A subset of these parts is displayed for the selected connector. Provide the necessary information to connect.
Connector Part | Description |
|---|---|
Server | The server name or the IP address. |
Target File/URI | Depending on the connector selected, either a Browse button or a Configure button available. Do one of the following: • Click Browse and specify the source file or URI. You can also right-click, select Paste macro and choose a macro. For more information about URI, see URI Connections. 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. • Click Configure to auto-generate a URI. This option is available if the connector supports the use of a file URI. See Target File/URI Options for more information. |
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 TransformationStarted/"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 | The ODBC Data Source Name. Note: For Snowflake connectors, specify the DSN with the Snowflake Server details. |
Target Schema | The name of the schema. |
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. |
Access Token | Provides access to HubSpot. |
Data Center | The Mailchimp server location. |
API Key | The password for authenticating a request to the Mailchimp Marketing API. |
Resource | Select a resource. |
Primary Resource ID | Select a primary resource id, which is used to build the URL path. This connector part is only available when a sub-resource exists. |
Sub Resource ID | Select a sub-resource id, which is used to build the URL path. This connector part is only available a sub-sub-resource exists. A sub-resource is primary resource + // + path minus id. For example: lists//members/events where • lists is the primary resource • members/events is the path minus id • the complete path is {list_id}/members/{subscriber_hash}/events |
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.
Last modified date: 09/22/2025