Configuration Parameters

Enter the path and name of the data file that should be parsed.

The encoding that was used when saving the data file

If this is left blank, the application's server default encoding will be used when parsing the file.

Determines how the file will be transferred. If the file resides locally on the application server, select Local.

• Local

• FTP

• FTPS

• SCP

• SFTP

The host name where the file is located

The port number that would be used to establish a connection

Applicable when File Transport is set to FTPS

Select the authentication method to use when connecting to the file source.

• Basic

• Client Certificate

Certificate File Path

Applicable when FTPS is set to Client Certificate

Enter the path to the client certificate file used to establish a connection to the file source.

Note
A valid certificate must be configured on the managed system.

The username used during the file transfer

The password used during the file transfer

The parsing type is only applicable for Account Attributes.

Enter which type of parsing technique, Delimited or Regular Expression, the connector should use when parsing the contents of the data file.

Applicable when File Transport is set to SFTP

Select the authentication method.

• Basic

• Public key

Private Key FilePath – Enter the private key file path that would be used to establish a connection. Applicable when SFTP is set to Public Key

Passphrase – Enter the passphrase for the private key that would be used to establish a connection. Applicable when SFTP is set to Public Key

Applicable when Parsing Type is set to Delimited

Enter the character that should be used as a delimiter.

If the delimiter is a unicode character use the \\u format.

For example, \\u0009 is used for the tab character.

Applicable when Parsing Type is set to Regular Expression

Enter the regular expression using regular expression groups that can be used to break the data into tokens.

Applicable when Parsing Type is set to Delimited

Select this option if the data file has a header defined on the first line of the file.

Applicable when Parsing Type is set to Delimited

Select this option if you want the connector to fail if all of the columns are not part of each line. Sometimes the last token is left out of the data. If this is the case in your file, select this option.

Enter the names of the columns used while parsing the file.

• If you are using the Regular Expression parsing type, this field is required.

• If you are using the Delimited parsing type, you only have to configure this field if there is no header defined or you want to rename the columns used in the buildMap rule.

Enter the number of lines to skip from the top of the data file before parsing begins.

Select this option if you want to filter out any objects that parse but have no attributes.

Enter a comment character used in the data file. Any line starting with this character will be skipped.

Enter the string representing a filter object. Any object matching the filter will be left out of the dataset and not returned.

For example, a filter that will filter out all objects from the Manufacturing department is written as follows:

department == /"Manufacturing/"

Select this option if the data for a single object spans multiple lines.

Enter the name of the index column used when finding like objects in the dataset.

Select this option if the data is sorted by the index columns.

If the data is not sorted, an in-memory representation of the data is built and used.

Select this option if you want the merge to ignore case. The sorted index must be selected.

Enter the names of the columns from the file from which values should be merged.

Select from Auto or Manual.

• Auto – Auto mode automatically calculates the number of partitions and objects per partition based on the hints provided by the aggregator.

• Manual – Manual mode allows you to specify the number of objects per partition. The objects are split as equally as possible in the partitions. By default, partitioning uses the Auto mode.

  In manual mode, you have to select the Manually Defined radio button and provide the number of objects per partition field.