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 |
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 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.
Connector Part | 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 Actian DataConnect. |
Source Table | 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 | 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. |
Access Token | Provides access to HubSpot. |
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: 12/03/2024