Connecting to SharePoint

The SharePoint site you are connecting to.

Set the URL to a Site Collection to work with all Lists and Documents in all nested Subsites. Set the URL to a specific Site to work with Lists and Documents in that Site only.

Your SharePoint user name.

Your SharePoint password.

When set to true, single sign-on (SSO) will be used to authenticate to SharePoint Online using the account specified via User and Password. Active Directory Federation Services (AD FS), OneLogin, and OKTA SSO are supported.

SSO Domain may be required if the domain configured on the SSO domain is different than the domain for User.

SSO is only applicable when using SharePoint Online. SSO is not supported for On-Premise versions of SharePoint.

Together with Password and User, this field is used to authenticate against the server. NTLM is the default option. Use the following options to select your authentication scheme:

• NTLM Set this to use your Windows credentials for authentication.
• NEGOTIATE If Auth Scheme is set to NEGOTIATE, the driver will negotiate an authentication mechanism with the server. Set Auth Scheme to NEGOTIATE if you want to use Kerberos authentication.
• KERBEROSDELEGATION Set this to use delegation through the Kerberos protocol. Set the User and Password of the account you want to impersonate.
• NONE Set this to use anonymous authentication; for example, to access a public site.
• FORMS Set this if your SharePoint instance uses a custom authentication method through a Web form.
• DIGEST Set this to use HTTP Digest authentication.
• BASIC Set this to use HTTP Basic authentication.

This property is only applicable when using single sign-on (Use SSO is set to true) and if the domain for User (e.g. user@mydomain.com) is different than the domain configured within the SSO service (e.g. user@myssodomain.com).

This property may be required when using AD FS, OneLogin, or OKTA SSO.

In some ODBC tools, (Microsoft Access, for example) the length of the primary key column cannot be larger than a specific value. This property makes the ODBC Driver override the reported length of all the primary key columns. It is especially useful when using the ODBC Driver as a Microsoft Access Linked Data Source.

Setting Limit Key Size to zero will make the key length revert to the original length.

This property controls whether or not a column is returned as SQL_LONGVARCHAR.

Some applications require all text data larger than a certain number of characters to be reported as SQL_LONGVARCHAR. Use this to map any column larger than the specified size so they are reported as SQL_LONGVARCHAR instead of SQL_VARCHAR.

This property controls whether or not string types map to SQL_WVARCHAR instead of SQL_VARCHAR. It is set by default.

String columns must be mapped to SQL_WVARCHAR to accommodate various international character sets, so Map to WVarchar is set to true by default. You may set it to false to use SQL_VARCHAR instead.

Indicates whether or not to include pseudo columns as columns to the table.

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column.

You can use an asterisk (*) to include all tables and all columns.

• Table1=Column1, Table2=Column3
• *=*

Set this property to report all identifiers, including table and column names, in uppercase. This is the default for Oracle databases and thus allows better integration with Oracle tools such as the Oracle Database Gateway. For example, you can use this property to avoid quoting identifiers.

The authentication type to use to authenticate to the Proxy Server.

This value specifies the authentication type to use to authenticate to the HTTP proxy specified by Proxy Server and Proxy Port.

Note that the driver will use the system proxy settings by default, without further configuration needed. If you want to connect to another proxy, you will need to set Proxy Auto Detect to false, in addition to Proxy Server and Proxy Port. To authenticate, set Proxy Authentication Scheme and set Proxy User and Proxy Password, if needed.

The authentication type can be one of the following:

• BASIC The driver performs HTTP BASIC authentication.
• DIGEST The driver performs HTTP DIGEST authentication.
• NEGOTIATE The driver retrieves an NTLM or Kerberos token based on the applicable protocol for authentication.
• PROPRIETARY The driver does not generate an NTLM or Kerberos token. You must supply this token in the Authorization header of the HTTP request.

This indicates whether to use the system proxy settings or not. Set ProxyAutoDetect to false to use custom proxy settings. This takes precedence over other proxy settings.

By default, the driver uses the system HTTP proxy. Set this to false if you want to connect to another proxy.

To connect to an HTTP proxy, see Proxy Server.

A user name to be used to authenticate to the Proxy Server.

The Proxy User and Proxy Password options are used to connect and authenticate against the HTTP proxy specified in ProxyServer.

You can select one of the available authentication types in Proxy Authentication Scheme.

If you are using HTTP authentication, set this to the username of a user recognized by the HTTP proxy.

If you are using Windows or Kerberos authentication, set this to a username in one of the following formats:

• user@domain
• domain\user

A password to be used to authenticate to the Proxy Server.

This property is used to authenticate to an HTTP proxy server that supports NTLM (Windows), Kerberos, or HTTP authentication. To specify the HTTP proxy, you can set Proxy Server and Proxy Port. To specify the authentication type, set Proxy Authentication Scheme.

If you are using HTTP authentication, additionally set Proxy User and Proxy Password to HTTP proxy.

If you are using NTLM authentication, set Proxy User and Proxy Password to your Windows password. You may also need these to complete Kerberos authentication.

By default, the driver uses the system proxy. If you want to connect to another proxy, set Proxy Auto Detect to false.

The hostname or IP address of a proxy to route HTTP traffic through. The driver can use the HTTP, Windows (NTLM), or Kerberos authentication types to authenticate to an HTTP proxy.

By default, the driver uses the system proxy. If you need to use another proxy, set Proxy Auto Detect to false.

This property determines when to use SSL for the connection to an HTTP proxy specified by ProxyServer. This value can be AUTO, ALWAYS, NEVER, or TUNNEL.

Auto Default setting. If the URL is an HTTPS URL, the driver will use the TUNNEL option. If the URL is an HTTP URL, the component will use the NEVER option.

Always The connection is always SSL enabled.

Never The connection is not SSL enabled.

Tunnel The connection is through a tunneling proxy. The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy.

A semicolon separated list of hosts or IPs that will be exempt from connecting through the ProxyServer.

The ProxyServer will be used for all addresses, except for addresses defined in this property.