Additional Connection Parameters Information

  • Fetching of case-sensitive data – By default, only records that are of the same case (case-sensitive) as provided in the string are fetched.

    For example, if the query is written as follows, then only data with Abc is fetched and data with ABC is ignored.

    select * from [file] where column3 = 'Abc'

    To fetch all matching records, regardless of case (case-insensitive) as mentioned in the above example, add the following attribute with the value as true in the Additional Connection Parameters field:

    caseInsensitive=true

  • UTF Characters – If the CSV or text file has any UTF characters, add an additional charSet property in the Additional Connection Parameters field.

    For example:

    charSet=UTF8

  • _CSV_Header – If the CSV data is provided with column headers as the first column then add the _CSV_Header attribute in the Additional Connection Parameters field as follows:

    _CSV_Header=true