| Name |
Default |
Description |
| Server |
- |
The IP or hostname of the SharePoint server. Required.
Example: localhost, 192.168.0.1, http://mysharepointsite.com,
https://mysharepointsite.com
- You can add the https:// prefix to enable SSL/TLS encryption
and override the SSL option.
- You can specify the port to use in the server string, for
example: 192.168.0.1:81 or https://mysharepointsite.com:444.
|
| Database |
- |
Corresponds to a site path on the SharePoint server, e.g.
"marketing" or "marketing/news".
This site is where your lists and libraries will be selected from.
Leave empty to select the top site. |
| User |
- |
User name of the account used to access SharePoint. This
account must have sufficient privileges to access the provided
site. Required when server uses authentication mode [Ntlm] or
[Basic]. |
| Password |
- |
SharePoint account password. |
| Domain |
- |
The domain of the specified user.
Leave empty if domain user account is not used. |
| Authentication |
Ntlm |
Indicates the authentication mode used to connect to the
SharePoint server.
[Default]: Use the credentials from the current security context.
No specific account details should be provided. Set this mode when
SPC is used in components running inside SharePoint, such as in
webparts. The connector is then authenticated as the current
user.
[Ntlm]: Specifies client authentication using Ntlm. This is the
most common scenario.
[Basic]: Specifies that user authenticates to the server using
basic authentication which is a simpler less secure form. |
| SSL |
False |
Boolean value indicating whether connecting to SharePoint using
HTTPS. |
| SSLAcceptAll |
True |
Specifies whether SPC should accept all certificates over HTTPS
(less secure), for example self signed certificates. Enhance the
security by setting this to False. This however requires that the
server certificate is valid. |
| MaxBytesPerRead |
32768 |
Sets the maximum data size in bytes returned by the underlying
connection per read. Increase this when necessary.
Read more on msdn. |
| MaxReceivedMessageSize |
524288 |
Sets the maximum total data size in bytes that can be received
by the underlying connection. Increase this when necessary.
Read more on msdn. |
| MaxArrayLength |
16384 |
This option is rarely specified.
Read more on msdn. |
| MaxDepth |
32 |
This option is rarely specified.
Read more on msdn. |
| MaxNameTableCharCount |
16384 |
This option is rarely specified.
Read more on msdn. |
| MaxStringContentLength |
8192 |
This option is rarely specified.
Read more on msdn. |
| TimeOut |
60 |
Sets the timeout limit in seconds when receiving and sending
data. Increase this when necessary. |
| RecursiveMode |
RecursiveAll |
Indicates how to handle SharePoint lists with subfolders when
performing SELECT commands.
[FilesOnly]: Select list items (not folders) from the current
folder only.
[Recursive]: Select list items (not folders) from the current
folder and all subfolders recursively.
[RecursiveAll]: Select list items and folders from the current
folder and all subfolders recursively. |
| StrictMode |
True |
When True SPC always validates values being updated (size,
limits, etc) before executing INSERT and UPDATE commands. Set to
False to disable all validation and leave this to SharePoint. This
option is rarely specified.
Note: The SharePoint API is much less restrictive than in the user
interface and does not always respect column settings. |
| DecodeName |
True |
Obsolete! True means that special
characters in column names are automatically decoded when
performing SELECT commands. This option is rarely specified. |
| DefaultLimit |
0 |
Indcates the default max number of rows returned from SELECT
commands. Zero means SharePoint default setting, typically 100
rows. Increase this to select more data from larger lists.
Note: This value is always overridden if LIMIT clause is provided
in the SELECT command. |
| CacheTimeOut |
30 |
Controls the timeout limit in seconds for the SPC schema
caching mechanism. To increase performance, schemas are
automatically cached for a limited amount of time. |
| NoListFilters |
False |
Specify True to disable all list filters when selecting data.
By default, when selecting rows from a list, any filters configured
on the views in SharePoint will also apply to the selected content.
In some cases this is not the desired behavour. |
| ExpandUserFields |
False |
Specify True to make user columns include login name, e-mail
address, Session Initiation Protocol (SIP) address, and title. By
default, user columns show only ID and Name. |