User Guide : Designing and Executing Map : Setting Up Source 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 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
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.
Connections parts are displayed on the left. 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 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
Source File/URI
Click Browse and specify the source 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.
Source File
Click Browse and specify the source file.
Owner
Specify the owner.
Database Directory
Name of the database directory.
Source Database
Name of the source database.
User ID
User ID to access the source database.
Password
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 DataConnect.
Source Table
Name of the source table.
Source Table/View
Select any of the following:
Table/View
Query Statement
Query File
Database
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
ODBC Data Source Name.
Web Service URL
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
Database (Alias) name.
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 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:
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.