Specifying Source Connector, Parts, and Properties
To specify the source connector, parts, and properties:
1. In the map file, click the Sources tab.
2. To add the source properties, in the Source Properties section, specify the following:
Property Name | Description |
Name | Displays the default name of the source. To change the name, click within the text box and type the required name. The updated file name is displayed in the Select Source drop down list and Map Navigator. |
Description | Type a description for the source. |
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 the Source 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 below. The related connector properties are displayed on the right in tabular format.
When you specify the connector, the following sections appear on the Sources tab:
• Confirm Schema
• Define Filters
• Define Sort Options
• Define Sample
4. Based on the selected connector, connector parts are displayed.
The following table provides a list of connector parts and their descriptions. A subset of these parts is displayed for the selected connector. Provide the necessary information to connect.
Connector Part | Description |
|---|---|
Source File/URI | Depending on the connector selected, you can 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 Source File/URI Options for more information. |
Source File | Click Browse and specify the source file. |
Owner | Specify the owner. |
Database Directory | The name of the database directory. |
Source Database | The name of the source database. |
User ID | The User ID to access the source database. |
Password | The password to access the source 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. |
Source Table | The name of the source table. |
Source Table/View | Select one of the following: • Table/View: Enter the name of the table to read from. • Query Statement: Enter the query statement. • Query File: Browse to the query file. |
Database | The name of the database on the server. |
Table | Select any of the following: • Table/View • Query Statement • Query File |
File | Displayed for excel connectors. |
Sheet | Displayed for excel connectors. |
Server | Provide the database server name or the IP address. |
Source Data Source | The ODBC Data Source Name. Note: For Snowflake connectors, specify the DSN with the Snowflake Server details. |
Source Schema | The name of the schema. |
Web Service URL | The URL of the CRM web service. |
Organization | A predefined organization that can access Microsoft Dynamic CRM data. |
Source Entity | Select any of the following: • Table/View • Query Statement • Query File |
Member | A member of the selected file in SAS Transport Format connector. |
Source Database Alias | The Database (Alias) name. |
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 |
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.
5. Click Connect.
The connection with the source data is established and Connect is grayed-out.
Note: If duplicate fields exists in the source data, then Actian DataConnect automatically updates the duplicate field name to a unique name. This helps to map the field correctly from source to target. Also, you can change the name based on your requirement.
6. If you change Source 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