The server sets defaults to facilitate the maximum number of integrations; however, the following connection properties allow a greater granularity of customization, which is useful in advanced integrations:

• ResolveCalculatedTypes: Controls whether SharePoint calculated columns are assigned a SQL data type corresponding to the result type of their formula. When enabled, this property automatically determines the data type of each calculated column by reading the result type of its formula (such as Number, Currency, DateTime, or Yes/No) and mapping that result type to the closest native SQL type. When disabled, all calculated columns are treated as strings.
• CreateIDColumns: Indicates whether or not to create supplemental Id columns for SharePoint columns that use values from information stored in other Lists.
• FolderOption: An option to determine how to display folders in results. Enter either FilesOnly, FilesAndFolders, Recursive, or RecursiveAll.
• PseudoColumns: Indicates whether to report pseudo columns as columns in the table metadata.