The following tables describe the connection properties by functionality.

OAuth 2.0 properties

The following table summarizes properties used for OAuth 2.0 authentication. The OAuth 2.0 properties you must specify depend on the grant type used in your environment. If you are unsure of the grant type or its requirements, contact your system administrator.

Property Default
AccessToken No default value
AuthURI No default value
ClientID No default value
ClientSecret No default value
RefreshToken No default value
Scope No default value
ServiceURL No default value
TokenURI No default value

Mapping properties

The following table summarizes connection properties involved in mapping the Dynamics 365 data model to a SQL model.

Property Default
CustomPrefix Include
CustomPrefixName new_
KeywordConflictSuffix No default value

Web service properties

The following table summarizes Web service connection properties.

Property Default
StmtCallLimit 0 (no limit)
StmtCallLimitBehavior ErrorAlways

Additional properties

The following table summarizes additional connection properties.

Property Default
BatchUpdateChunkSize 200
FetchSize 100 (rows)
ReadOnly true